Solved

The Table_array Argument Must Contain ____ Cell References So That

Question 5

Multiple Choice

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

A) absolute
B) relative
C) simple
D) complex

Related Questions

Q1: When you write a VLOOKUP formula, you

Q2: The syntax of the LOOKUP function is

Q3: When using the MATCH function, the lookup_array

Q4: In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell

Q6: When using an INDEX function, you can

Q7: The LOOKUP function uses only a TRUE

Q8: You use VLOOKUP when _ of the

Q9: The INDEX function allows you to specify

Q10: In a(n) _ table, Excel can search

Q11: For a VLOOKUP table, list the key