| Bake Sale Earnings |
Right click a
cell to get 'insert note' |
Save your work
often |
| Right Click a cell to get formatting |
|
|
|
| # 1 SAVE THIS TO
YOUR FOLDER |
|
|
|
|
|
|
| 1. Name Sheet 1 'Bake Sale' |
2. put your cursor in the bottom right corner of cell A/4 and
pull down to get the days of the week |
3.
do it again in the corner of B/4 |
4. In B/11 = total. Key in
=sum(b4:b10) ENTER or TAB |
5. Put a minus sign in front of a # look at the total |
6. Read the comment in b5 – scroll over the red dot in the upper
right corner |
7.
Highlight cells d4 & D5 and drag down the cross-hair
in the corner |
8. To average daily amounts /7 =sum(b4:b10)/7 |
| Monday |
$15.00 |
August |
7 |
|
|
|
|
|
| |
[1] |
|
14 |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| TOTAL |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| Lesson 2 |
|
|
|
|
|
|
|
| |
To sort means to alphabetize.
The Sort Buttons [2] |
|
To
sort data in one column: |
|
1.
Key in ten songs & sort |
2.
Sort by how many downloads |
3.
What is the average downloads? |
| |
|
|
|
Highlight
the cells that will be sorted.
Go to Data > Sort
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|