Multiple Choice
A jewelry designer creates an excel sheet to list different items he sold on the previous day.Cells A1,B1,C1,and D1 contain headings-Order ID,Unit price,and Quantity,respectively.Cells A2 to A6 list the order ID for items sold-10001,10002,10003,10004,and 10005,respectively.Cells B2 to B6 list their respective unit price-$15,$18.5,$12,$9.5,and $6.Cells C2 to C6 list their respective quantities-20,32,16,15,and 10.If he enters the formula in cell D1 as: =VLOOKUP (10005,A1: H3,3,FALSE) ,what will the formula return?
A) 10
B) $6
C) $12
D) 10003
Correct Answer:
Verified
Correct Answer:
Verified
Q26: Which formula can you use to extract
Q27: Your worksheet contains a price in cell
Q28: To insert an equation,click on the Object
Q29: To have Excel enter the lowest price
Q30: What is the correct formula to insert
Q32: In the formula =B6*$B$2,which of the following
Q33: Kamala enters a date as the start
Q34: Which of the following is true about
Q35: A student is asked to find the
Q36: Which of the following functions would you