Deck 17: Improving Data Accuracy

Question 1

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.

Answer 1

True

Question 2

The Watch Window remains open while the workbook is open.

Answer 2

True

Question 3

A ____ is the total of only specific parts of the data.

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

Answer 3

C

Question 4

You can create custom sorting options in Excel.

Question 5

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

Question 6

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.

Question 7

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.

Question 8

The Circle Invalid Data feature helps you ensure that valid data is entered into a worksheet.

Question 9

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

Question 10

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

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.

Question 12

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

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

Question 13

Choosing the Information style in the Error Alert tab of the Data Validation dialog box allows data to be entered but simply displays an information box with a message that the data entered is invalid.

Question 14

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

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

Question 15

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

Question 16

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

Question 17

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

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

Question 18

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

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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.

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

Question 23

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

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

Question 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

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.

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

Question 28

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

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

Question 29

The ____ is the total for all the data.

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

Question 30

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

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

Question 31

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

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

Question 32

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

Question 33

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

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

Question 34

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

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

Question 35

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

A) item 1
B) item 2
C) item 3
D) item 4

Question 36

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

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

Question 37

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) ____.

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

Question 38

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. Venecia wants to quickly view the totals for the worksheet but does not want to store that information permanently in the worksheet. She needs to use the ____ feature.

A) Grand totals
B) Formulas
C) Temp Formulas
D) Subtotal

Question 39

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.

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

Question 40

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.

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

Question 41

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

Question 43

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.

Question 44

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

Question 45

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

Question 46

To create a drop-down list, it is easier if you first create a(n) ____________________ of cells that has the selections that should appear in the list.