Project $1($ONLY USE ONE Workbook in Excel$)--$ VERSION $2$

Part A:

Points: Total Points thru $Q8=85=40,Q9$ thru $Q14=610=60$

Using the data file Project$1$ Ver X$,$ where X represents your version. The professor will tell you which

version to use. Perform the following operations:

Create a pivot table to answer each question listed below $(1$ thru $14)$ and place all on a

worksheet called "Answers". $($Note: You may be able to answer more than one question with

the same pivot table$).$

You MUST "background fill" $($with an appropriate color$)$ the cell$($s$)$ of the questions you are

answering. Then, you MUST also state the question number that you are answering, next to the

pivot table$($s$).$

If you do not perform $2.$ Above, you will lose $80\%$ for each question that is not background filled

in Part $A.$

Which region has the item with the highest unit cost?

Which region has the item with the lowest unit cost?

Which is the best region by total sales?

Which is the worst region by total sales?

Who is the representative with the smallest number of items?

Who is the representative with the largest number of items?

Which region contains the item with the most total sales?

Which region contains the item with the least total sales?

Which item has the highest $\%$ of total sales by region $(4$ answers$)$

Which region has the item with the lowest $\%$ of total sales?

Which representative has the highest $\%$ of total sales?

Which representative has the lowest $\%$ of total sales?

What is the best representative $($representative with the item that has the highest unit cost$)$

best product by $\%$ of total sales $($for all items that the representative sell$)?$

What is the worst representative $($representative with the item that has the lowest unit cost$)$

best product by $\%$ of total sales $($for all items that the representative sell$)?$

Save your Workbook as "Your Name $-$ Project $1".$