2. Homework Assignment 9, Excel-2

• Here is your second Excel Spreadsheet Assignment.

• Students who are NOT in health care should do this problem:

  • Computer Problem: I want you to compare the prices for 4 different computers (different vendors) you might buy. For each computer you will have a base price, 4 different additional items, warranty extension for 1 year, shipping and handling.

  • Make the title a different font, size and make it bold and italics as well. The title should be centered in a merged cell and it should have a colored background.

  • Make the column headers two words and have them wrap in the cell

  • All dollar amounts should be formatted for currency

  • Calculate the total and highlight the least expensive in one color and the second least expensive in another color.

  • If you buy over 50 systems you get a discount – different vendors offer different discounts – two give a percent off and 2 give a specific amount off each machine. Calculate the per machine price if you get a discount. Calculate the total due on 50 systems if you get the discount.

• Students who are in health care should do this problem:

  • Doctor Appointments: I want you to set up an appointment spreadsheet for a small doctors practice. There are 4 doctors that schedule 20 minute visits.

  • Make the title a different font, size and make it bold and italics as well. The title should be centered in a merged cell and it should have a colored background.

  • The columns should be for the 4 doctors and they should have the first name above the last line so they wrap in a cell.

  • Down the side should be the available times for appointments.

  • Enter the patients name and contact information in the cell.

  • Count the number of patients that each doctor saw and highlight the doctor who saw the most patients with one color and the doctor that saw the least number of patients in another color.

  • Calculate if the doctor saw this number of patients every day for a week how many patients would they see per week. If the cost of a visit is $100, how much will each doctor bring in over the week. Making the same assumption, how much would they bring in during a 50 week year. These numbers should be formatted in currency.