FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following options makes a workbook read-only and lets users know that the workbook should not be changed?

A	Protect Sheet
B	Inspect Document
C	Mark as Final
D	Manage Workbook

Explanation:

Detailed explanation-1: -Open the workbook that you want to protect. On the Review tab, under Protection, click Passwords. In the File Passwords dialog box, select the Read-only recommended check box, and click OK. Close the workbook.

Detailed explanation-2: -Mark a file as final In your Word, PowerPoint, or Excel file, click File >Info > Protect (Document, Presentation, or Workbook) > Mark as Final.

Detailed explanation-3: -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.

Detailed explanation-4: -Are the file properties set to read-only? You can check the file properties by right-clicking on the file and choosing Properties. If the Read-only attribute is checked, you can uncheck it and click OK.

There is 1 question to complete.