A Small Grocery Owner Creates a Table for the Different

question 30

Multiple Choice

A small grocery owner creates a table for the different types of fruits sold in his shop. He inserts headings in cells A1, B1, C1, and D1 as Order ID, Fruit, Unit Price, and Quantity. He then inserts Order ID 1001 to 1004 for each fruit in cells A2 to A5, respectively, type of fruits—Apples, Oranges, Mangoes, and Grapes in cells B2 to B5, respectively, unit price of each fruit as $10, $9, $30, and $18 in cells C2 to C5, respectively, and quantity of each fruit as 5, 7, 8, and 9 in cells D2 to D5, respectively. In cell F1, he inserts the formula: =LOOKUP(1003, A1:A5, B1:B5) . What will the following function return?

• A) 8
• B) $30
• C) 1003
• D) Mangoes

---

Definitions:

Vocal Pitch

The perceived frequency of sound produced by the human voice, differing in highness or lowness.

Eye Contact

The act of looking directly into another person's eyes, an important non-verbal communication tool that can convey confidence, interest, and emotional state.

Posture Shifts

Alterations in body position or stance that can convey non-verbal communication or reflect changes in emotional states.

Mysterious

Something that is difficult or impossible to understand, explain, or identify.