Ite 140 Ch05

Front 1

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

Back 1

table

Front 2

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

Back 2

field

Front 3

In a table, a column that contains formulas or functions is called a calculated _____.

Back 3

column

Front 4

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

Back 4

record

Front 5

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

Back 5

table

Front 6

Even though Excel is not a true _____ management system like Access, it does give you many of the same basic capabilities.

Back 6

database

Front 7

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

Back 7

(Home tab | Styles group)

Front 8

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

Back 8

Row banding

Front 9

A _____ column is a column in a table in which each row uses a common formula that references other fields in the table.

Back 9

calculated

Front 10

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 click _____ on the Table submenu.

Back 10

Convert to Range

Front 11

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

Back 11

HLOOKUP

Front 12

The _____ function is used when a table direction is vertical.

Back 12

VLOOKUP

Front 13

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

Back 13

because most tables are vertical

Front 14

A value being looked up outside the range of the table causes the VLOOKUP function to return the _____ error message.

Back 14

#N/A

Front 15

The VLOOKUP function searches the far-left column of the _____.

Back 15

table array

Front 16

For the VLOOKUP function to work correctly, the table _____ must be in ascending sequence.

Back 16

arguments

Front 17

The table_array contains what are called table _____.

Back 17

The table_array contains what are called table _____.

Front 18

The general form of the VLOOKUP function is _____.

Back 18

=VLOOKUP(lookup_value, table_array, col_index_num)

Front 19

You can hide columns in a table by pressing the _____ keyboard shortcut keys.

Back 19

CTRL+0

Front 20

If columns contain sensitive information, such as salary information, you can _____ the columns.

Back 20

hide

Front 21

Which of the following is the path to the Lookup & Reference button?

Back 21

(Formulas tab | Function Library group)

Front 22

_____ 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.

Back 22

Conditional

Front 23

Conditional formatting allows you to create _____ that change the formatting of a cell or range of cells based on the value of a cell.

Back 23

rules

Front 24

Which of the following is a type of conditional formatting?

Back 24

All of the above

Front 25

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

Back 25

Rules Manager

Front 26

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

Back 26

(Table Tools Design tab | Table Style Options group)

Front 27

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

Back 27

ascending

Front 28

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

Back 28

sort

Front 29

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

Back 29

(Home tab | Editing group)

Front 30

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

Back 30

query

Front 31

You can display all records in the table after a query hid some of the records by clicking the Filter button on the _____.

Back 31

(Data tab | Sort & Filter group)

Front 32

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.

Back 32

3, 4, 5

Front 33

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

Back 33

Advanced Filter

Front 34

_____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Back 34

Extracting

Front 35

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

Back 35

criteria

Front 36

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

Back 36

12