DATABASE FUNDAMENTALS
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: -Under the Protection Tab, select Lock Cells and click OK. Now enforce this rule by protecting the Worksheet with a password. Now, users can enter data, but cannot edit the formulas.