View this video for a quick overview of how to get started with this project The steps you will follow for this project are as follows 1) Review the video and/or the scripted PDF's for Windows or Mac 2) Download the Excel data file (After you download the tie YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT you do not save your assignment, the next time you enter, you may see a different company and set of data) 3) Perform the requirements on the data fie using the video or ps 4) Check your work in the Excel file with these check ours 5) Use your Excel file to answer the six multiple choice questions below (You will have to son down to see all of the questions) A) Information on how to update Excel and Office 365 B) If you do not have Office 365, click This project only has one attempt. Review the check figures with your data before answering the questions your check figures do not match do not proceed with answering the questions you have asked for assistance from your instructor Using the sorted Excel sheet you created for Requirement 2 in ROSE Insurance, what was the sum in Delaware? OA. $988,126.29 $904,433.77 OC. $1,015,132.01 OD. $1,029,947.00 Using the pivot table you created for Requirement 3 in ROSE Insurance, what was the average amount of sales in Tennessee? OA $674.28 B. $670.34 OC. $674.18 OD. $65809 Using the pivot table you created for Requirement in ROSE Insurance, what was ses in the Northeast region? A. $6,881,684,13 OB. $7.756,049.24 OC. $9.254.170.61 OD. $4.795,909.65 Using the pivot table you created for Requirements in ROSE insurance, what was the region by Lon OA. $2.623.215.90 OB. $3.389,031.91 OC. $3.428,495.38 OD. $2.427.169.12 ses in the Southwest Using the pivot table you created for Requirement 6 in ROSE Insurance, what sales in the Central region? of professional insurance OA. $927.691.56 OB. $1.312.802.14 OC. $2,766.440.99 OD. $1.352.944.12 Using the map chart you created for Requirement 7 in ROSE Insurance, what is the minimum value of an any state? OA. $39.95 $46.74 OC. $45.57 OD. $47.91