Excel - Module 6 Worksheet

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

• table

• formula

• function

• cell

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

• record

• entity

• field

• element

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

• formula

• field

• calculation

• record

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

• Row coloring

• Row shielding

• Row banding

• Row separating

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

• VLOOKUP

• HLOOKUP

• ZLOOKUP

• MLOOKUP

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

• Because it has more powerful calculations

• Because most tables are vertical

• Because it is easier to implement

• Because it is the default lookup function

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

• text

• arguments

• functions

• dollar signs

The general form of the VLOOKUP function is ____.

• =VLOOKUP(lookup_table, col_index_num)

• =VLOOKUP(lookup_value, row_index_num)

• =VLOOKUP(lookup_value, lookup_table_array, col_index_num)

• =VLOOKUP(lookup_value)

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

• Quick

• Conditional

• Styles

• Cell

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

• Highlight Cells Rules

• Icon Sets

• Data Bars

• Row Banding