MIS 180. SIMNET EXCEL WORK. Chapter One.

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

USING MICROSOFT EXCEL 2013 Independent Project 1-5 (Mac)

Independent Project 1-5 (Mac Version) 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. This project has been modified for use in SIMnet®.

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 Plaza 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%- Accent2 themed cell style to A4:H4.

7. Apply format changes.

a. Increase the font size of A5: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 1.73”.

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

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

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 (Mac)

11. Apply Freeze Panes to cell A5.

a. Click the Layout tab.

b. Select A5.

c. Click Keep a portion of the sheet visible while

the rest of the sheet scrolls button, in the

Window group, and select Freeze Panes.

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

tab using the Accent 1, Darker 50% color.

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

using the 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 File, Page Setup menu, 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

1-107 Excel 1-5 (Mac) completed

Adding custom Footer using Page Setup menu