Excel Module 6 & 7 Test Review

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

• VLOOKUP
• HLOOKUP
• MLOOKUP
• ZLOOKUP

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

• HLOOKUP
• ZLOOKUP
• VLOOKUP
• 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

____ 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

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

• AutoFunction
• AutoCalculate
• AutoFilter
• AutoFormula

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

• Sorting
• Filtering
• Extracting
• Formatting

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

• DCOUNT
• MATCH
• INDEX
• SUMIF

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

• guide
• program
• template
• budget

When a template is created, dummy ____ is/are used to verify the formulas in the template.

• formulas
• data
• formatting
• page layout

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

• formatted
• transposed
• deleted
• none of the above