# Introduction to Basic Spreadsheet formulas

Subject
Resource Type
Product Rating
File Type

Compressed Zip File

1 MB|4 pages
Share
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:
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 pages
Included
Teaching Duration
55 minutes
Report this Resource
\$4.99