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:

Citations

References to the source of information or ideas, usually listed at the end of scholarly work.

Scholarly Journals

Peer-reviewed publications that present academic research and expert analysis on specific subjects.

Search Engine

A software system designed to carry out web searches, which means to search the World Wide Web in a systematic way for particular information specified in a textual web search query.

Database

A structured set of data held in a computer, especially one that is accessible in various ways.