Excel
Which of the following is not a method to protect a workbook against changes? Enable Sharing Add a Signature Line Mark as Final Export as PDF
Enable Sharing
Merge Cells is available while change tracking is turned on. True False
False
The Excel Options dialog box is on the Developer tab. True False
False
Which of the following is not an option for changes to review in the Select Changes to Accept or Reject dialog box? Where When How Who
How
What cloud based storage service is integrated in Excel 2016? Dropbox SyncUp iCloud OneDrive
OneDrive
A file with an .ods extension is ________. Portable Document Format Open Document spreadsheet Macro-Enabled Binary
Open Document spreadsheet
If you didn't use the New Comment command on the Review tab, how would you insert a comment? Click comment in the status bar. Right-click on the cell and then select Insert Comment. Use the New Comment command on the Home tab. Right-click and select commenting options.
Right-click on the cell and then select Insert Comment.
Where in the Excel Options dialog box would you manage AutoRecover in Excel? Advanced Formulas Save General
Save
Where in the Excel Options dialog box would you manage AutoRecover in Excel? General Formulas Save Advanced
Save
What is the first step for each user when running the Compare and Merge Workbooks tool? Making all files read-only Removing all tables Saving their file with a unique filename Moving all files to a different folder
Saving their file with a unique file name
Change tracking is available only in shared workbooks. True False
True
Current Excel files are based on XML. True False
True
The Document Inspector can remove personal data from a workbook. True False
True
The user cannot change automatically updated properties. True False
True
Users can see the changes made by other users in a shared workbook. True False
True
You can export Quick Access Toolbar settings to other users. True False
True
A cell that contains a comment is marked with a green triangle. True False
False
A shared workbook cannot be merged using the Compare and Merge Workbooks tool. True False
False
An Excel template has an .xlxb extension. True False
False
Excel uses no metadata in its files. True False
False
If you send an email link to a workbook, the recipients of the file have access to change the original file on your computer. True False
False
Which of the following is not checked by the Accessibility Checker? Print Area Alt Text Table Headers Merged Cells
Print Area
What is the default file format for Excel 2016? .xlsm .xltx .xlsx .xls
xlsx