Excel Module 6

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

• cell

• function

• formula

• table

As a database in Excel, each row of a worksheet can store a record, and each column can store a(n) _____.

• element

• field

• entity

• record

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

• Row separating

• Row shielding

• Row coloring

• Row banding

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

• ZLOOKUP

• MLOOKUP

• VLOOKUP

• HLOOKUP

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

• because it is the default lookup function

• because it is easier to implement

• because most tables are vertical

• because it has more powerful calculations

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

• Cell

• Styles

• Conditional

• Quick

Which of the following is a type of conditional formatting?

• icon sets

• data bars

• highlight

• all of the above

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

• Rules Manager

• Name Manager

• Rules Wizard

• Name Wizard

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

• sort

• field

• rules

• records

The _____ function will sum values in a range only if they meet criteria.

• DSUM

• DCOUNT

• SUMIF

• COUNTIF