Previous Page

Page $1$ of $10$

$24,25$ Question $1(2$ points$)$

Page $6$:

$2930$

Page $7$:

$31$

$32$

$33$

$34$

$35$

Paop $8.$

A jewelry designer creates an excel sheet to list different items he sold on the previous day. Cells A$1,$ B$1,$ C$1,$ and D$1$ contain headings$-$Order ID$,$ Unit price, and Quantity, respectively. Cells A$2$ to A$6$ list the order ID for items sold$10001,10002,10003,10004,$ and $10005,$ respectively. Cells B$2$ to B$6$ list their respective unit price$-$ $$15,$$$18\mathrm{.}5,$$$12,$ $$9\mathrm{.}5,$ and $$6.$ Cells $C2$ to $C6$ list their respective quantities $-20,32,16,15,$ and $10.$ If he enters the formula in cell D$1$ as: $=$VLOOKUP $(10005,$ A$1$: H$3,3,$ FALSE$),$ what will the formula return?

A$)10$

B$)$ $$6$

C$)$ $$12$

D$)10003$