Question 1

To protect your Excel data from unwanted changes, you can add ____ protection to worksheets and workbooks.

Accepted Answer

A)  username 
B)  password 
C)  database 
D)  tracking 
A)  username 
B)  password 
C)  database 
D)  tracking

Question 2

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

Accepted Answer

A)  Advanced 
B)  Options 
C)  Manage 
D)  Data 
A)  Advanced 
B)  Options 
C)  Manage 
D)  Data

Question 3

If someone tries to open a password-protected workbook, he or she will first be prompted to enter the ____ in a dialog box.

Accepted Answer

A)  file name 
B)  author name 
C)  list of changes 
D)  password 
A)  file name 
B)  author name 
C)  list of changes 
D)  password

Question 4

You click the ____ button to select the Encrypt with Password option.

Accepted Answer

A)  Save Options 
B)  Encryption 
C)  Track Changes 
D)  Protect Workbook 
A)  Save Options 
B)  Encryption 
C)  Track Changes 
D)  Protect Workbook

Question 5

Figure EX 16-1   To see the options shown in Figure EX 16-1 above, you first need to click the ____ tab.

Accepted Answer

A)  File 
B)  Home 
C)  Review 
D)  View 
A)  File 
B)  Home 
C)  Review 
D)  View

Question 6

To prevent a workbook from being opened by an unauthorized person, you can ____-protect a workbook.

Accepted Answer

A)  password 
B)  change 
C)  share 
D)  network 
A)  password 
B)  change 
C)  share 
D)  network

Question 7

Match between columns
                        Premises: Making the data in the file not be scrambled anymore.
The information in the file is scrambled.
A sequence of characters, known only by you, that is required for access to a file.
A feature that allows several people to work in a workbook simultaneously.
A feature that shows changes made to an Excel worksheet.

Accepted Answer

The Answer of password and Share Workbook and encrypting and is...

Question 8

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

Accepted Answer

A)  Track Changes 
B)  Password 
C)  Encryption 
D)  Decryption 
A)  Track Changes 
B)  Password 
C)  Encryption 
D)  Decryption

Question 9

When you have a worksheet that several people have access to, you run the risk of unwanted changes.

Accepted Answer

A) True 
 B)False

Question 10

When you make changes to a shared workbook, Excel keeps track of the changes.

Accepted Answer

A) True 
 B)False

Question 11

Case EX 16-1 George is the manager of a party planning company. He uses an Excel workbook to keep track of the parties that the company is planning or has planned in the past. George is concerned about a competitor gaining access to the information in the workbook. To make sure that there are no unwanted or unauthorized changes to the main sheet of the workbook, George can use the ____ dialog box.

Accepted Answer

A)  Protect Sheet 
B)  Password Protect 
C)  Encrypt Document 
D)  Encrypt Sheet 
A)  Protect Sheet 
B)  Password Protect 
C)  Encrypt Document 
D)  Encrypt Sheet

Question 12

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

Accepted Answer

The answer of To prevent changes to a worksheet, you...

Question 13

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

Accepted Answer

A) True 
 B)False

Question 14

The Track Changes arrow button is found on the ____ tab.

Accepted Answer

A)  Data 
B)  Home 
C)  File 
D)  Review 
A)  Data 
B)  Home 
C)  File 
D)  Review

Question 15

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

Accepted Answer

The answer of If you place your mouse pointer over...

Question 16

The Share Workbook button is found on the ____ tab.

Accepted Answer

A)  Home 
B)  Data 
C)  View 
D)  Review 
A)  Home 
B)  Data 
C)  View 
D)  Review

Question 17

With the Track Changes feature enabled, a(n) border will appear around the changed cells until the file is closed.

Accepted Answer

A) True 
 B)False

Question 18

You enable the Share Workbook feature using the ____________________ dialog box.

Accepted Answer

The answer of You enable the Share Workbook feature using...

Question 19

You can add ____ protection to an entire workbook.

Accepted Answer

A)  track name 
B)  username 
C)  password 
D)  watermark 
A)  track name 
B)  username 
C)  password 
D)  watermark

Question 20

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

Accepted Answer

A) True 
 B)False

Exam 22: Protecting, Tracking, and Sharing Workbooks

To protect your Excel data from unwanted changes, you can add ____ protection to worksheets and workbooks.

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

If someone tries to open a password-protected workbook, he or she will first be prompted to enter the ____ in a dialog box.

You click the ____ button to select the Encrypt with Password option.

Figure EX 16-1 To see the options shown in Figure EX 16-1 above, you first need to click the ____ tab.

To prevent a workbook from being opened by an unauthorized person, you can ____-protect a workbook.

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

When you have a worksheet that several people have access to, you run the risk of unwanted changes.

When you make changes to a shared workbook, Excel keeps track of the changes.

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

The Track Changes arrow button is found on the ____ tab.

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

The Share Workbook button is found on the ____ tab.

With the Track Changes feature enabled, a(n) border will appear around the changed cells until the file is closed.

You enable the Share Workbook feature using the ____________________ dialog box.

You can add ____ protection to an entire workbook.

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters