Back to Lesson Library

Excel Formula Programming

Unknown Grade45 min

Learning Objective

I can write basic Excel formulas using cell references and mathematical operators (+, -, *, /).

Lesson Flow

Watch Video

5 min

IF Function in Excel Tutorial

Unknown Channel

Practice

14 min

7 questions • Short answer

Exit Ticket

5 min

“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. ”

Teacher Guide

Get the complete package:

  • Answer keys for all questions
  • Differentiation strategies
  • Extension activities
  • Printable student handouts

New to Insta~Lesson?

We would love to help you present Insta~Lesson to your colleagues and administrators. Here are a few resources you can use:

About Insta~Lesson

A simple one-pager you can use to share Insta~Lesson.

How Insta~Lesson Helps Teachers Plan

Learn how Insta~Lesson makes life easier for teachers. This is a great resource to share at a staff meeting or PD!

How Insta~Lesson Supports Instruction Schoolwide

Learn more about Insta~Lesson's dedicated supports for partner schools.

Create Your Own Lesson