Personal Budget Excel Guide

Name:

Date:

📚 Part 1: Drag-and-Drop Matching — Excel Functions and Cell References

Match the Excel function or cell reference:

SUM()

$A$1

1. Adds a range of cells quickly

2. Absolute cell reference

3. Relative cell reference

4. Which function adds a range of cells quickly?

SUM()

ADD()

TOTAL()

Use this example to create your budget:

Income: Salary — $4,000; Freelance — $500

Expenses: Rent — $1,600; Groceries — $400

Steps to create your budget in Excel:

1. List your income sources in column A and amounts in column B.

2. Below your income, write "Total Income" and use the formula: =SUM(B2:B3).

3. Below your expenses, write "Total Expenses" and use the formula: =SUM(B5:B6).

5. Fill in the table below with your income and expenses:

6. Scenario: If your Total Income is in B4 and Total Expenses in B7, how do you calculate your Balance?