Question 1

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

Accepted Answer

A)  guideline 
B)  validation rule 
C)  validation text 
D)  check list 
A)  guideline 
B)  validation rule 
C)  validation text 
D)  check list

Question 2

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

Accepted Answer

A)  Reporting 
B)  Formulas 
C)  Temp View 
D)  Subtotal 
A)  Reporting 
B)  Formulas 
C)  Temp View 
D)  Subtotal

Question 3

Using a(n) ____ lets you view two sets of data at once for convenience.

Accepted Answer

A)  Data Validation window 
B)  Invalid Data feature 
C)  Subtotal feature 
D)  Watch Window 
A)  Data Validation window 
B)  Invalid Data feature 
C)  Subtotal feature 
D)  Watch Window

Question 4

In the outline format, you can click the plus (+) button to collapse or hide the data.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ feature is useful when you want to view totals in the worksheet data but you don't want formulas permanently entered into the worksheet at that time.

Accepted Answer

The answer of The ____________________ feature is useful when you...

Question 6

If the ____ style is selected in the Error Alert tab of the Data Validation dialog box, you will not be allowed to enter any value that does not meet the criteria.

Accepted Answer

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

Question 7

The ____ is the location in the worksheet where data separated by Excel will be placed.

Accepted Answer

A)  delimiter 
B)  keyhole range 
C)  separated range 
D)  destination range 
A)  delimiter 
B)  keyhole range 
C)  separated range 
D)  destination range

Question 8

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Finding the ____ would give Venecia the total for all the data in the worksheet.

Accepted Answer

A)  column total 
B)  grand total 
C)  subtotal 
D)  final total 
A)  column total 
B)  grand total 
C)  subtotal 
D)  final total

Question 9

The Data Validation Wizard provides a step-by-step process to help you choose how to separate your data.

Accepted Answer

A) True 
 B)False

Question 10

Adding data validation to your worksheet cells helps you monitor the accuracy of the data that's being entered.

Accepted Answer

A) True 
 B)False

Question 11

When the exact amounts that you want to enter in the Data Validation dialog box are in the worksheet, you can click the Collapse dialog box button and then select the cell with the amount.

Accepted Answer

A) True 
 B)False

Question 12

Using the Error Alert tab in the Data Checking dialog box, you can create an error alert that appears when a value you enter does not fall within the range.

Accepted Answer

A) True 
 B)False

Question 13

The Watch Window remains open while the workbook is open.

Accepted Answer

A) True 
 B)False

Question 14

Discuss the reasons for using the Subtotal feature rather than adding formulas in a worksheet.

Accepted Answer

You can add formulas to a worksheet that

Question 15

You can add formulas to a worksheet that instantly calculate totals within the worksheet data using Excel's ____ feature.

Accepted Answer

A)  Quick Formula 
B)  Totals 
C)  Sum 
D)  Subtotal 
A)  Quick Formula 
B)  Totals 
C)  Sum 
D)  Subtotal

Question 16

The Data Validation button is found on the ____ tab on the Ribbon.

Accepted Answer

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

Question 17

A ____ is a character, such as a comma, space, or a tab, used to separate data.

Accepted Answer

A)  ruler 
B)  delimiter 
C)  subtotal 
D)  spreader 
A)  ruler 
B)  delimiter 
C)  subtotal 
D)  spreader

Question 18

The ____ feature formats the worksheet in an outline, which lets you automatically display or hide data.

Accepted Answer

A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Circle Invalid Data 
A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Circle Invalid Data

Question 19

Once you select a validation range and enter a validation rule for the validation range, the data entered into this range is no longer monitored.

Accepted Answer

A) True 
 B)False

Question 20

The ____ is the total for all the data.

Accepted Answer

A)  row total 
B)  grand total 
C)  subtotal 
D)  pre-total 
A)  row total 
B)  grand total 
C)  subtotal 
D)  pre-total

Exam 17: Improving Data Accuracy

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

Using a(n) ____ lets you view two sets of data at once for convenience.

In the outline format, you can click the plus (+) button to collapse or hide the data.

The ____________________ feature is useful when you want to view totals in the worksheet data but you don't want formulas permanently entered into the worksheet at that time.

If the ____ style is selected in the Error Alert tab of the Data Validation dialog box, you will not be allowed to enter any value that does not meet the criteria.

The ____ is the location in the worksheet where data separated by Excel will be placed.

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Finding the ____ would give Venecia the total for all the data in the worksheet.

The Data Validation Wizard provides a step-by-step process to help you choose how to separate your data.

Adding data validation to your worksheet cells helps you monitor the accuracy of the data that's being entered.

When the exact amounts that you want to enter in the Data Validation dialog box are in the worksheet, you can click the Collapse dialog box button and then select the cell with the amount.

Using the Error Alert tab in the Data Checking dialog box, you can create an error alert that appears when a value you enter does not fall within the range.

The Watch Window remains open while the workbook is open.

Discuss the reasons for using the Subtotal feature rather than adding formulas in a worksheet.

You can add formulas to a worksheet that instantly calculate totals within the worksheet data using Excel's ____ feature.

The Data Validation button is found on the ____ tab on the Ribbon.

A ____ is a character, such as a comma, space, or a tab, used to separate data.

The ____ feature formats the worksheet in an outline, which lets you automatically display or hide data.

Once you select a validation range and enter a validation rule for the validation range, the data entered into this range is no longer monitored.

The ____ is the total for all the data.

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