--:-- --
↓ Scroll for more

Unit 3.1

MS Excel Fundamentals

PRC 110: Software Skills Practicum

🎯 Learning Objectives

  • ✅ Navigate the **Excel Interface** (Rows, Columns, Cells).
  • ✅ Enter and **Format Data** (Number, Currency, Date).
  • ✅ Understand **Cell Referencing** (Relative vs. Absolute).
  • ✅ Use **Freeze Panes** and Print Titles.

📊 The Excel Interface

Key Concepts

  • **Workbook:** The file (.xlsx).
  • **Worksheet:** The tabs at the bottom.
  • **Cell Address:** Column Letter + Row Number (e.g., `A1`, `B10`).
  • **Range:** A block of cells (e.g., `A1:B10`).

Data Types

  • **Text:** Labels, Names (Left Aligned).
  • **Numbers:** Values, Heights (Right Aligned).
  • **Dates:** Specific sequence numbers.

🎨 Formatting Data

Make data readable and professional.

  • **Number Formats:** Currency ($), Percent (%), Decimal places.
  • **Conditional Formatting:** Highlight cells based on rules (e.g., "Values > 50" turn green).
  • **Freeze Panes:** Keep headers visible while scrolling (`View > Freeze Panes`).

📍 Cell Referencing

Crucial for copying formulas correctly!

Relative (A1)

Changes when you copy.

  • Copy Formula `A1+B1` down one row...
  • Becomes `A2+B2`.

Absolute ($A$1)

Locks the cell reference.

  • Copy Formula `$A$1+B1` down...
  • Becomes `$A$1+B2`.
  • Use `F4` key to toggle.

🧪 Practicum 3.1

Student Data Sheet

  1. Create a new Workbook.
  2. Create Header Row: **ID, Name, Math, Science, English**.
  3. Enter hypothetical data for 5 students.
  4. Apply **Bold** and **Fill Color** to the header.
  5. Use **Freeze Panes** to lock the header row.
  6. Create a column **"Bonus"** where you add `5` marks to Math using an **Absolute Reference** to a bonus cell (e.g., `G1`).