functions are available with MS-Excel..
1.count and sum
2.cell references
3.data and Time
4.text
5.lookup and reference
6.finanical
7.round
8.array formula
The answer for the first one is proximity.
The term proximity means “closeness”. The relationship between each other can be described by proximity only. All the other options are invalid.
The answer for second one is “alignment”.
Alignment actually relates to the term margin and axis. Alignment can be left, right, middle, top, bottom. Text, image, or any element can be aligned based on the need with the value of alignment discussed in the just before sentence. Alignments are widely used in computer terms in office tools and in web pages.
Go to file>export as and it will allow you to change it to other files.
The correct answer is A. currency.
Answer:
- import java.util.ArrayList;
- public class Main {
-
- public static void main(String[] args) {
- ArrayList<String> strList =new ArrayList<String>();
- strList.add("to");
- strList.add("be");
- strList.add("or");
- strList.add("not");
- strList.add("to");
- strList.add("be");
- strList.add("hamlet");
-
- swapPairs(strList);
- System.out.println(strList);
- }
-
- public static void swapPairs(ArrayList<String> list){
- for(int i=0; i < list.size()-1; i+=2){
- String temp = list.get(i);
- list.set(i, list.get(i+1));
- list.set(i+1, temp);
- }
- }
- }
Explanation:
Firstly, let's create a method swapPairs that take one ArrayList (Line 18). In the method, use a for-loop to traverse through each item in the ArrayList and swap the items between the current items at index-i and at index-i+1 (Line 19-22). The index-i is incremented by two in next loop and therefore the next swapping will proceed with third and fourth items and so forth.
In the main program, create a sample ArrayList (Line 5-12) and then test the method (Line 14) and print the output (Line 15). We shall get [be, to, not, or, be, to, hamlet].
