USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What should you do if there is a worksheet that needs to remain in the workbook but does not need to be viewed by everyone who has access to the workbook.
|
|
Delete the worksheet
|
|
|
Move the worksheet to the end of the workbook
|
|
|
Hide the worksheet
|
|
|
Click the undisplay command
|
Explanation:
Detailed explanation-1: -First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.
Detailed explanation-2: -Click Review > Protect Workbook. Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. Select the Windows option if you want to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. Enter a password in the Password box.
There is 1 question to complete.