Question 1

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 2

When tracking changes,which of the following options is no longer available?

Accepted Answer

A) Conditional formatting 
B) Printing 
C) Sharing 
D) Saving to SkyDrive 
A) Conditional formatting 
B) Printing 
C) Sharing 
D) Saving to SkyDrive

Question 3

Shared workbooks cannot be marked as final.

Accepted Answer

A) True 
 B)False

Question 4

Excel cannot save workbooks for previous versions of Excel.

Accepted Answer

A) True 
 B)False

Question 5

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 6

When printing,by default all comments in a worksheet are ________.

Accepted Answer

The answer of When printing,by default all comments in a...

Question 7

The Ribbon cannot be customized.

Accepted Answer

A) True 
 B)False

Question 8

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?

Accepted Answer

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

Question 9

The ________ can be customized in Excel.

Accepted Answer

The answer of The ________ can be customized in Excel....

Question 10

Which of the following is an integrated option for sending files to others?

Accepted Answer

A) E-mail 
B) Dropbox 
C) iCloud 
D) Google Drive 
A) E-mail 
B) Dropbox 
C) iCloud 
D) Google Drive

Question 11

Which of the following Excel Options categories contains information about protecting your privacy?

Accepted Answer

A) Save 
B) Trust Center 
C) Advanced 
D) Language 
A) Save 
B) Trust Center 
C) Advanced 
D) Language

Question 12

A cell that contains a comment is marked with a blue triangle.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a customizable feature within Excel?

Accepted Answer

A) Username 
B) Mini Toolbar 
C) default font size 
D) Backstage 
A) Username 
B) Mini Toolbar 
C) default font size 
D) Backstage

Question 14

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?

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 15

A workbook marked as final cannot be password protected.

Accepted Answer

A) True 
 B)False

Question 16

Which dialog box allows the user to print all comments?

Accepted Answer

A) Page Setup 
B) Print 
C) Page Layout 
D) Backstage 
A) Page Setup 
B) Print 
C) Page Layout 
D) Backstage

Question 17

Which of the following is not a method for protecting the worksheet against changes?

Accepted Answer

A) Track Changes 
B) Add a signature line 
C) Export to PDF 
D) Mark as Final 
A) Track Changes 
B) Add a signature line 
C) Export to PDF 
D) Mark as Final

Question 18

Which of the following is a limitation of sharing workbooks?

Accepted Answer

A) 125 users can access at once 
B) Workbooks that contain tables may not be shared 
C) Track changes is not supported 
D) The workbook cannot be printed 
A) 125 users can access at once 
B) Workbooks that contain tables may not be shared 
C) Track changes is not supported 
D) The workbook cannot be printed

Question 19

Match between columns
                        Premises: Page Setup dialog box
Comment indicator
Track Changes
Compare and Merge
Comment

Accepted Answer

The Answer of A note or annotation to ask a is...

Question 20

When a workbook is opened and the message "File in Use" appears,the workbook is ________.

Accepted Answer

The answer of When a workbook is opened and the...

Exam 42: Collaboration and Workbook Distribution

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

When tracking changes,which of the following options is no longer available?

Shared workbooks cannot be marked as final.

Excel cannot save workbooks for previous versions of Excel.

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

When printing,by default all comments in a worksheet are ________.

The Ribbon cannot be customized.

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?

The ________ can be customized in Excel.

Which of the following is an integrated option for sending files to others?

Which of the following Excel Options categories contains information about protecting your privacy?

A cell that contains a comment is marked with a blue triangle.

Which of the following is not a customizable feature within Excel?

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?

A workbook marked as final cannot be password protected.

Which dialog box allows the user to print all comments?

Which of the following is not a method for protecting the worksheet against changes?

Which of the following is a limitation of sharing workbooks?

When a workbook is opened and the message "File in Use" appears,the workbook is ________.

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