MyITLab Chapter 11
A cell that contains a comment is marked with a blue triangle
False
An internet connection is not required to send an Excel workbook via e-mail
False
Excel cannot save workbooks for previous versions of Excel
False
Shared workbooks only function properly on network drives that are read-only
False
Which of the following is not an Excel Options category?
Format
Which of the following changes will Excel not track?
Formatting
Metadata is attached to each Excel workbook
True
Which feature is best suited to record edits made to a document over time?
Track Changes
Documents can have multiple authors defined in the document properties
True
Which of the following is not a tab located in the Properties dialog box?
Advanced
Match the following terms with the corresponding descriptions:
Collaboration- The process by which two or more individuals work together to achieve an outcome or goal by using software technology Shared Workbook- A file that is designated as shareable and is stored on a network that is accessible to multiple people who can edit the workbook at the same time Resolve Conflicts dialog box- Appears when two users make changes to the same cell simultaneously Nonshareable workbook- Appears as read-only when opened Compare and Merge- Command to combine the shared workbooks into one workbook so that you can compare the changes to decide which ones to keep
What tool is best suited to combine multiple versions of a shared workbook into one document?
Compare and Merge
Which of the following tools is best suited to check the workbook contents to see what data and features are not compatible with previous versions?
Compatibility Checker
To compare and merge workbooks, the workbooks cannot be shared
False
Which of the following is not a tool to check a workbook for errors?
File inspector
Which of the following items cannot be added to the Ribbon?
Formula
Where is the Share Workbook command located within Excel?
Review Tab
Where is the Track Changes feature located?
Review tab
Which of the following is not an option when highlighting changes?
Reviewed
A forgotten password within Excel cannot be retrieved
True
A workbook marked as final is read-only
True
Customization of the Quick Access Toolbar can be exported
True
Hidden comments do not print
True
Which of the following Excel Options categories contains information about protecting your privacy?
Trust Center
What is the cause of the error message "File in Use"?
Two users open the same unshared workbook
Which of the following is a limitation of sharing workbooks?
Workbooks that contain tables may not be shared
Which Excel Options category contains Editing options?
Advanced
Where do you access the Excel Options dialog box?
Backstage
Which of the following is not a customizable feature within excel?
Backstage
Which of the following is not a default command of the Quick Access Toolbar?
Close
Which of the following is not true regarding comments in an excel workbook?
Comments are indicated by a black triangle
When tracking changes, which of the following options is no longer available?
Conditional formatting
The Ribbon cannot be customized
False
Workbook comments can only be removed one at a time
False
Which of the following is true about compare and merge?
Merged workbooks cannot be exported
Which dialog box allows the user to print all comments?
Page Setup
Which of the following areas is not checked by the Accessibility Checker?
Print area
Which of the following areas is not checked by the accessibility checker?
Print area
Where is the New Comment command located?
Review Tab
The user cannot change automatically updated properties
True
The default comment print setting is:
none.
Which of the following is the default file format for excel 97-2003?
.XLS
What is the default file format in Excel 2013?
.XLSX
Match the following terms with the corresponding descriptions:
General- Displays the file name, file type, location, size, creation date, modification date, and last accessed date Summary- Displays properties the user can enter and change, such as title, subject, author, manager, company, category, keywords, and comments Statistics- Includes creation, modified, accessed and printed dates Contents- Displays the worksheet names contained in the workbook Custom- enables the user to create and maintain custom properties for the current workbook such as Department, Project, and Purpose
