Excel 2019 Module 4: End of Module Project 2 | Tetra Sammander Insurance #shellycashman

Excel 2019 Module 4: End of Module Project 2 | Tetra Sammander Insurance #shellycashman

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/4B6NMKKBKUFYN1?autoload=1&app_absent=0

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
singhal.agrawal.bharati@gmail.com

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.

PROJECT STEPS
1. Geneva Wood is the owner of Tetra Sammander Insurance. Geneva is preparing year-end financial data to summarize and visualize the company's position and modeling costs of a new life insurance product that the company is considering offering. She has created charts to illustrate some of her data and is using functions to calculate the future value of insurance policies.
Switch to the Revenues worksheet. In the range F6:F10, add line sparklines based on the data in the range B6:E10 and then add markers. Apply the Green, Accent 6 sparkline color and the Green, Accent 6, Darker 25% marker color.
2. Apply a Gradient Fill, Green Data Bar conditional formatting rule into the range G6:G10.
3. Geneva wants a clustered column chart representing the total revenue for each insurance type by year. Create a 2-D clustered column chart based on the range A5:E9. Resize and reposition the chart so that the upper-left corner is located within cell H5 and the lower-right corner is located within cell O24. Enter Yearly Revenues by Insurance Type as the chart title, then bold the title, and change the font size to 16 point.
4. Apply a Green, Accent 6 border to the plot area of the chart and change the width of the border to 1.5 point. Apply a Glow Shape Effect to the chart area using 5 point Green, Accent Color 6.
5. In the 2021 Revenues by Insurance Type 3-D pie chart (in the range H26:O43), change the legend position to bottom. Add data labels that contain only percentages (not values) and that use the Center position.
6. In the Total Revenues by Year 2018-2021 line chart (in the range A11:G28), change the minimum bound of the vertical axis to 2500000, change the major units of the vertical axis to 500000 change the minor units to 250000, and then add Inside tick marks for the minor units on the vertical axis.
7. Apply a solid fill using the Orange, Accent 2, Lighter 80% fill color to the chart area. Apply the Green, Accent 6, Darker 50% font color to the chart title, and change the font to 16 point bold. Apply the Green, Accent 6 color to the data line, and change the width to 2.25 point.
8. In the Insurance Type Contribution to Annual Revenue 2018-2021 stacked column chart (in the range A29:G46), remove the data series labeled Trends from the chart. Apply a Shape Fill to the chart area using the Orange, Accent 2, Lighter 80% fill color. Apply a Solid Line border to the chart area with a White, Background 1, Darker 35% border color.
9. Create a 2-D Column chart based on the range A5:E10. Move the 2-D Column chart to the Revenue Summary worksheet, and then resize and reposition the chart so the upper-left corner is located within cell A5 and the lower-right corner is located within cell K22. Select Switch Row/Column to edit the chart data source. Change the chart type to create a Custom Combination Combo chart. Represent the following data series as a Clustered Column chart: Life, Homeowners, Auto, and Travel, and represent the Total data series as a Line chart using the Secondary Axis. [Mac hint - Keep the main chart a Clustered Column chart, select the Total data series, change the chart type to a Line chart, and plot the series on the Secondary Axis.]
10. Enter Policy Type and Total Yearly Revenue as the chart title. Add axis titles to the chart, enter Revenue by Policy Type as the left vertical axis title, and then enter Total Revenue as the right vertical axis title. [Mac hint - Add Primary Vertical and Secondary Vertical Axis titles.] Delete the horizontal axis title placeholder, if necessary.
11. Switch to the Payments worksheet, select the range A6:B156 and create a Histogram chart. Resize and reposition the chart so that the upper-left corner is located within cell D5 and the lower-right corner is located within cell N23.
12. For the horizontal axis, change the bin width to 250, add an overflow bin with a value of 1500, and change the number format to the Currency number format with decimal places to 0. Enter Distribution of Payout Amount per Policy in 2021 as the title of the chart, and format the chart title using bold.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Видео Excel 2019 Module 4: End of Module Project 2 | Tetra Sammander Insurance #shellycashman канала Homework Help