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:

Personal Interests

The hobbies, activities, or subjects a person is passionate about or enjoys engaging in during their leisure time.

Raise Money

The process of acquiring funds to support a project, initiative, or organization, typically through investments, donations, or loans.

Boards

Groups of individuals elected or appointed to oversee and guide the policies, strategic direction, and financial stewardship of an organization.

Monitoring Performance

The continuous process of evaluating and assessing the performance of a program, project, or employee over time to ensure objectives are being met.