Chp 11

11 September 2022
4.7 (114 reviews)
51 test answers

Unlock all answers in this set

Unlock answers (47)
question
Which of the following Excel Options categories contains information about protecting your privacy?
answer
Trust Center
question
Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?
answer
Two users attempt to change the same cell at the same time
question
Which of the following tools is best suited to review your files for potential issues that could hinder the ability of users who access your public files?
answer
Accessibility Checker
question
Which of the following is not a customizable feature within Excel?
answer
Backstage
question
Which of the following tools is best suited for checking a workbook for personal data?
answer
Document Inspector
question
Which of the following is not a tab located in the Properties dialog box?
answer
not- statistics
question
Excel cannot export .CSV files.
answer
false
question
Hidden comments do not print.
answer
true
question
A forgotten password within Excel cannot be retrieved.
answer
true
question
Workbook comments can only be removed one at a time.
answer
false
question
An Internet connection is not required to send an Excel workbook via e-mail.
answer
false
question
A workbook marked as final cannot be password protected.
answer
true
question
What is the default file format in Excel 2013?
answer
.XLSX
question
AutoCorrect options are located in which Excel Options category?
answer
Proofing
question
Which of the following is not true about a workbook that is Marked as Final?
answer
The file is marked as shared
question
Which of the following areas is not checked by the Accessibility Checker?
answer
Print area
question
What tool is best suited to combine multiple versions of a shared workbook into one document?
answer
compare and merge
question
When active, the Document Panel displays above the current workbook.
answer
true
question
When a signature line is added, the document becomes read-only.
answer
true
question
Excel cannot save workbooks for previous versions of Excel.
answer
false
question
Which feature is best suited to record edits made to a document over time?
answer
Track changes
question
Author properties can be updated from which category in the Backstage view?
answer
Info
question
Which of the following changes will Excel not track?
answer
formatting
question
Where is the Accessibility Checker located?
answer
backstage
question
Which of the following items cannot be added to the Ribbon?
answer
formula
question
.ods .xlsm .txt .prn .xltx
answer
OpenDocument Spreadsheet Excel Macro-Enabled Workbook Text (Tab delimited) Formatted Text (Space delimited) Excel Template
question
The Document Inspector will remove personal data from a workbook.
answer
True
question
Shared workbooks only function properly on network drives that are read-only
answer
false
question
Change tracking can only be activated in shared workbooks.
answer
true
question
Which of following is the default file format for Excel 97-2003?
answer
.XLS
question
Which of the following is not a default command of the Quick Access Toolbar?
answer
close
question
Which of the following is not a method for protecting the worksheet against changes?
answer
track changes
question
Which of the following is an integrated option for sending files to others?
answer
email
question
Which of the following is a feature of change tracking?
answer
highlight changes
question
Where is the New Comment command located?
answer
not- insert tab
question
Which of the following is not an Excel Options category?
answer
not- formulas
question
When tracking changes, which of the following options is no longer available?
answer
conditional formatting
question
Which of the following is not true regarding comments in an Excel workbook?
answer
Comments are indicated by a black triangle
question
Which of the following online storage tools is integrated into Excel 2013?
answer
SkyDrive
question
To compare and merge workbooks, the workbooks cannot be shared.
answer
false
question
A cell that contains a comment is marked with a blue triangle.
answer
false
question
Where do you access the Excel Options dialog box?
answer
Backstage
question
Which of the following is not a tool to check a workbook for errors?
answer
file inspector
question
Where is the Track Changes feature located?
answer
review tab
question
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?
answer
compatibility checker
question
Shared workbooks cannot be marked as final.
answer
true
question
When creating a history worksheet using change tracking, the worksheet is automatically saved
answer
false
question
Which Excel Options category contains Editing options?
answer
advanced
question
Which of the following is an option to edit a comment?
answer
Click Edit Comment in the Comments Group of the Review tab
question
Which dialog box allows the user to print all comments?
answer
page setup
question
The user cannot change automatically updated properties.
answer
true