Question 1

Match the following terms with the corresponding descriptions:

-Highlight Changes

Accepted Answer

A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook 
A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook

Question 2

Match the following terms with the corresponding descriptions:

-History worksheet

Accepted Answer

A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook 
A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook

Question 3

Once a workbook is ________ it is read-only.

Accepted Answer

The answer of Once a workbook is ________ it is...

Question 4

AutoCorrect options are located in which Excel Options category?

Accepted Answer

A) Formulas 
B) Proofing 
C) General 
D) Advanced 
A) Formulas 
B) Proofing 
C) General 
D) Advanced

Question 5

Which of the following is not true about compare and merge?

Accepted Answer

A) Each user must save a copy with a unique name 
B) Each version of the file must be saved 
C) All workbooks must originate from the same file 
D) Merged workbooks cannot be exported 
A) Each user must save a copy with a unique name 
B) Each version of the file must be saved 
C) All workbooks must originate from the same file 
D) Merged workbooks cannot be exported

Question 6

Which of the following tools is best suited for checking a workbook for personal data?

Accepted Answer

A) File Inspector 
B) Document Inspector 
C) Accessibility Checker 
D) Compatibility Checker 
A) File Inspector 
B) Document Inspector 
C) Accessibility Checker 
D) Compatibility Checker

Question 7

A workbook marked as final cannot be password protected.

Accepted Answer

A) True 
 B)False

Question 8

Which feature is best suited to record edits made to a document over time?

Accepted Answer

A) Compare and merge 
B) Track changes 
C) Comments 
D) Sharing 
A) Compare and merge 
B) Track changes 
C) Comments 
D) Sharing

Question 9

Match the following terms with the corresponding descriptions:

-Accept/Reject Changes

Accepted Answer

A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook 
A) Not supported by change tracking 
B) Location of Track Changes tools 
C) When changes are made with Change Tracking on,each cell changed contains a colored triangle in the top-left corner 
D) View changes in sequence through a dialog box that enables you to accept or reject changes 
E) A worksheet that lists the changes made to the workbook

Question 10

Users will experience difficulties using shared files on a network drive if the network is ________.

Accepted Answer

The answer of Users will experience difficulties using shared files...

Question 11

What tool is best suited to combine multiple versions of a shared workbook into one document?

Accepted Answer

A) Merge 
B) Concatenate 
C) Compare and Merge 
D) Combine 
A) Merge 
B) Concatenate 
C) Compare and Merge 
D) Combine

Question 12

Customization of the Quick Access Toolbar can be exported.

Accepted Answer

A) True 
 B)False

Question 13

Hidden comments do not print.

Accepted Answer

A) True 
 B)False

Question 14

Where is the Accessibility Checker located?

Accepted Answer

A) Data tab 
B) Review tab 
C) Backstage 
D) Insert tab 
A) Data tab 
B) Review tab 
C) Backstage 
D) Insert tab

Question 15

________ is the maximum number of users that can access a shared file at once.

Accepted Answer

The answer of ________ is the maximum number of users...

Question 16

Which of the following is not a default command of the Quick Access Toolbar?

Accepted Answer

A) Close 
B) Save 
C) Undo 
D) Redo 
A) Close 
B) Save 
C) Undo 
D) Redo

Question 17

The Ribbon cannot be customized.

Accepted Answer

A) True 
 B)False

Question 18

When displayed,the ________ will show file properties directly above the current workbook.

Accepted Answer

The answer of When displayed,the ________ will show file properties...

Question 19

Excel will use ________ if sending a workbook via e-mail.

Accepted Answer

The answer of Excel will use ________ if sending a...

Question 20

Documents can have multiple authors defined in the document properties.

Accepted Answer

A) True 
 B)False

Exam 28: Excel : Collaboration and Workbook Distribution

Match the following terms with the corresponding descriptions: -Highlight Changes

Match the following terms with the corresponding descriptions: -History worksheet

Once a workbook is ________ it is read-only.

AutoCorrect options are located in which Excel Options category?

Which of the following is not true about compare and merge?

Which of the following tools is best suited for checking a workbook for personal data?

A workbook marked as final cannot be password protected.

Which feature is best suited to record edits made to a document over time?

Match the following terms with the corresponding descriptions: -Accept/Reject Changes

Users will experience difficulties using shared files on a network drive if the network is ________.

What tool is best suited to combine multiple versions of a shared workbook into one document?

Customization of the Quick Access Toolbar can be exported.

Hidden comments do not print.

Where is the Accessibility Checker located?

________ is the maximum number of users that can access a shared file at once.

Which of the following is not a default command of the Quick Access Toolbar?

The Ribbon cannot be customized.

When displayed,the ________ will show file properties directly above the current workbook.

Excel will use ________ if sending a workbook via e-mail.

Documents can have multiple authors defined in the document properties.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters