Students learn how to improve readability and professionalism through formatting.

Learning Objectives

Students should be able to:

• Apply font, alignment, border, and fill formatting
• Format numbers as currency, percentages, dates, and time
• Adjust row heights and column widths
• Wrap and align text
• Apply consistent formatting across a worksheet

Topics

• Font styles, sizes, emphasis, and alignment
• Number, currency, accounting, percentage, and date formats
• Borders and background fills
• Text wrapping and indentation
• Row height and column width
• Format Painter
• Consistency and accessibility
• Appropriate and inappropriate use of merged cells

Guided Activity

Students format an unorganized monthly expense worksheet.

Independent Practice

Students:

• Add a title and section headings
• Apply currency formats
• Format dates consistently
• Add borders and spacing
• Adjust columns for readability

Assignment

Create and format a simple monthly expense tracker.