Question content area top

Part $1$

The steps you will follow for this project are as$$ follows:

$1)$ Review the videoopens in a new tab $$and$/$or the scripted$$ PDF$\text{'}$s for Windowsopens in a new tab or Macopens in a new tab.

$2)$ Download the Excel data fileopens in a new tab. $($After you download the$$ file, YOU NEED TO$$ "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your$$ assignment, the next time you$$ enter, you may see a different company and set of$$ data.$)$

$3)$ Perform the requirementsLOADING... on the data file using the video or$$ pdf$\text{'}$s$.$

$4)$ Check your work in the Excel file with these check figuresLOADING....

$5)$ Use your Excel file to answer the six multiple choice questions below. $($You will have to scroll down to see all of the$$ questions.$)$

Resources

$$A$)$ Information on how to update Excel and Office $365$LOADING....

$$B$)$ If you do not have Office$365,$ click here to learn how to get it for freeopens in a new tab.

$$C$)$ Information on data column headingsLOADING....

$$D$)$ Information on data table descriptionsLOADING....

$$E$)$ Troubleshooting FAQLOADING....

Question content area bottom

Part $1$

This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not$$ match, do not proceed with answering the questions until you have asked for assistance from your instructor.

Using the pivot table you created for Requirement $2$ in $$Insurance$,$ what was the of the insurance policy sold by on $?$

A$.$$ $452\mathrm{.}52$

B$.$$ $95\mathrm{.}03$

C$.$$ $345\mathrm{.}49$

D$.$$ $357\mathrm{.}49$

Using the pivot table you created for Requirement $3$ in $$Insurance$,$ what was the insurance$$ sales?

A$.$$ $342\mathrm{.}15$

B$.$$ $8$ comma $167$ comma $762\mathrm{.}37$

C$.$$ $6$ comma $294$ comma $115\mathrm{.}25$

D$.$$ $492\mathrm{.}30$

Using the pivot table you created for Requirement $3$ in $$Insurance$,$ what was the insurance$$ sales?

A$.$$ $4$ comma $369$ comma $213\mathrm{.}26$

B$.$$ $1$ comma $873$ comma $647\mathrm{.}12$

C$.$$ $1$ comma $834$ comma $903\mathrm{.}23$

D$.$$ $6$ comma $155$ comma $297\mathrm{.}36$

Using the pivot table you created for Requirement $4$ in $$Insurance$,$ which insurance type had the contribution margin$$ ratio?

A$.$Auto

B$.$

Home

C$.$

Disability

D$.$Life

E$.$

Professional

Using the pivot table you created for Requirement $5$ in $$Insurance$,$ what $$