USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
|
|
Freeze Panes
|
|
|
Split
|
|
|
Hide
|
|
|
Unhide
|
Explanation:
Detailed explanation-1: -Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.
Detailed explanation-2: -Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line.
There is 1 question to complete.