Question 1

Choosing the ____ style in the Error Alert tab of the Data Validation dialog box displays a warning dialog box but allows the data to be entered.

Accepted Answer

A)  Warning 
B)  Information 
C)  Stop 
D)  Strict 
A)  Warning 
B)  Information 
C)  Stop 
D)  Strict A

Question 2

The Sort button is found on the ____ tab on the Ribbon.

Accepted Answer

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

Question 3

To join the values of cells together, you use the ____ function.

Accepted Answer

A)  Concatenate 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Join 
A)  Concatenate 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Join A

Question 4

Excel places circles around any invalid data using the ____________________ feature.

Accepted Answer

The answer of Excel places circles around any invalid data...

Question 5

The range of cells that you select to apply the validation rule is called the ____________________.

Accepted Answer

The answer of The range of cells that you select...

Question 6

When the Watch Window first appears, it only includes the workbook name and the worksheet name.

Accepted Answer

A) True 
 B)False

Question 7

In Excel, you need to sort one column of data at a time.

Accepted Answer

A) True 
 B)False

Question 8

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. Sharon wants to make sure that whenever she enters the information for a new book in her worksheet, it is entered in the correct format and as accurately as possible. She needs to use the ____ feature.

Accepted Answer

A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Data Checking 
A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Data Checking

Question 9

The ____ feature can be used to ensure that data is entered as accurately as possible in a worksheet.

Accepted Answer

A)  Data Validation 
B)  CheckList 
C)  Reporting 
D)  Data Structure 
A)  Data Validation 
B)  CheckList 
C)  Reporting 
D)  Data Structure

Question 10

FIGURE EX 11-1   Figure EX 11-1 above shows the ____ feature applied to the worksheet.

Accepted Answer

A)  Table Format 
B)  Subtotal 
C)  Watch Window 
D)  Data Validation 
A)  Table Format 
B)  Subtotal 
C)  Watch Window 
D)  Data Validation

Question 11

When you add subtotals to a worksheet, the worksheet is displayed in an outline format.

Accepted Answer

A) True 
 B)False

Question 12

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

Accepted Answer

A)  Delimiter 
B)  Cell Watch 
C)  Watch Window 
D)  Concatenation Window 
A)  Delimiter 
B)  Cell Watch 
C)  Watch Window 
D)  Concatenation Window

Question 13

Drop-down lists are not useful when only specific data can be entered into a cell.

Accepted Answer

A) True 
 B)False

Question 14

You can use the ____ feature to have circles drawn around data that does not meet the data validation requirements.

Accepted Answer

A)  Circle Invalid Data 
B)  Data Checking 
C)  Circle Problems 
D)  Format Checking 
A)  Circle Invalid Data 
B)  Data Checking 
C)  Circle Problems 
D)  Format Checking

Question 15

You can create custom sorting options in Excel.

Accepted Answer

A) True 
 B)False

Question 16

To remove subtotals from the data, click any cell with data. Click the Subtotal button and then click Remove All in the Subtotal dialog box.

Accepted Answer

A) True 
 B)False

Question 17

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

Accepted Answer

A)  Data Validation 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Concatenation 
A)  Data Validation 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Concatenation

Question 18

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. If Sharon decides to go to another worksheet in the workbook, she can still view data from the Books worksheet by using a(n) ____.

Accepted Answer

A)  Sub Window 
B)  Watch Window 
C)  Message Window 
D)  Add Window 
A)  Sub Window 
B)  Watch Window 
C)  Message Window 
D)  Add Window

Question 19

To add subtotals, you select the Subtotal button to display the available options you can select in the ____________________ dialog box.

Accepted Answer

The answer of To add subtotals, you select the Subtotal...

Question 20

Match between columns
                        Premises: A feature that instantly adds a formula that totals the worksheet data to a cell.
Displays specific selections from which you can choose.
An option that separates data for you, rather than you having to retype it yourself.
A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.
A feature that is used to set rules about how data can be entered.

Accepted Answer

The Answer of Data Validation and Subtotal and Convert Text is...

Exam 17: Improving Data Accuracy

Choosing the ____ style in the Error Alert tab of the Data Validation dialog box displays a warning dialog box but allows the data to be entered.

The Sort button is found on the ____ tab on the Ribbon.

To join the values of cells together, you use the ____ function.

Excel places circles around any invalid data using the ____________________ feature.

The range of cells that you select to apply the validation rule is called the ____________________.

When the Watch Window first appears, it only includes the workbook name and the worksheet name.

In Excel, you need to sort one column of data at a time.

The ____ feature can be used to ensure that data is entered as accurately as possible in a worksheet.

FIGURE EX 11-1 Figure EX 11-1 above shows the ____ feature applied to the worksheet.

When you add subtotals to a worksheet, the worksheet is displayed in an outline format.

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

Drop-down lists are not useful when only specific data can be entered into a cell.

You can use the ____ feature to have circles drawn around data that does not meet the data validation requirements.

You can create custom sorting options in Excel.

To remove subtotals from the data, click any cell with data. Click the Subtotal button and then click Remove All in the Subtotal dialog box.

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

To add subtotals, you select the Subtotal button to display the available options you can select in the ____________________ dialog box.

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

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

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