Question 1

A forgotten password within Excel cannot be retrieved.

Accepted Answer

A) True 
 B)False

Question 2

The Quick Access Toolbar can be customized.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

What is the cause of the error message "File in Use"?

Accepted Answer

A) A user opens a shared workbook 
B) A user opens a workbook that is not shared 
C) Two users open the same unshared workbook 
D) Two users open the same shared workbook 
A) A user opens a shared workbook 
B) A user opens a workbook that is not shared 
C) Two users open the same unshared workbook 
D) Two users open the same shared workbook

Question 6

When active,the Document Panel displays above the current workbook.

Accepted Answer

A) True 
 B)False

Question 7

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 8

What is the default file format in Excel 2013?

Accepted Answer

A) .TXT 
B) .XLS 
C) .XLSX 
D) .XLTX 
A) .TXT 
B) .XLS 
C) .XLSX 
D) .XLTX

Question 9

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 10

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...

Question 11

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 12

Match between columns
                        Premises: Mark as Final
Signature line
Accessibility Checker
Document Inspector
Compatibility Checker

Accepted Answer

The Answer of Reviews your files for potential issues that is...

Question 13

When change tracking is enabled ________ is unavailable.

Accepted Answer

conditiona

Question 14

Workbook comments can only be removed one at a time.

Accepted Answer

A) True 
 B)False

Question 15

Change tracking can only be activated in shared workbooks.

Accepted Answer

A) True 
 B)False

Question 16

The Share Workbook command is located on the ________.

Accepted Answer

The answer of The Share Workbook command is located on...

Question 17

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 18

What are the benefits of sharing a workbook?

Accepted Answer

Sharing a workbook allows multiple users

Question 19

Match the following terms with the corresponding descriptions:

-Review tab

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 20

Metadata is attached to each Excel workbook.

Accepted Answer

A) True 
 B)False

Exam 28: Excel : Collaboration and Workbook Distribution

A forgotten password within Excel cannot be retrieved.

The Quick Access Toolbar can be customized.

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

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

What is the cause of the error message "File in Use"?

When active,the Document Panel displays above the current workbook.

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

What is the default file format in Excel 2013?

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

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

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

When change tracking is enabled ________ is unavailable.

Workbook comments can only be removed one at a time.

Change tracking can only be activated in shared workbooks.

The Share Workbook command is located on the ________.

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

What are the benefits of sharing a workbook?

Match the following terms with the corresponding descriptions: -Review tab

Metadata is attached to each Excel workbook.

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