Excel Formula Programming
Free to teach as-is — the teacher guide, student handout, and slides are included.
Free — we'll email you an access link. Google Docs format.
Objective
I can write basic Excel formulas using cell references and mathematical operators (+, -, *, /).
Part 1 of 3
Warm-up video
Unknown Channel · 5:00
We don't generate video — this one is by Unknown Channel on YouTube. The practice questions and exit ticket below were drafted by AI for this objective, and every question is editable in the teacher guide.
Part 2 of 3
Practice
7 questions
In Excel, write a formula that adds the values in cell A1 and cell B1 and displays the result in cell C1.
Explain how you would write a formula in Excel to subtract the value in cell B5 from the value in cell A5, then multiply the result by the value in cell C5.
Part 3 of 3
Exit ticket
Quick comprehension check
“In cell C1, write a formula that multiplies the value in cell A1 by the value in cell B1. In cell D1, write a formula that subtracts the value in cell B2 from the value in cell A2, and then adds the value in cell C2. ”
Sample answer included in the free materials
Get the materials
Teacher guide, student handout, and slides — free, in Google Docs format
Teacher Guide
Complete lesson plan with answer keys and alternate activities
Student Handout
Printable worksheet
Slides
Ready to present
We'll ask for your email to send your access link — nothing else.
Teaching a group at a different level?
Where are your students right now? We'll rebuild this lesson to match — including the teacher guide, student handout, and slides, saved to your Google Drive.
Adapt This Lesson
