Question 1

Match between columns
                        Premises: .xlsb
.xltx
.csv
.xlsx
.pdf

Accepted Answer

The Answer of Excel Workbook and Excel Binary Workbook and is...

Question 2

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

Accepted Answer

shared workbook

Question 3

In order to track changes,a workbook must be ________.

Accepted Answer

shared

Question 4

What are some ways to protect a workbook?

Accepted Answer

A workbooks can be protected by marking

Question 5

Workbook comments can only be removed one at a time.

Accepted Answer

A) True 
 B)False

Question 6

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 7

A workbook marked as final is read-only.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ triangle appears in a cell to indicate a comment.

Accepted Answer

The answer of A(n)________ triangle appears in a cell to...

Question 9

Excel customization options can be located in the ________ area.

Accepted Answer

The answer of Excel customization options can be located in...

Question 10

Author properties can be updated from which category in the Backstage view?

Accepted Answer

A) Account 
B) Info 
C) Share 
D) Options 
A) Account 
B) Info 
C) Share 
D) Options

Question 11

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 12

Match between columns
                        Premises: Add-Ins
General
Customize Ribbon
Language
Quick Access Toolbar

Accepted Answer

The Answer of Controls general Excel options and Enables users is...

Question 13

Which of the following areas is not checked by the Accessibility Checker?

Accepted Answer

A) Table headers 
B) Alt text 
C) Merged cells 
D) Print area 
A) Table headers 
B) Alt text 
C) Merged cells 
D) Print area

Question 14

Which of the following is not an Excel Options category?

Accepted Answer

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

Question 15

Which of the following is not true regarding comments in an Excel workbook?

Accepted Answer

A) Comments are indicated by a black triangle 
B) Comments can be edited 
C) Multiple users can insert comments 
D) There is no limit to the number of comments in a file 
A) Comments are indicated by a black triangle 
B) Comments can be edited 
C) Multiple users can insert comments 
D) There is no limit to the number of comments in a file

Question 16

The default comment print setting is:

Accepted Answer

A) as displayed on sheet. 
B) only active. 
C) at end of sheet. 
D) none. 
A) as displayed on sheet. 
B) only active. 
C) at end of sheet. 
D) none.

Question 17

Where is the New Comment command located?

Accepted Answer

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

Question 18

Which Excel Options category contains Editing options?

Accepted Answer

A) General 
B) Advanced 
C) Formulas 
D) Trust Center 
A) General 
B) Advanced 
C) Formulas 
D) Trust Center

Question 19

An Internet connection is not required to send an Excel workbook via e-mail.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 42: Collaboration and Workbook Distribution

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

In order to track changes,a workbook must be ________.

What are some ways to protect a workbook?

Workbook comments can only be removed one at a time.

What is the default file format in Excel 2013?

A workbook marked as final is read-only.

A(n)________ triangle appears in a cell to indicate a comment.

Excel customization options can be located in the ________ area.

Author properties can be updated from which category in the Backstage view?

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

Which of the following areas is not checked by the Accessibility Checker?

Which of the following is not an Excel Options category?

Which of the following is not true regarding comments in an Excel workbook?

The default comment print setting is:

Where is the New Comment command located?

Which Excel Options category contains Editing options?

An Internet connection is not required to send an Excel workbook via e-mail.

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

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