Question 1

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

Accepted Answer

The Answer of Excel Workbook and Portable Document Format and is...

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

The answer of A(n)________ is a workbook that can be...

Question 4

What are the benefits of customizing Excel?

Accepted Answer

Customizing Excel gives the user the abi

Question 5

When a file is created,customizations such as the author's name are saved as ________.

Accepted Answer

The answer of When a file is created,customizations such as...

Question 6

Match between columns
                        Premises: Save
Trust Center
Formulas
Proofing
Advanced

Accepted Answer

The Answer of Controls corrections and formatting and Controls advanced is...

Question 7

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 8

The ________ should be used to make sure your files are backwards compatible.

Accepted Answer

Accessibil

Question 9

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 10

Where do you access the Excel Options dialog box?

Accepted Answer

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

Question 11

Match between columns
                        Premises: .xlsm
.ods
.xltx
.prn
.txt

Accepted Answer

The Answer of Excel Macro-Enabled Workbook and Excel Template and is...

Question 12

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 13

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 14

Where is the Track Changes feature located?

Accepted Answer

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

Question 15

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 16

When workbooks are shared users can see changes made by others.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Resolve Conflicts dialog box
Nonshareable workbook
Shared workbook
Collaboration
Compare and Merge

Accepted Answer

The Answer of Appears when two users make changes to is...

Question 18

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 19

The ________ checks the workbook for personal data.

Accepted Answer

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

Question 20

Excel cannot export .CSV files.

Accepted Answer

A) True 
 B)False

Exam 28: Excel : Collaboration and Workbook Distribution

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

What are the benefits of customizing Excel?

When a file is created,customizations such as the author's name are saved as ________.

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 ________ should be used to make sure your files are backwards compatible.

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

Where do you access the Excel Options dialog box?

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

Where is the New Comment command located?

Where is the Track Changes feature located?

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

When workbooks are shared users can see changes made by others.

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

The ________ checks the workbook for personal data.

Excel cannot export .CSV files.

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