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.5
C) $12.50
D) 1002

Question

Quizplus · Accepted Answer

The formula uses the HLOOKUP function to search for the value "1004" in the range A1:H3. It searches for the value in the first row of the range, which contains the headings. Since the third argument is 2, it returns the value from the second row, which is the selling price corresponding to the "1004" order ID. Therefore, the formula will return $7.5.

A Shopkeeper Creates an Excel Sheet to List Different Items