Multiple Choice
A shopkeeper creates an Excel sheet to list different items he sold today.Rows A1 to A3 contain headings-Order ID,Selling price,and Quantity,respectively.Cells B1 to H1 list the order ID for the items sold-1001,1002,1003,1004,and 1005,respectively.Cells B2 to H2 list their respective selling price-$10,$12.5,$14,$7.5,and $8.Cells B3 to H3 list their respective quantities-10,12,6,5,and 13.If he enters the formula in cell J1 as: =HLOOKUP (1004,A1: H3,2,FALSE) ,what will the formula return?
A) 5
B) $7.50
C) $12.50
D) 1002
Correct Answer:
Verified
Correct Answer:
Verified
Q11: We can use the Remove Duplicates feature
Q11: The score of a student inserted in
Q14: A student creates data for trees in
Q16: A teacher creates a table that contains
Q18: Which of the following will you select
Q19: Which of the following will you do
Q21: The components of a structured reference are
Q33: To delete duplicate records from a table,select
Q37: Kathy wants to rename a table she
Q40: To collapse data views using the Outline