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:

Conflict

A disagreement or confrontation resulting from differing needs, values, or interests between individuals or groups.

Group Participation

Involvement and active engagement of members within a group or team towards achieving common goals.

Specificity

The condition or quality of being specific, precise, or particular.

Solvable Problem

An issue that can be resolved or addressed through specific actions or strategies.