Question 1

If a password is lost is cannot be ________.

Accepted Answer

recovered

Question 2

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 B

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

When a history worksheet is created,it is ________ when the file is saved.

Accepted Answer

The answer of When a history worksheet is created,it is...

Question 5

Which of the following items is not stored as metadata in a workbook?

Accepted Answer

A) Company 
B) Imported images 
C) Creation date 
D) Author name 
A) Company 
B) Imported images 
C) Creation date 
D) Author name

Question 6

What are some ways to protect a workbook?

Accepted Answer

A workbooks can be protected by marking

Question 7

Which of following is the default file format for Excel 97-2003?

Accepted Answer

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

Question 8

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

Question 9

Match between columns
                        Premises: Summary
Statistics
Contents
General
Custom

Accepted Answer

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

Question 10

Excel can export PDF files.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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 14

Shared workbooks only function properly on network drives that are read-only.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Review tab
Accept/Reject Changes
History worksheet
Data tables
Highlight Changes

Accepted Answer

The Answer of A worksheet that lists the changes made is...

Question 16

Excel cannot save workbooks for previous versions of Excel.

Accepted Answer

A) True 
 B)False

Question 17

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

A workbook marked as final is read-only.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a feature of change tracking?

Accepted Answer

A) Delete changes 
B) E-mail changes 
C) Add changes 
D) Highlight changes 
A) Delete changes 
B) E-mail changes 
C) Add changes 
D) Highlight changes

Exam 28: Excel : Collaboration and Workbook Distribution

If a password is lost is cannot be ________.

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

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

When a history worksheet is created,it is ________ when the file is saved.

Which of the following items is not stored as metadata in a workbook?

What are some ways to protect a workbook?

Which of following is the default file format for Excel 97-2003?

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

Excel can export PDF files.

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

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

The default comment print setting is:

Shared workbooks only function properly on network drives that are read-only.

Excel cannot save workbooks for previous versions of Excel.

Which dialog box allows the user to print all comments?

Which Excel Options category contains Editing options?

A workbook marked as final is read-only.

Which of the following is a feature of change tracking?

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