Introduction to Basic Spreadsheet formulas

Introduction to Basic Spreadsheet formulas
Grade Levels
Product Rating
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

1 MB|4 pages
Product Description
This step-by-step easy to follow lesson includes 4 files which introduces the student to spreadsheets concepts and the basic formulas required to complete spreadsheet exercises.

The exercise teaches the student the following concepts:
a. Basic spreadsheet terminology
b. The SUM formula to add a range of cells
c. The MAX formula to find the highest number in a range of cells
d. The MIN formula to find the smallest number in a range of cells
e. The AVERAGE formula to find the average number in a range of cells


a. the formula for calculating percentages
b. the formula for calculating percentage change
c. How to format a spreadsheet for appearance
d. How to create a simple graph from a calculated spreadsheet

The package includes four files:
1. teacher instructions (created in WORD)
2. Step-by-step student instructions hand-out for the student to complete the exercise (created in WORD which can be edited by the teacher)
3. The Excel answer key for the teacher
4. The Excel downloadable file for the students if the teacher chooses this option,

The Student and teacher instructions contain links to Youtube videos created by the author that assist both the teacher and student in terms of understanding the exercise. Easy-to-use for any student or teacher.

Preview the screen shot of the answer key to this exercise
Total Pages
4 pages
Answer Key
Teaching Duration
55 minutes
Report this Resource
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up