Microsoft Excel – Lesson 6

/ Excel, Excel Resources, Office / By

Activity Overview

Exce; is perfect for tracking employee time sheets.

New Skill

In this activity, you will practice how to:

  1. Add cell shading and borders.
  2. Wrap cell text.
  3. Format numbers to display currency and commas.
  4. Insert cell comments.

Lesson

  1. Open the TIME SHEETS.xls file.
  2. Select the range A1:H1. Merge and Center across the selection.
    Select the range A3:H3. Merge and Center across the selection.
  3. Select A1:H3 and add a Red Fill Color, Bold, change Font Size to 16, and Font Color to White.
  4. Select the range A6:H6 and change the Font Size to 12, Bold, Italic, Center, and Wrap the Text.
  5. Select the range B7:B13 and format as numbers displaying 2 decimal places.
  6. Select the range F7:H13 and click the Comma Style button.
  7. Click in cell H7 and click the AutoSum button. Drag to select F7:G7 so that the formula indicates =SUM(F7:G7) and press Enter. AutoFill the formula down through cell H13.
  8. Click in cell H14. Click the AutoSum button to add the numbers in cells H7:H13.
  9. Click in cell H14 and click the Currency Style button.
  10. Select the range C7:E13 and Center the selected text. Click in cell G14 and type Total Payroll.
  11. Select the range G14:H14 and add a Red Fill Color, Bold, Italic, and White Font Color.
  12. Select the range A6:H13. Apply an Outline and Inside Preset Border.
  13. Select the range A1:H14. Change the border to a Thick Black Border and select Outline.
  14. Click in cell D6 and Insert a Comment. In the comment box, type Overtime paid at 1.5 times hourly rate and change the inserted name GV/WFL Edutech to your name.
  15. Change Page Setup as follows:
    a. Center Horizontally and Vertically.
    b. Change the Footer margin to 1”.
    c. Insert a Custom Header using Left Section – your name Right Section – Time Sheet
    d. Insert a Custom Footer. Press Tab twice to position the insertion point in the Right section. On the Footer toolbar, click the Date button, and then click OK.
    e. Change Orientation to Landscape. Under Scaling, adjust the worksheet to 90% of its normal size.
  16. Print Preview your spreadsheet to view your header/footer and make sure it fits on one page.
  17. Save your document.
  18. Optional: Print a copy for review.
Scroll to Top