USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
prevent/protect worksheet from
|
|
|
Hide
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You might want to display or print a worksheet in such a way that some of the data is hidden, but not deleted from the workbook. You can hide rows or columns to conceal confidential or confusing data.
Detailed explanation-2: -One easy way to prevent accidental changes to your spreadsheet is to lock its cells. To do so, go to the Review ribbon and choose Protect Sheet. In the window that opens, make sure Protect Worksheet and Contents of Locked cells is checked. Then click OK.
Detailed explanation-3: -Select one or more columns, and then press Ctrl to select additional columns that aren’t adjacent. Right-click the selected columns, and then select Hide.
Detailed explanation-4: -You can hide any worksheet to remove it from view. The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide hidden worksheets as needed. Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.