Improving Worksheet Appearance Project 3 Objectives

1
Improving Worksheet AppearanceProject 3
Objectives

• Formatting Numbers (Lesson 1)
• Aligning Cell Contents (Lesson 2)
• Changing Font and Font Size (Lesson 3)
• Applying Bold, Italic, and Underline (Lesson 4)
• Adding Color (Lesson 5)
• Adding Borders (Lesson 6)
• Using Format Painter (Lesson 7)
• Removing Formatting (Lesson 8)
• Conditional Formatting (not in Text)

Slide 3-1
2
Key Terms for Modifying Data
pattern
border
typeface
point
format
font
Slide 3-2
3
Formatting Samples
Good Example
Not a Good Example
Slide 3-3
4
Common Number Formats
Slide 3-4
5
Center Versus Merge and Center
Centering aligns data within its own cell. Great
for column headings.
Merge and Center allows centering across a
selection of cells. Great for titles on a
worksheet.
Slide 3-5
6
Font Usage

• Serif Fonts
• (with shoulders)
• Times New Roman
• Courier New
• Baskerville
• Georgia

• Sans Serif Fonts
• (without shoulders)
• Arial
• Comic Sans
• Tahoma
• Swiss 721

Slide 3-6
7
The Format Painter
Format to Copy
Text to copy format to
Slide 3-7
8
Sample Exam Question
Available Only in Lecture