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 sorted Excel sheet you created for Requirement $2$ in ELAN Insurance, what was the sum of sales in Delaware?

A$.$ $$974,619\mathrm{.}87$

B$.$ $$963,429\mathrm{.}86$

C$.$ $$970,191\mathrm{.}86$

D$.$ $$947,618\mathrm{.}49$

Using the pivot table you created for Requirement $3$ in ELAN Insurance, what was the average amount of sales in Tennessee?

A$.$ $$637\mathrm{.}37$

B$.$ $$636\mathrm{.}74$

C$.$ $$632\mathrm{.}11$

D$.$ $$635\mathrm{.}40$

Using the pivot table you created for Requirement $4$ in ELAN Insurance, what was the sum of sales in the New England region?

A$.$ $$6,759,005\mathrm{.}45$

B$.$ $$8,722,434\mathrm{.}93$

C$.$ $$4,789,926\mathrm{.}96$

D$.$ $$7,527,744\mathrm{.}88$

Using the pivot table you created for Requirement $5$ in ELAN Insurance, what was the sum of sales in the West region by Eliska?

A$.$ $$3,301,334\mathrm{.}53$

B$.$ $$3,495,879\mathrm{.}53$

C$.$ $$2,352,998\mathrm{.}90$

D$.$ $$3,263,125\mathrm{.}92$

Using the pivot table you created for Requirement $6$ in ELAN Insurance, what was the sum of home insurance sales in the North Central region?

A$.$ $$864,407\mathrm{.}60$

B$.$ $$1,295,349\mathrm{.}90$

C$.$ $$8,026,667\mathrm{.}26$

D$.$ $$867,863\mathrm{.}61$

Using the map chart you created for Requirement $7$ in ELAN Insurance, what is the minimum value of sales in any state?

A$.$ $$50\mathrm{.}21$

B$.$ $$47\mathrm{.}91$

C$.$ $$50\mathrm{.}24$

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