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:

Conformity

Refers to the act of matching attitudes, beliefs, and behaviors to what is perceived as normative social standards or expectations.

Informational Power

The influence one may have over others stemming from the possession or control of knowledge and information.

Reliable Source

An entity or individual that consistently provides accurate and trustworthy information, often used in the context of gathering evidence or news.

Deliberately Withholds

Refers to the intentional act of not providing information or resources that could be beneficial or necessary for others.