Скачать или смотреть Illustrated Excel 2019 | Module 1 End of Module Project 2 | Trusthaven Insurance

If you reaIly want to get the project from us then contact us on our Whatsapp. Link is given below,

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

Project Steps:
1. "Tasha Sallah is an insurance agent for Trusthaven Insurance in Hartford, Connecticut. She is developing a worksheet to track her sales of life insurance and related commissions. She has asked you for help in completing the worksheet.
Go to the Life Insurance Sales worksheet. Use AutoFill to fill the range C6:D6 based on the value in cell B6."
AutoFill values in a range.
2. In cell E7, enter a formula that uses the SUM function to total the range B7:D7 to calculate the total sales for Term life insurance. Use the Fill Handle to fill the range E8:E12 with the formula in cell E7 to find the total sales for each type of life insurance.
Create a formula using a function.
Copy a formula into a range.
3. Tasha receives 40 percent of sales as a commission. In cell F7, enter a formula that multiplies the value in cell E7 by the value in cell F4 to calculate the 40 percent commission for Term life insurance. Use an absolute reference to cell F4 in the formula. Fill the range F8:F12 with the formula in cell F7 to find the total commission for each type of life insurance.
Create a formula without a function.
Copy a formula into a range.
4. Tasha wants to calculate statistics on her life insurance sales in Quarter 1. In cell B16, enter a formula that uses the AVERAGE function to average the values in the range B7:D12 to determine the average monthly sale for all types of policies.
Create a formula using a function.
5. In cell B17, enter a formula that uses the MAX function to find the maximum value in the range B7:D12 to determine the highest accumulated sales in Quarter 1.
Create a formula using a function.
6. In cell B18, enter a formula that uses the MIN function to find the minimum value in the range B7:D12 to determine the lowest accumulated sales in Quarter 1.
Create a formula using a function.
7. Tasha wants to quickly identify the policy type that generated the most sales in Quarter 1, which was the term policy type. Copy cell A7 and then paste only the value in cell C17.
Copy and paste a value.
In the Life Insurance Sales worksheet, the formatting from cell A7 should not be copied to cell C17.
8. Cut the formula in cell F14 and paste it in cell B19 to move the formula and the cell formatting.
Cut and Paste a formula.
9. Change the orientation of the worksheet to Portrait, and insert a page break above row 20 so that the information fits on a single 8.5-by-11-inch page.
Change the orientation of a worksheet.
Insert a page break in the worksheet.