USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Transposed data must be placed in blank cells.
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -on the Home tab, or press CONTROL+C. Note: Make sure you copy the data to do this. Using the Cut command or CONTROL+X won’t work. Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.
Detailed explanation-2: -Transpose creates a new data file in which the rows and columns in the original data file are transposed so that cases (rows) become variables and variables (columns) become cases. Transpose automatically creates new variable names and displays a list of the new variable names.
There is 1 question to complete.