Hands-On Exercises

Download as a Word document: Hands-On Exercises Ch03 (7.0K)

In this exercise you will enhance a worksheet to be displayed in the Marina office for the rental rates of its craft. You will apply font size, typeface, Bold, Italics, Borders and Shading to prepare an attractive flyer.

1. Open the data file "EX03HE-SSM."
2. Save the file as "Flyer" to your personal storage location.
3. To begin, lets adjust the heading labels in row 1 and 2, by:
   CLICK: Cell A1
   CLICK: [Font Size]
   CHOOSE: 24
   CLICK: [Bold]
   CLICK: [Italic]
   SELECT: the Range A1 to G1
   CLICK: Merge and Center
   Do the same on row two, except the size should be 18, and no italics.
4. To really enhance the heading:
   SELECT: Cell range A1 to G2
   CLICK: Fill Color, choose Blue on row 2 column 6
   CLICK: Font Color, Choose yellow, row 4, column 3
   CLICK: Outside selection to deselect.
5. To enhance the labels in Row 4:
   SELECT: the range A4 to G4
   CLICK: the Font drop down,
   CHOOSE: Comic Sans MS (if you don’t have this font, choose another "fun" font)
   CLICK: Font Size
   CHOOSE: 14
6. To format the numbers:
   SELECT: the cell range C5 to G11
   CLICK: [Comma Style]
7. To adjust the column widths:
   SELECT: The cell range A5 to G11
   PRESS: [Alt], o, c, a
8. To adjust the print Layout:
   CLICK: File, Page setup
   CLICK: Landscape orientation
   CLICK: the Margins tab selector
   CLICK: Check both check boxes for Center on page
   CLICK: [Preview]
9. If you have a printer attached, print the sheet now, otherwise, close the print preview, save the changes, and close the workbook.

Data File: EX03HE_SSM (13.0K)

In this exercise you format numbers and text, add shading, color, and borders, then publish the page to the companies intranet. To begin:

1. Open the file EX03HE-FPI.
2. Save the file as "Commission" to your personal storage location.
3. Enhance the title by choosing a different typeface, size and style.
4. Add a subtitle in row two, "For the Month of June" and apply font changes to enhance the visual appeal.
5. Select the range, A3 to D7, and then choose Format, AutoFormat. Pick an AutoFormat which you think is attractive.
6. Increase the Height of row three such that it is at least twice as big. This will give some visual separation between the title and the data.
7. Merge and Center the title and subtitle between column A and D. Be sure that you do each row separately.
8. Save the File.
9. Save the File as a web page, to your personal storage location. Preview the web page.
10. Close the web page, workbook, and exit from Excel.

Data File: EX03HE_FPI (13.0K)