USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
HIDE
|
|
|
FREEZE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-2: -If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.
Detailed explanation-3: -Go to the View tab and click the Freeze Panes button. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. I will select Freeze Top Row to lock the first row in place. That’s it!
Detailed explanation-4: -The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen.
Detailed explanation-5: -To freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column. This will make the leftmost column visible at all times while you scroll to the right.