Lookup Functions and Formula Auditing

What are the steps for using the Evaluate Formula feature? 1. Select the cell with the formula you want to evaluate. 2. Click the _______ tab on the ribbon. 3. In the _________ Auditing group, click Watch ________ Formula. 4. Click Evaluate or __________ Out to start the process.

1. Formulas 2. Formulas auditing 3. evaluate formula 4. Step In

Complete each sentence to describe features of the VLOOKUP function. The VLOOKUP function structure begins with =VLOOKUP(______, _______... ) To use the VLOOKUP function, the lookup value should be in the _______ of the table.

1. lookup value 2. table array 3. first column

Which color of trace arrow shows a relationship between cells in the same worksheet? A) blue B) red C) black D) black with dashes

A) blue

To use the VLOOKUP function, where should the lookup value be located in a table? A) the first row B) the last row C) the first column D) the last column

C) the first column

If the VLOOKUP function is used to find an approximate match, what will it return if there is no exact match? A) the largest value in the table B) the smallest value in the table C) the largest value that is less than the lookup value D) the smallest value that is greater than the lookup value

C) the largest value that is less than the lookup value