|
|
|
|
|
A program that allows you to use ROWS and COLUMNS
of data to forecast, manage, predict, and present information |
|
|
|
|
ENTER-Type in or record data in a spreadsheet |
|
LABEL-Text, symbols, dates or numbers NOT used
in calculations |
|
VALUE-A number that is entered on a spreadsheet
and used for calculations |
|
EDIT-To change the original entry in a
spreadsheet |
|
|
|
|
FORMULA-equation with symbols (+ - * /)
used to find an answer. A formula
always starts with = |
|
RANGE-A defined block of cells |
|
FUNCTION-Create shortcut formulas for the user:
SUM(auto addition) and AVG (auto averaging) |
|
|
|
|
|
|
|
|
|
|
School: Student grades, payroll |
|
Sports: individual and team statistics |
|
Personal: checkbook, household expenses |
|
Business: payroll, investments |
|
|
|
|
Can Answer “What is….?” |
|
students current grade |
|
schedules |
|
budgets |
|
census results |
|
Can Answer “What if….?” |
|
win/loss record changes |
|
hourly wage rate changes |
|
|
|
|
Add + A1+B1 |
|
Subtract - C3-D4 |
|
Multiply * B6*A2 |
|
Divide / F1/F3 |
|
|
|
|
SUM-will add all numbers you specify |
|
AVG-will average all numbers you specify |
|
|
|
|
|
|
|
|
|
|
|
Notes