Illustrated Excel 365 | Module 1: End of Module Project 2 Crestwood Insurance

Описание: If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.
Illustrated Excel 365 | Module 1: End of Module Project 2 Crestwood Insurance

PROJECT STEPS

Amelia Westerly is an insurance agent for Crestwood Insurance in West Covina, California. She is developing a worksheet to track her insurance sales and related commissions. She has asked you for help in completing the worksheet.
Go to the Insurance Sales worksheet. Use AutoFill to fill the range C5:D5 based on the value in cell B5.

In cell E6, enter a formula that uses the SUM function to total the range B6:D6 to calculate the total sales for automobile insurance. Use the Fill Handle to fill the range E7:E10 with the formula in cell E6 to find the total sales for each type of insurance.

Amelia receives 20 percent of sales as a commission. In cell F6, enter a formula that multiplies the value in cell E6 by the value in cell F4 to calculate the 20 percent commission for automobile insurance. Use an absolute reference to cell F4 in the formula. Fill the range F7:F10 with the formula in cell F6 to find the total commission for each type of insurance.

Amelia also wants to calculate statistics on her insurance sales in Quarter 1. In cell B14, enter a formula that uses the AVERAGE function to average the values in the range B11:D11 to determine the average monthly sale for all types of policies.

In cell B15, enter a formula that uses the MAX function to find the maximum value in the range B11:D11 to determine the highest accumulated sales in Quarter 1.

In cell B16, enter a formula that uses the MIN function to find the minimum value in the range B11:D11 to determine the lowest accumulated sales in Quarter 1.

Amelia has identified the Automobile policy type as the policy type that generated the most sales. Copy cell A6 and then paste only the value in cell C15.

Cut the formula in cell F12 and paste it in cell B17 to move the formula and the cell formatting.

#samprojects #cengageassignments #IL_EX365_EOM1-2 #IL_EXCEL #excel_assignments #excel_sam_projects #Module1EndOfModuleProject2 #crestwood_insurance #illustrated_excel #IL_EX365_EOM1-2_FirstLastName_1.xlsx #IL_EX365_EOM1-2_FirstLastName_2.xlsx