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:

Fixed-Rate Mortgage

A mortgage with an interest rate that remains constant throughout the life of the loan.

Acceleration Clause

A contract provision that allows a lender to require a borrower to repay all of an outstanding loan if certain agreed upon conditions are not met.

Market Value

The price at which an asset would trade in a competitive auction setting, reflecting what a willing buyer would pay a willing seller.

Mortgage

A loan in which property or real estate is used as collateral. The borrower agrees to pay back the loan, with interest, over a set period of time.