Microsoft Office Tutorials and References
In Depth Information
EX 108
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Plan
Ahead
Identify how to format various elements of the worksheet.
The following outlines the formatting suggested in the sketch of the worksheet in Figure 2–3
on page EX 85:
1. Workbook theme - Concourse
2. Worksheet title and subtitle
a. Alignment — center across columns A through J
b. Cell style —Title
c. Font size — title 18; subtitle 16
d. Background color (range A1:J2) — Turquoise Accent 1, Lighter 60%
e. Border — thick box border around range A1:J2
3. Column titles
a. Cell style — Heading 3
b. Alignment — center
4. Data
a. Alignment — center data in column B
b. Dates in column C — mm/dd/yy format
c. Numbers in top row (range E4:I4) — Accounting style
d. Numbers below top row (range E5:I12) — Comma style and decimal places
5. Total line
a. Cell style — Total
b. Numbers — Accounting style
6. Average, Highest, and Lowest rows
a. Font style of row titles in range A14:A16 — bold
b. Numbers — Currency style with fl oating dollar sign in the range E14:I16
7. Percentages in column J
a. Numbers — Percentage style with two decimal places; if a cell in range J4:J12 is less
than zero, then cell appears with background color of light red
8. Column widths
a. Column A — 14.11 characters
b. Columns B and C — best fi t
c. Column D — 6.00 characters
d. Column E, G, and J — 9.00 characters
e. Columns F, H, and I — 12.67 characters
9. Row heights
Colors
Knowing how people
perceive colors helps
you emphasize parts of
your worksheet. Warmer
colors (red and orange)
tend to reach toward
the reader. Cooler colors
(blue, green, and violet)
tend to pull away from
the reader. Bright colors
jump out of a dark
background and are
easiest to see. White or
yellow text on a dark
blue, green, purple, or
black background
is ideal.
a. Row 3 — 60.00 points
b. Row 14 — 26.25 points
c. Remaining rows — default
C6161_EXC_02.4c.indd 108
C6161_EXC_02.4c.indd 108
3/6/07 3:28:46 PM
3/6/07 3:28:46 PM
Search JabSto ::




Custom Search