Question $1$

$\frac{0}{4}pts$

Please copy and paste the VLOOKUP formula for the cells listed below.

Cell

Formula

E$34$

E$205$

$=$vlookup$($E$4,$A$4$:B$1\text{'}$

Answer $1$:

$=$vlookup$($E$4,$A$4$:B$199,$FALSE$)$

Answer $2$:

$=$vlookup$($E$4,$A$4$:B$199,$FALSE$)$

Question $2$

$\frac{4}{4}$ pts

Using your Pivot Table from Part #$1,$ fill out the chart below.

Month$/$Customer$\_$Sum$\_$of Sales

$2/4/2024$