read attachments and follow directions please

HS115 | Software Applications for Health Care Professionals

1

Assignment Instructions

Unit 9 Final Project, Part 2 of 3: Excel: MediSky – Monthly Budget

Unit outcome(s) addressed in this Assignment:

 Correctly demonstrate basic skills in Excel.

Course outcome(s) addressed in this Assignment:

HS115-2: Create spreadsheets, graphs, and charts using spreadsheet applications.

HS115-4: Manage data and documents by integrating appropriate programs.

HS115-5: Demonstrate how these programs are used by healthcare professionals and in a

healthcare environment.

Instructions:

In this exercise, you work for a small accounting company that has worked with MediSky

for years on their organization’s finances.

In preparation for the acquisition, the MediSky executives have asked to create a budget

spreadsheet to help explain their monthly expenses.

Create this spreadsheet, tracking MediSky’s monthly budget. The red borders indicate

cells in which you should enter formulas.

When complete, please submit your work file(s) to the Dropbox. Be sure to Upload ALL of

your Assignment files.

Use the proper naming convention: Unit 9-MediSky Budget-Student Last Name.

To view your graded work, come back to the Dropbox or go to the Gradebook after your

instructor has evaluated it.

Make sure that you save a copy of your submitted project.

Your work is due by the end of Unit 9.

HS115 | Software Applications for Health Care Professionals

2

Unit 9 Assignment 2 of 3 Requirements Points

possible

Points

earned by

student

Enter text into spreadsheet as shown 3

Create Total formula in F6:F12 4

Create Total formula in B12:E12 3

Create Average formula in G6:G11 3

Create Average formula in B14:E14 2

Create Maximum formula in H6:H11 3

Create Maximum formula in B15:E15 2

Create Minimum formula in I6:I11 3

Create Minimum formula in B16:E16 2

25 pts.

Points deducted for spelling, grammar,

and/or APA errors. (See Writing

Deductions Rubric in Doc Sharing)

Adjusted total points

Instructor Feedback: