USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ a row or column causes your cell data to change orientation. Row data will become column data, and column data will become row data.
|
|
transposing
|
|
|
b
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.
Detailed explanation-2: -Select the cells then place the cell pointer on new cell and choose Edit ยป Paste Special, mark Transpose check box and click OK.
Detailed explanation-3: -The easiest way to convert rows to columns in Excel is via the Paste Transpose option. Here is how it looks: Select and copy the needed range. Right-click on a cell where you want to convert rows to columns.
There is 1 question to complete.