1. Enter the following data in the cells C3:C7: Research, 39577.68 , 87654.3 , 94545.87 39577.68,87654.3,94545.87, and 15225.5. (Yes, you do need to type it into the worksheet) 2. Use the Sum button and fill handle to calculate values for cells in the ranges H 4 : H 7 H4:H7 and B 8 : H 8 B8:H8. 3. Apply the Heading 1 cell style to A1. 4. Merge and Center cell A1 across cells A1:H1 5. Apply accounting number format to cell ranges B 4 : H 4 B4:H4 and B 8 : H 8 B8:H8. 6. Apply the comma style to cells in the range B 5 : H 7 B5:H7. 7. Apply the Total Style to all entries in row 8. 8. Change the sheet tab name to your last name. 9. Adjust column widths so that all cell entries are visible. 10. Create a Clustered Column chart based on the non-adjacent ranges A4:A7 and H4:H7. 11. Change the title of this chart to Expenses. 12. Move the chart below the table, put the top left corner in Cell A10. 13. Save the file. Click on the Lesson 2A Exercise link above, attach the completed file, and click the Submit button. 14. Download the file that you uploaded to make sure it is the correct file.
