A Jewelry Designer Creates an Excel Sheet to List Different

question 31

Multiple Choice

A jewelry designer creates an excel sheet to list different items he sold on the previous day.Cells A1,B1,C1,and D1 contain headings-Order ID,Unit price,and Quantity,respectively.Cells A2 to A6 list the order ID for items sold-10001,10002,10003,10004,and 10005,respectively.Cells B2 to B6 list their respective unit price-$15,$18.5,$12,$9.5,and $6.Cells C2 to C6 list their respective quantities-20,32,16,15,and 10.If he enters the formula in cell D1 as: =VLOOKUP (10005,A1: H3,3,FALSE) ,what will the formula return?

• A) 10
• B) $6
• C) $12
• D) 10003

---

Definitions:

Specialization

The process in economics and production where individuals or entities focus on a narrow area of expertise to increase efficiency and output.

Professional Mourners

Individuals hired to attend funerals and exhibit signs of grief, a practice seen in various cultures to honor the deceased.

Online Sellers

Businesses or individuals that sell goods or services over the internet.

Opportunity Cost

The cost of the next best alternative foregone when making a decision.