Introduction to Basic Spreadsheet formulas

Grade Levels
Product Rating
Not yet rated
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
1.02 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

AS WELL AS...

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
Answer Key
Included
Teaching Duration
55 Minutes

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$4.99
Digital Download
ADD ONE TO CART
$4.99
Digital Download
ADD ONE TO CART
Introduction to Basic Spreadsheet formulas
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