Solved

In the Formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), If Cell A9 Is Blank

Question 4

Multiple Choice

In the formula =IF(ISBLANK(A9) ," ",VLOOKUP(A9,Products,2,FALSE) ) , if cell A9 is blank, Excel displays ____.

A) a string of empty characters
B) the word "products"
C) the word "FALSE"
D) the error "#VALUE"

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

Q5: The table_array argument must contain _ 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