Skip Navigation

Comp Tech - Spreadsheet Operators and Formulas

Main Core Tie

Computer Technology I
Strand 4

Time Frame

1 class periods of 60 minutes each


Business Ed Lesson Plan Team


A spreadsheet is a tool that can help solve the numeric "story problems" of your life. This assignment introduces how to set up Excel formulas based on fifteen simple scenarios (with five additional difficult scenarios for extra credit).


Instructional Procedures

Teach formula symbols including = to begin a formula, and operators for add, subtract, multiply, and divide. Teach the order of operations (Multiply and Divide, then Add and Subtract) and using Parentheses to interrupt the order.

Created: 01/17/2011
Updated: 02/04/2018