DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Excel allows you to insert new columns or rows, delete certain rows or columns, move them to a different location in the worksheet, or even ____ rows or columns.
|
|
Hide
|
|
|
Copy
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
Detailed explanation-2: -Copy the cell range. Select the empty cells where you want to paste the transposed data. On the Home tab, click the Paste icon, and select Paste Transpose.
There is 1 question to complete.