A Shopkeeper Creates an Excel Sheet to List Different Items

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