1.6180339
Mass (kilograms)
=18/6
Number
Label
Formula
There are only THREE things you could put into a CELL
Numbers have ONLY numerical digits!
Labels can be a mixture of numbers, letters, or symbols!
Formulas are logical mathematical arguments, and they begin with an equal sign.
Is each of the following�a Number, a Label, or a Formula?
5.6 meters
5*6
=5*6
Formula
Label
Label
There is a mixture of numbers and symbols!
It DIDN’T start with an “=“ sign!
5.6 ± .2
Label
There is a mixture of numbers and symbols!
Average(2,4,5)
Label
It DIDN’T start with an “=“ sign!
It starts with an “=“ sign!
=Average(2,4,5)
Formula
It starts with an “=“ sign!
56
Number
There are only numbers
BLOCK (Select)
MOVE
COPY
The cursor changes shape depending where on the spreadsheet it is placed!
Change Row Height
Change Column Width
Distance
Time
Velocity
(meters)
(seconds)
(meters/second)
2.8
.6
4.7
1.2
=2.8/.6
=4.7/1.2
6.6
1.8
=6.6/1.8
8.5
2.4
=8.5/2.4
10.4
3.0
=10.4/3.0
12.3
3.6
=12.3/3.6
14.2
4.2
=14.2/4.2
16.1
4.8
=16.1/4.8
18.0
5.4
=18.0/5.4
Use Excel as a calculator.
Use Excel as a calculator.
=A5/B5
=A6/B6
=A7/B7
=A8/B8
=A9/B9
=A10/B10
=A11/B11
=A12/B12
=A13/B13
Distance
Time
(meters)
(seconds)
2.8
.6
4.7
1.2
6.6
1.8
8.5
2.4
10.4
3.0
12.3
3.6
14.2
4.2
16.1
4.8
18.0
5.4
Velocity
(meters/second)
Use Excel as a calculator.
Distance
Time
(meters)
(seconds)
2.8
.6
4.7
1.2
6.6
1.8
8.5
2.4
10.4
3.0
12.3
3.6
14.2
4.2
16.1
4.8
18.0
5.4
Velocity
(meters/second)
=average(A5:A13)
=sum(B5:B13)
4.7
3.9
3.7
3.5
3.5
3.4
3.4
3.4
3.3
Some common formulas!
=sum(…
=abs(…
=asin(…
=sin(…
=cos(…
=tan(…
=acos(…
=atan(…
=slope(…
=intercept(…
=degrees(…
=radians(…
=average(…
Sum of a set of numbers
Absolute value
Inverse Sine
Sine of an angle (in radians)
Cosine of an angle (in radians)
Tangent of an angle (in radians)
Inverse Cosine
Inverse Tangent
Slope of a line
Intercept of a line
Converts from radians to degrees
Converts from degrees to radians
Average of a set of numbers
=log(…
Takes the log base 10 of a number
“Right Click”
on a data point.
Delete�Legend