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.