In cell E14, create a formula using the SUM function to calculate Kelly’s total expenses over the last three quarters ( B14:D14 ). 11. Update the formatting of the merged range A16:D16 as described below: a. Bold the contents of the merged range. b. Change the font to Calibri . c. Change the font size to 13 pt . d. Change the font color to Green, Accent 6, Darker 25% (10 th column, 5 th row of the Theme Colors palette). 12. Kelly was offered another job recently. She has a strong passion for teaching, but she also wants to make a wise financial decision. She will continue tutoring only if she sees that her profit has increased every quarter. In cell B18, create a formula without using a function that calculates the total profit earned by subtracting the total expenses in Q1 (cell B14 ) from the total revenue in Q1 (cell B7 ). Using the Fill Handle, fill the range C18:D18 with the formula from cell B18. 13. Change the tab color of the Job Analysis worksheet to Blue (8 th column, 1 st row of the Standard Colors palette). 14. Select the clustered column chart with the title Kelly’s Revenue. Update the chart as described below: a.
- Spring '15
- Computer file, Shelly Cashman Excel