Assignment IL Excel2013 UA P1a 1 
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
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
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
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