What is the best practice to switch the columns and rows in a range?

A. Cut the range, then use the Paste Special option called Values
B. Cut the range, then use the Paste Special option called Transpose
C. Cut the range, then use the Paste Special option called Switch
D. Cut the range, paste it into a blank area, then cut and paste each cell where you want it


Answer: B

Computer Science & Information Technology

You might also like to view...

What is the final value of x after the following fragment of code executes?

int x=0; do { x++; }while(x > 0); a. 8 b. 9 c. 10 d. 11 e. infinite loop.

Computer Science & Information Technology

Which of the following modes causes new characters to be typed over existing ones?

A. Insert B. Overtype C. Replace D. Type Over

Computer Science & Information Technology

Analyze the following code:

``` public class Test { public static void main(String[] args) { int[] oldList = {1, 2, 3, 4, 5}; reverse(oldList); for (int i = 0; i < oldList.length; i++) System.out.print(oldList[i] + " "); } public static void reverse(int[] list) { int[] newList = new int[list.length]; for (int i = 0; i < list.length; i++) newList[i] = list[list.length - 1 - i]; list = newList; } }``` a. The program displays 1 2 3 4 5. b. The program displays 1 2 3 4 5 and then raises an ArrayIndexOutOfBoundsException. c. The program displays 5 4 3 2 1. d. The program displays 5 4 3 2 1 and then raises an ArrayIndexOutOfBoundsException.

Computer Science & Information Technology

____________ refers to a framework that facilitates software building by connecting software components from diverse sources.

(a) JavaBeans (b) Threads (c) SQL (d) all of the above

Computer Science & Information Technology