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 VITALITY Insurance, what was the sum of sales in Delaware? A. $1,002,353.30 B. $1,004,682.84 C. $983,044.97 D. $1,016,429.29 Using the pivot table you created for Requirement 3 in VITALITY Insurance, what was the average amount of sales in Tennessee? A. $618.75 B. $623.60 C. $617.30 D. $615.49 Resources A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free. Using the pivot table you created for Requirement 4 in VITALITY Insurance, what was the sum of sales in the Midwest region? A. $7,590,572.38 B. $9,233,130.01 C. $7,593,964.49 D. $6,876,308.20 A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free Using the pivot table you created for Requirement 5 in VITALITY Insurance, what was the sum of sales in the Southeast region by Holly? A. $2,586,531,83 B. $3,109,153.35 C. $2,549,245.76 D. $2,643,951.00 Using the pivot table you created for Requirement 6 in VITALITY Insurance, what was the sum of professional insurance sales in the New England region? A. $314,505.48 B. $1,892,383.05 C. $3,043,614.54 D. $16,781,021.90 Using the map chart you created for Requirement 7 in VITALITY Insurance, what is the minimum value of sales in any state? A. $50.59 B. $52.58 C. $51.41 D. $50.24 Check Figures PRNER BEFORE YOU EXIT If rent company and set of data.) 5. elow. (You will have to scroll dow free. B. $52.58 rance, what is the minimum value C. $51.41 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 VITALITY Insurance, what was the sum of sales in Delaware? A. $1,002,353.30 B. $1,004,682.84 C. $983,044.97 D. $1,016,429.29 Using the pivot table you created for Requirement 3 in VITALITY Insurance, what was the average amount of sales in Tennessee? A. $618.75 B. $623.60 C. $617.30 D. $615.49 Resources A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free. Using the pivot table you created for Requirement 4 in VITALITY Insurance, what was the sum of sales in the Midwest region? A. $7,590,572.38 B. $9,233,130.01 C. $7,593,964.49 D. $6,876,308.20 A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free Using the pivot table you created for Requirement 5 in VITALITY Insurance, what was the sum of sales in the Southeast region by Holly? A. $2,586,531,83 B. $3,109,153.35 C. $2,549,245.76 D. $2,643,951.00 Using the pivot table you created for Requirement 6 in VITALITY Insurance, what was the sum of professional insurance sales in the New England region? A. $314,505.48 B. $1,892,383.05 C. $3,043,614.54 D. $16,781,021.90 Using the map chart you created for Requirement 7 in VITALITY Insurance, what is the minimum value of sales in any state? A. $50.59 B. $52.58 C. $51.41 D. $50.24 Check Figures PRNER BEFORE YOU EXIT If rent company and set of data.) 5. elow. (You will have to scroll dow free. B. $52.58 rance, what is the minimum value C. $51.41