DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
hide sheet
|
|
|
hide rows and columns
|
|
|
hide workbook
|
|
|
hide
|
Detailed explanation-1: -Open the sheet or workbook that you want to protect. On the Review tab, click Protect Sheet or Protect Workbook. In the Password box, type a password, and in the Verify box, type the password again. Choose any other protection options you want and click OK.
Detailed explanation-2: -Hiding worksheets or workbooks in Excel is a useful way of preventing people from seeing data and calculations you want to restrict access to or pull focus from. To hide a workbook, in the Ribbon, select View > Hide. The workbook you are currently working in disappears.
Detailed explanation-3: -On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.