CLASS OBJECTIVE
Learn how to change the appearance of cells using alignment, merging, borders, fill color, font styles, and number formats to make spreadsheets clearer, more attractive, and easier to read.
⸻
🗓 CLASS AGENDA
💬 Introduction
“Have you ever seen a messy table that’s hard to read?
Today, you’ll learn how to make your spreadsheet look professional.”
1️⃣ Short Review
Identify the main elements of a spreadsheet:
Cell
Row
Column
Data
Formula bar
2️⃣ Explanation
🎨 Cell Formatting Tools
Alignment: Left, center, right, top, middle, bottom
Merge cells: Combine two or more cells
Wrap text: Make text fit inside a cell
Borders: Add lines around cells
Fill color: Change background color of cells
✏️ Font Formatting
Font type
Font size
Bold
Italic
Underline
Text color
💰 Number Formatting
Currency ($)
Date formats
Percentage (%)
Decimal places
3️⃣ Demonstration
Teacher creates a simple table and demonstrates:
How to format the title row
How to apply borders
How to use fill color
How to apply different alignments
How to change number formats (currency, date, %, decimals)
4️⃣ Take notes in your notebook.
⸻
📓 NOTES IN YOUR NOTEBOOK
Answer these questions:
Why is formatting important in a spreadsheet?
What does “merge cells” mean?
What is the difference between text format and number format?
How can color and borders help readers understand your data?
⸻
📌 KEYWORDS
Alignment: Position of text in a cell
Merge cells: Combine multiple cells into one
Wrap text: Adjust long text to fit inside a cell
Borders: Outline around cells
Fill color: Background color
Font: Style and appearance of text
Number format: How numbers appear (currency, %, date)
Currency: Format for money
Percentage: Multiplies by 100 and adds %
⸻
🖋 HOMEWORK
- Will be published in Classroom.
- Don’t forget to write it in your agenda.