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:

Incident Report

Confidential document that describes any patient accident while the person is on the premises of a health care agency.

Nasogastric Tube

A flexible tube passed through the nose into the stomach for feeding or drainage purposes.

Increased Aggressiveness

A noticeable escalation in forceful, possibly hostile, behaviors or attitudes toward others.

Substance Abuse

The harmful or hazardous use of psychoactive substances, including alcohol and illicit drugs, leading to addiction or dependency.