Lookup Functions and Formula Auditing

Question 1

If the VLOOKUP function is used to find an approximate match, what will it return if there is no exact match?

Revolt · Accepted Answer

the largest value that is less than the lookup value

Question 2

Complete each sentence to describe features of the VLOOKUP function.

Revolt · Accepted Answer

✔ lookup value; The VLOOKUP function structure begins with =VLOOKUP( , …): lookup value; The VLOOKUP function structure begins with =VLOOKUP( , …): table array; To use the VLOOKUP function, the lookup value should be in the of the table.: first column

Question 3

✔ table arraycol index numrange lookuplookup value

Revolt · Accepted Answer

✔ table array

Question 4

last row✔ first columntop right cell

Revolt · Accepted Answer

✔ first column

Question 5

What are the steps for using the Evaluate Formula feature?

Revolt · Accepted Answer

In the group, click .: Formula Auditing; In the group, click .: Evaluate Formula; Click Evaluate or to start the process.: Step In

Question 6

ReviewingMonitoringCell Observation✔ Formula Auditing

Revolt · Accepted Answer

✔ Formula Auditing

Question 7

Watch WindowTrace DependentsTrace Precedents✔ Evaluate Formula

Revolt · Accepted Answer

✔ Evaluate Formula

Question 8

AddClose✔ Step InStep Out

Revolt · Accepted Answer

✔ Step In

Question 9

To use the VLOOKUP function, where should the lookup value be located in a table?

Revolt · Accepted Answer

the first column

Question 10

Which color of trace arrow shows a relationship between cells in the same worksheet?

Revolt · Accepted Answer

blue

Lookup Functions and Formula Auditing Answers

More from this Course

TRY EDGENUITY HACKS