FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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.
A
Hide
B
Copy
C
Either A or B
D
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.