excel projectt
adrian77
assignment_il_excel2013_ua_p1a1.docx
Illustrated Excel 2013| Unit A: SAM Project 1a
Illustrated Excel 2013
Unit A: SAM Project 1a
Northwest Hospital
create an analysis table
M Project Name
PROJECT DESCRIPTION
Busra Kayi is an administrative assistant at Northwest Hospital in Istanbul, Turkey. She has begun work on an Excel worksheet summarizing hospital admission statistics over the past 4 years, and she’d like your help enhancing the worksheet so it can be presented to the hospital’s key investors.
GETTING STARTED
· Download the following file from the SAM website:
· IL_Excel2013_UA_P1a_FirstLastName_1.xlsx
· Open the file you just downloaded and save it with the name:
· IL_Excel2013_UA_P1a_FirstLastName_2.xlsx
· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.
· With the file IL_Excel2013_UA_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Select the Admission Analysis worksheet and enter the text Northwest Hospital in cell A1.
2. Enter the text Admissions Analysis in cell A2.
3. Edit the text in cell A3 so that it reads Admissions 2012-2015.
4. In cell E10, enter the value 28835.
5. Use AutoFill to fill the range F6:F10 using the formula in cell F5.
6. In cell B11, enter a formula that uses the SUM function to total the range B5:B10. Use AutoFill to fill the range C11:F11 using the formula you just created in cell B11.
7. Edit the text in cell A13 so that it reads Projected Admissions 2016-2019.
8. Enter the information shown in Table 1 below into the worksheet.
Table 1 Values for range B20:E20
© 2014 Cengage Learning.
|
Cell |
Value |
|
B20 |
30277 |
|
C20 |
31791 |
|
D20 |
33380 |
|
E20 |
35049 |
9. Use AutoFill to fill the range F16:F20 using the formula in cell F15.
10. In cell B21, enter a formula that uses the SUM function to total the range B15:B20. Use AutoFill to fill the range C21:F21 with the formula you just created in cell B21.
11. Hide the gridlines for the Admission Analysis worksheet.
12. Change the orientation of the worksheet to Landscape.
13. Change the document view to Page Break Preview.
Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.
Final Figure: Admission Analysis worksheet
Microsoft product screenshots used with permission from Microsoft Corporation.
Copyright © 2014 Cengage Learning. All Rights Reserved.
|
2 |
