Excel Basic Exercise 4 Enrollments in the College of Business
  1. Open the workbook called
  2. Use the Save As command to save the workbook as Enrollment.xls
  3. Complete the workbook by performing these tasks
  4. Enter the title "Enrollment Data for College of Business"
  5. Enter the label "Total" in cell A8
  6. Calculate the total enrollment for 2006 in cell B8
  7. Calculate the total enrollment for 2005 in cell C8
  8. Calculate the change in enrollments from 2005 to 2006 and place the results in Column D. Label the column heading "Change" and use the following formula Change=2006 Enrollment - 2005 Enrollment
  9. Save and print the worksheet.