MIS 180 SIMNET ASSIGNMENTS

Excel 2013 Chapter 1 Creating and Editing Workbooks Last Updated: 2/5/15 Page 1

USING MICROSOFT EXCEL 2013 Independent Project 1-5

Independent Project 1-5 Clemenson Imaging is a privately owned organization that employs certified staff to perform mobile medical imaging at many hospitals statewide. You have been hired as the scheduling dispatch coordinator. It is your job to schedule all the mobile technicians at various hospital locations every day. Your supervisor has requested that you convert your schedule to an Excel spreadsheet.

Skills Covered in This Project  Open and save a workbook.

 Enter and format text and numbers.

 Merge and center title and subtitle.

 Spell check.

 Add a border.

 Apply a theme and Cell Styles.

 Create a formula using AutoSum.

 Adjust column width and row height.

 Rename and apply color to sheet tabs.

 Apply Freeze Panes.

 Apply page layout options.

1. Open the ClemensonImaging-1.xlsx start file. The file will be renamed automatically to include your

name. Change the project file name if directed to do so by your instructor, and save it.

NOTE: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at

the top of the workbook so you can modify it.

2. Apply the Ion Boardroom theme to the worksheet.

3. Edit the title in A1 so that “LLC” appears after the word “Imaging” and appears as Clemenson

Imaging LLC.

4. Merge and center the title in cell A1 across the cell range A1:H1 and the subtitle in cell A2 across the

cell range A2:H2.

5. Edit the value in cell E7 to 3.

6. Apply Cell Styles.

a. Apply the Title style to A1.

b. Apply the Heading 1 style to the subtitle in A2.

c. Apply the 40%- Accent 2 themed cell style to A4:H4.

7. Apply format changes.

a. Increase the font size of A4:H11 to 12 pt.

b. Increase the indent of cells A5:A11 once.

8. Add the title Total in cell A13 and calculate the total number of patients in E13 using AutoSum. Edit

the formula cell range to E5:E11.

9. Apply additional formatting to the spreadsheet.

a. Apply the Total Cell style to A13:H13.

b. Increase the font size to 14 pt. in cells A13:H13.

c. Select A13 and Decrease Indent once.

d. Bold and center the data in E5:E13 and H5:H11.

e. Apply bold format to cells A4:H4.

10. Adjust column widths and row heights.

a. Change the width in column A to 20.0.

b. AutoFit the remaining columns (B:H).

c. Change the row height for rows 4 and 13 to 21.00.

d. Delete row 12.

Important: Be sure to complete instruction 10. d. before moving on to the next step. Check your work

carefully.

Step 1

Download start file

Excel 2013 Chapter 1 Creating and Editing Workbooks Last Updated: 2/5/15 Page 2

USING MICROSOFT EXCEL 2013 Independent Project 1-5

11. Apply Freeze Panes to cell A5.

a. Click the View tab.

b. Select A5.

c. Click Freeze Panes and select Freeze Panes.

12. Rename Sheet1 as 12-1-2015 and color the sheet

tab using the Plum, Accent 1, Darker 50% color.

13. Select A4:H4 and apply a thick bottom border

using the Plum, Accent 1, Darker 50% color.

14. Spell check the worksheet.

15. Apply page layout options.

a. Change the orientation to Landscape and fit

the spreadsheet to one page.

b. Center the worksheet horizontally on

the page.

c. Add the automatic footer 12-1-2015 to the

worksheet using the Footer drop-down.

Important: Since Freeze Panes were set in step 11, to add the automatic footer 12-1-2015, you

must use the Page Setup dialog, Header/Footer tab.

16. Preview the spreadsheet.

17. Save and close the workbook (Figure 1-107).

18. Upload and save your project file.

19. Submit project for grading.

Step 2

Upload & Save

Step 3

Grade my Project

Adding a Footer/Header using the

Page Setup dialog.

1-107 Excel 1-5 completed