Assessment Description: Please see the attachment file below. Thank you

Page 1 of 1 Excel Module 3 Assignment (15 points possible, -1 or -2 each error/omission) Step Instructions 1 Start Excel. Download and open the file named Excel_ Mod 3_Ass ignment _Medical.xlsx . Save the file as Excel_Mod3_Assignment_Medical_YourLastName . 2 On the Top 4 worksheet, we will start by creating a 2D column chart for the range A6:C10. Select A6:C10 then insert a column chart. Move the chart so the top left is in A16. Cut and paste or move manually. On the chart format ribbon set the height of the chart to 3.5” and width to 5.7” . Change the chart title to Medical Job Grow th. Format the chart title to an orange color of your choice, bold and 1 6 pt. 3 Next we will c reate a pie chart , again using the same Top 4 worksheet. Yo u can choose the style of Pie chart . This time, s elect the title of the jobs ( A7:A10) and the values representing # of new jobs in Job Growth (D7:D10). To select both rows, since they are not next to each other, use the Ctrl key. Select A7:A10 then hold down CT RL and then select D7:D10 . Insert a pie chart with the style of your choice. Using t he Move Chart feature to place the Pie Chart on a new sheet ; rename the worksheet to Medical Jobs 2026. Change the chart title to New Medical Jobs by 2026 . Format the chart title to a blue text color of your choice, bold and 1 6 pt. On the chart design ribbon, chose Quick Layout 1 to add the job name and percent of jobs to each piece of pie. 4 Next, using the New Jobs sheet you will create a sparklines chart. Select the range B 5:F9 and insert column sparklines in the range G 5:G9 . 5 Th rowback! On the Doctor worksheet, type the word Total in cell E1 and then using the Sum function find a total for each of the doctor’s patients from for 2021 2022 and 2023. Using format painter, or another method of your choice, make sure the font and size of the new values is the same as the other values on the worksheet and that the Heading Total matches formatting of the other headings. Widen columns as necessary so all data is visible. Put a comma format on the values with no decimal places showing. 7 Save and close the file. Submit in Blackboard.