USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Require a password to open the current workbook using the password ReviewHR9. What tab do you go to first?
|
|
file
|
|
|
developer
|
|
|
formulas
|
|
|
view
|
Explanation:
Detailed explanation-1: -Require a password to open the current workbook. Set the password to be ReviewHR9. In the File tab, select the Protect Workbookbutton and click Encrypt with Password. In the dialog window, enter the password ReviewHR9 and click OK.
Detailed explanation-2: -The Protect Workbook option in the Info menu also indicates that the workbook’s structure is protected. To view this option, click File > Info > Protect Workbook.
Detailed explanation-3: -To do this, go to the File tab and click on “Protect Workbook". Then click on “Password” and enter a password that you will remember. Another way to protect individual worksheets is to use cell protection. To do this, go to the Review tab and click on “Protect Sheet".
There is 1 question to complete.