--:-- --
↓ 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`).