Sharing and Protecting Worksheets
What steps can be used to run the Accessibility Checker?
File Info Check For Issues
In which dialog box can a user locate the Element Protection tab?
Format Cells
What steps can be used to unlock part of a worksheet?
Range for users to modify Format Cells Locked
Which tab should you click if you want to access the Show All Comments option in a worksheet?
Review
What steps can be used to password-protect a worksheet?
Review Changes Protect Sheet
What are the steps used to track changes in a shared workbook?
Review Highlight Changes
When working with a shared worksheet, how do you know it's shared?
The word "Shared" appears after the workbook title in the title bar.
What happens when a workbook's structure is protected?
Users must enter a password to view hidden content.
Which symbol indicates that a cell contains a comment?
a red triangle in the upper right corner
To ensure that unauthorized users do not edit your Excel files, what should you use?
protect sheet with password
What is the purpose of the Share With People option?
to allow others to edit your file via OneDrive
What is the most likely reason for protecting a worksheet?
to prevent unauthorized users from modifying the worksheet
What is the purpose of using Document Inspector?
to remove any metadata that should be private
Where is the Share button located for quick access?
top right corner of the ribbon
How can users open a shared worksheet if they do not have Excel installed on a computer?
use Excel Online through the 365 portal
What are two options available for highlighting changes in the Highlight Changes dialog box?
within a specific time period or by a specific user
