Excel Lab 3

In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

• It's using conditional formating

• It's using the Currency number format

• It's using a formula

• It's using an absolute cell reference

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• There is nothing wrong with the formula

• It should use the Count function instead

• It should use quotation marks instead of parentheses

• It should have an equal (=) sign at the beginning

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return?

• The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.

• The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found.

• The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.

• Don’t know

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return?

• The price for the product found in column A (or #N/A if the exact product number can't be found).

• The number for the product in column A (or #N/A if the exact product number can't be found).

• The price for the product found in column A (or the closest product if the exact product number can't be found).

• Don’t know

Suppose cells A2:B20 contain a table with sorted product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2) return?

• The price for the product found in column A (or the closest product if the exact product number can't be found)

• The product number for the product in column A (or the closest product if the exact product number can't be found)

• The price for the product found in column A (or #N/A if the exact product number can't be found)

• Don’t know

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

• =VLOOKUP(lookup_value, col_index_num, table_array, range_lookup)

• =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)

• =VLOOKUP(lookup_value, table_array, col_index_num, value)

• =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Validation makes sure that data is....

• Correct

• Nonsense

• Suitable

• Numerical

What is the correct formula for this?

• =HLOOKUP(A4,A1:H2,2,FALSE)

• =VLOOKUP(F1, A1:H2,2, TRUE)

• =HLOOKUP(F1, A1:H2,2, TRUE)

• =VLOOKUP(A4, A1:H2,2, FALSE)

Which formula returns the value of cell C5 if this value is greater than 5?

• =C5=TRUE=C5

• =IF(C5=5,C5,0)

• =IF(C5>5,C5,0)

• =IF(C5>5,0,C5)

Which is the correct way to write this function:

IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.

• =IF(C4<75,C4*10,0)

• =IF(C4<75,"Multiply 10","0")

• =IF(C4<75,C4x10,0)

• =IF(C4>75,C4*10,0)