A Shopkeeper Creates an Excel Sheet to List Different Items

question 37

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

---

Definitions:

Bank Loan

A sum of money lent by a bank to a borrower at a specified interest rate for a fixed term or on an on-demand basis.

Quarterly Deposits

Regular payments or contributions put into a financial account or investment four times per year.

APR Interest

Annual Percentage Rate; the annual rate charged for borrowing or earned through an investment, which includes any fees or additional costs associated with the transaction.

Received Monthly

Regular payments or incomes that are received every month, often related to salaries, benefits, or recurring revenue streams.