New Perspectives Excel 365 | Module 4: SAM Project A| Benviva Health Insurance (Full answer in 2025)

Benviva Health Insurance ANALYZE AND CHART FINANCIAL DATA GETTING STARTED • Save the file NP_EX365_4A_FirstLastName_1.xlsx as NP_EX365_4A_FirstLastName_2.xlsx Edit the file name by changing "1" to "2". If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically. • With the file NP_EX365_4A_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet. 。 PROJECT STEPS If cell B6 does not display your name, delete the file and download a new copy. 1. Arjun Banerjee is a sales manager for Benviva Health Insurance in Wichita, Kansas. He is compiling sales and advertising data for the Marketing Department and wants to use Excel to create charts to illustrate the data and emphasize trends. Go to the Employer Plans worksheet. This worksheet shows the number of health insurance plans sold by quarter according to plan type. Arjun wants to compare the number of plans sold in Quarter 4. In the range F5:F9, add Conditional Formatting to show Gradient Fill Blue Data Bars. 2. Arjun also wants to provide a general impression of the annual trend for each plan type and for the total plans sold. In the range G5:G10, add Line sparklines based on the data in the range C5:F10. 3. Format the sparklines as follows to make them more prominent: a. Apply the Blue-Gray, Accent 6, Darker 50% (10th column, 6th row in the Theme Colors palette) sparkline color to the range G5:G10. b. Show the High Point and Low Point data markers.

#MicrosoftExcel
#Excel
#NewPerspectivesExcel
#SAMProject