Chapter 6

Question 1

A ____ should be formatted so that the records are easily distinguished.

Answer 1

table

Question 2

A ____ total sums all of the data in a row or column.

Answer 2

grand

Question 3

A worksheet’s row-and-column structure can be used to organize and store a ____.

Answer 3

table

Question 4

Data is in ____ sequence if it is in order from lowest to highest.

Answer 4

ascending

Question 5

Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.

Answer 5

field

Question 6

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

Answer 6

12

Question 7

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

Answer 7

arguements

Question 8

f you deselect an item from the filter menu, it is called the filter ____.

Answer 8

criterion

Question 9

In a table, a column that contains formulas or functions is called a(n) ____.

Answer 9

calculated column

Question 10

In a table, or database, the data related to each person or item is called a ____.

Answer 10

record

Question 11

Like the AutoFilter query technique, the ____ command displays a subset of the table.

Answer 11

Advanced Filter

Question 12

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

Answer 12

Rules Manager

Question 13

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

Answer 13

Table Array

Question 14

The ____ function is used when the table direction is horizontal.

Answer 14

HLookup

Question 15

The ____ function is useful when you want to add values in a range only if they meet criteria.

Answer 15

SUMIF

Question 16

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

Answer 16

index

Question 17

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

Answer 17

Match

Question 18

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

Answer 18

criteria

Question 19

The field or fields selected for sorting records are called ____ keys.

Answer 19

sort

Question 20

The left column values in a table array are called table ____.

Answer 20

arguments

Question 21

The general form of the VLOOKUP function is ____.

Answer 21

=VLOOKUP(lookup_value, lookup_table, col_index_num)

Question 22

The most common subtotal uses the ____ function.

Answer 22

SUM

Question 23

The process of filtering activity based on one or more filter criteria is called a ____.

Answer 23

query

Question 24

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

Answer 24

3,4,5

Question 25

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.

Answer 25

Convert to Range

Question 26

When you first create a table, Excel automatically enables ____.

Answer 26

AutoFilter

Question 27

Which of the following is NOT a type of conditional formatting?

Answer 27

Row Banding

Question 28

Which of the following is the path to the ‘Sort & Filter’ button?

Answer 28

(HOME tab | Editing group)

Question 29

Which of the following is the path to the Format as Table button?

Answer 29

(HOME tab | Styles group)

Question 30

Which of the following is the path to the Total Row check box?

Answer 30

(TABLE TOOLS DESIGN tab | Table Style Options group)

Question 31

Why is the VLOOKUP function used more often than other lookup functions?

Answer 31

Because most tables are vertical

Question 32

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

Answer 32

quotation marks

Question 33

You can insert a ____ at the bottom of a table.

Answer 33

total row

Question 34

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Answer 34

Row Banding

Question 35

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Answer 35

Conditional

Question 36

____ is extremely useful for making large tables more manageable in size and appearance.

Answer 36

Outlining