Question 1

Match between columns
                        Premises: Proofing
Save
Formulas
Trust Center
Advanced

Accepted Answer

The Answer of Controls formula calculations,performance,and error handling and Controls is...

Question 2

The ________ checks the workbook for personal data.

Accepted Answer

The answer of The ________ checks the workbook for personal...

Question 3

Which of the following is not a tab located in the Properties dialog box?

Accepted Answer

A) General 
B) Statistics 
C) Advanced 
D) Custom 
A) General 
B) Statistics 
C) Advanced 
D) Custom

Question 4

Metadata is attached to each Excel workbook.

Accepted Answer

A) True 
 B)False

Question 5

Hidden comments do not print.

Accepted Answer

A) True 
 B)False

Question 6

The ________ dialog box appears when two users edit the same cell at the same time.

Accepted Answer

The answer of The ________ dialog box appears when two...

Question 7

What are the benefits of customizing Excel?

Accepted Answer

Customizing Excel gives the user the abi

Question 8

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 9

Excel files can be exported in different formats from the ________ area.

Accepted Answer

The answer of Excel files can be exported in different...

Question 10

Match between columns
                        Premises: Custom
Summary
Statistics
General
Contents

Accepted Answer

The Answer of Displays the file name,file type,location,size,creation date,modification date,and is...

Question 11

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

Accepted Answer

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

Question 12

Which of the following is not an option when highlighting changes?

Accepted Answer

A) Since I last saved 
B) Not yet reviewed 
C) Reviewed 
D) Since date 
A) Since I last saved 
B) Not yet reviewed 
C) Reviewed 
D) Since date

Question 13

Change tracking can only be activated in shared workbooks.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ can be inserted to provide notes or feedback to other users of a workbook.

Accepted Answer

The answer of A(n)________ can be inserted to provide notes...

Question 15

Use the ________ command to combine the shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

Accepted Answer

The answer of Use the ________ command to combine the...

Question 16

Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?

Accepted Answer

A) Two users attempt to change the same cell at the same time 
B) Two users open the same file at the same time 
C) Two users attempt to save the same file at the same time 
D) Network error 
A) Two users attempt to change the same cell at the same time 
B) Two users open the same file at the same time 
C) Two users attempt to save the same file at the same time 
D) Network error

Question 17

Which of the following items cannot be added to the Ribbon?

Accepted Answer

A) Tab 
B) Group 
C) Software add-in 
D) Formula 
A) Tab 
B) Group 
C) Software add-in 
D) Formula

Question 18

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 19

When a signature line is added,the document becomes read-only.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is an option to edit a comment?

Accepted Answer

A) Click Edit Comment in the Comments Group of the Review tab 
B) Double click the comment 
C) Click Edit Comment in the Comments Group of the Insert tab 
D) Comments cannot be edited 
A) Click Edit Comment in the Comments Group of the Review tab 
B) Double click the comment 
C) Click Edit Comment in the Comments Group of the Insert tab 
D) Comments cannot be edited

Exam 42: Collaboration and Workbook Distribution

The ________ checks the workbook for personal data.

Which of the following is not a tab located in the Properties dialog box?

Metadata is attached to each Excel workbook.

Hidden comments do not print.

The ________ dialog box appears when two users edit the same cell at the same time.

What are the benefits of customizing Excel?

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

Excel files can be exported in different formats from the ________ area.

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

Which of the following is not an option when highlighting changes?

Change tracking can only be activated in shared workbooks.

A(n)________ can be inserted to provide notes or feedback to other users of a workbook.

Use the ________ command to combine the shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?

Which of the following items cannot be added to the Ribbon?

Where is the Accessibility Checker located?

When a signature line is added,the document becomes read-only.

Which of the following is an option to edit a comment?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

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

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

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

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

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

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

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters