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:

Total Assets

represent the summation of everything a company owns, both current and non-current, that can be used for paying debts, investments, or other operations.

Fair Value Enterprise Method

A methodology for valuation that estimates the value of an entire enterprise as if it were traded in the market, based on the fair value of its assets and liabilities.

Consolidated Balance Sheet

A financial statement that aggregates the financial position of a parent company and its subsidiaries, presenting them as a single economic entity.

Consolidated Financial Statements

Financial statements that show the financial results of a parent company and its subsidiaries as if they were a single entity.