A Shopkeeper Creates an Excel Sheet to List Different Items

question 46

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

---

Definitions:

Capital Spending

Expenditures by businesses to acquire or upgrade physical assets such as property, industrial buildings, or equipment to increase their capacity or efficiency.

Incorporating

The process of legally declaring a business as a corporation, providing it with specific legal rights and protections.

Limited Liability

A legal structure that limits the personal financial responsibility of shareholders, partners, or owners for company debts and obligations.

Common Stock

Equity ownership in a corporation, with voting rights and the potential to receive dividends.