USING MICROSOFT EXCEL
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: -In Excel, click the View tab, then click Unhide in the Window group. See screenshot: 2. If there is only one hidden workbook, after clicking the Unhide command, the hidden workbook will show up.