2) Download the Excel data file. (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 requirements on the data file using the video or pdf's. 4) Check your work in the Excel file with these check figures. 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 . B) If you do not have Office 365 , click here to learn how to get it for free. C) Information on data column headings. D) Information on data table descriptions. E) Troubleshooting FAQ. 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 Assure Insurance, what was the contribution margin of the home insurance policy sold by Doug on 5/14/2017 ? A. $357.49 B. $452.52 C. $95.03 D. $345.49 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the average of the contribution margin for home insurance sales? A. $342.15 B. $6,294,115,25 C. $8,167,762.37 D. $492.30 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? A. $1,873,647,12 B. $4,369,21326 C. $6,155,297,36 D. $1,834,903,23 Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest instructor Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest contribution margin ratio? A. Lile B. Aulo C. Home D. Protessional E. Disability Using the pivot table you created for Requirement 5 in Assure Insurance, what Using the pivot table you created for Requirement 5 in Assure Insurance, what state had the highest sum of contribution margin? A. New Mexico B. Illinois C. Virginia D. Pennsylvania Using the pivot table you created for Requirement 6 in Assure Insurance, what was the sum of the contribution margin ratio for the South reaion? Using the pivot table you created for Requirement 6 in Assure Insurance, what was the sum of the contribution margin ratio for the South region? A. 71.62% B. 7116% C. 70.69% D. 70.96% AssureInsurance_Data_MA_Alt3_Problem.xlsx File Edit Insert Format Help fx Variable Cost Percentage Data Dictionary Data dictionary for main data set - Region: This field contains the region in which the insurance was sold. There are four regions. - State: This field contains the state in which the insurance policy applies. The data is from sales to the 48 states in continental US and the District of Columbia. (KAT Insurance does not offer insurance in the states of Alaska and Hawaii.) - Salesperson: This field contains the name of the salesperson who sold the policy. - Insurance Type: This field contains the type of insurance policy. - Sales: This field contains the selling price of the insurance policy. - Date of Sale: This field contains the date that the policy was sold. - Invoice No: This field contains the invoice number. - State Type: This field is a combination of the State and Insurance Type fields. Data Table Descriptions Separate data table for variable cost percentages - State Type: This field is a combination of the State and Insurance Type fields. - Variable Cost Percent: This field contains the variable cost percentage of each policy. Question: I need help with doing XYZ in Excel. How can I get help? Answer: Search the help system that is built into Excel. Alternatively, use a Search engine to find additional information. It is helpful if using a search engine to put "office 365 excel" in your query in addition to the item you are searchina for. Figure 1Windows help Using the pivot table you created lor Requirement 2 in Assure Insurance, what was the contribution margin of the home insurance policy 50 d by Doug on 5/14/20177 A. $35749 B. $45252 C. $9503 D. $345.49 Using the pivot table you created lor Requirement 3 in Assure Insurance, whal was tho averago of the cantribution margin for home insurance sales? Using the pivot table you created for Requirement 3 in Assure Insurance, what was the average of the contribution margin for home insurance sales? A. $342.15 B. $6,294,115.25 C. $8,167,762.37 D. $492.30 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? Using the pivot table you created for Requrement 3 in Assure Ineurance, what was the sum of varable cont for disabitity inturance saies? A. $1,873,64712 B. $4,369,21326 C. $6,155,297,36 D. $1,834,90323 Using the pivot table you created for Requiement 4 in Assure Insurance, which inturance type had the lowest contribution margn ato? Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest contribution margin ratio? A. Life B. Auto C. Home 2) Download the Excel data file. (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 requirements on the data file using the video or pdf's. 4) Check your work in the Excel file with these check figures. 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 . B) If you do not have Office 365 , click here to learn how to get it for free. C) Information on data column headings. D) Information on data table descriptions. E) Troubleshooting FAQ. 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 Assure Insurance, what was the contribution margin of the home insurance policy sold by Doug on 5/14/2017 ? A. $357.49 B. $452.52 C. $95.03 D. $345.49 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the average of the contribution margin for home insurance sales? A. $342.15 B. $6,294,115,25 C. $8,167,762.37 D. $492.30 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? A. $1,873,647,12 B. $4,369,21326 C. $6,155,297,36 D. $1,834,903,23 Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest instructor Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest contribution margin ratio? A. Lile B. Aulo C. Home D. Protessional E. Disability Using the pivot table you created for Requirement 5 in Assure Insurance, what Using the pivot table you created for Requirement 5 in Assure Insurance, what state had the highest sum of contribution margin? A. New Mexico B. Illinois C. Virginia D. Pennsylvania Using the pivot table you created for Requirement 6 in Assure Insurance, what was the sum of the contribution margin ratio for the South reaion? Using the pivot table you created for Requirement 6 in Assure Insurance, what was the sum of the contribution margin ratio for the South region? A. 71.62% B. 7116% C. 70.69% D. 70.96% AssureInsurance_Data_MA_Alt3_Problem.xlsx File Edit Insert Format Help fx Variable Cost Percentage Data Dictionary Data dictionary for main data set - Region: This field contains the region in which the insurance was sold. There are four regions. - State: This field contains the state in which the insurance policy applies. The data is from sales to the 48 states in continental US and the District of Columbia. (KAT Insurance does not offer insurance in the states of Alaska and Hawaii.) - Salesperson: This field contains the name of the salesperson who sold the policy. - Insurance Type: This field contains the type of insurance policy. - Sales: This field contains the selling price of the insurance policy. - Date of Sale: This field contains the date that the policy was sold. - Invoice No: This field contains the invoice number. - State Type: This field is a combination of the State and Insurance Type fields. Data Table Descriptions Separate data table for variable cost percentages - State Type: This field is a combination of the State and Insurance Type fields. - Variable Cost Percent: This field contains the variable cost percentage of each policy. Question: I need help with doing XYZ in Excel. How can I get help? Answer: Search the help system that is built into Excel. Alternatively, use a Search engine to find additional information. It is helpful if using a search engine to put "office 365 excel" in your query in addition to the item you are searchina for. Figure 1Windows help Using the pivot table you created lor Requirement 2 in Assure Insurance, what was the contribution margin of the home insurance policy 50 d by Doug on 5/14/20177 A. $35749 B. $45252 C. $9503 D. $345.49 Using the pivot table you created lor Requirement 3 in Assure Insurance, whal was tho averago of the cantribution margin for home insurance sales? Using the pivot table you created for Requirement 3 in Assure Insurance, what was the average of the contribution margin for home insurance sales? A. $342.15 B. $6,294,115.25 C. $8,167,762.37 D. $492.30 Using the pivot table you created for Requirement 3 in Assure Insurance, what was the sum of variable cost for disability insurance sales? Using the pivot table you created for Requrement 3 in Assure Ineurance, what was the sum of varable cont for disabitity inturance saies? A. $1,873,64712 B. $4,369,21326 C. $6,155,297,36 D. $1,834,90323 Using the pivot table you created for Requiement 4 in Assure Insurance, which inturance type had the lowest contribution margn ato? Using the pivot table you created for Requirement 4 in Assure Insurance, which insurance type had the lowest contribution margin ratio? A. Life B. Auto C. Home