Spreadsheet Addition Formula Guide page 1 1 A

Spreadsheet Addition Formula Guide page 1 1. A spreadsheet is a CALCULATOR. You add BOXES not NUMBERS Here's how: 2. You want to add these numbers And put the answer HERE 3. This box is called E 5. Its where “E” and “ 5” meet. 4. SO, Click on this box. 5. then type this: =e 5+e 6+e 7+e 8+e 9+e 10 6. Press the ENTER key.

Spreadsheet Addition Formula Guide page 2 1. Now add the second day. Here's how: 2. You want to add these numbers And put the answer HERE 3. This box is called J 5. Its where “J” and “ 5” meet. 4. SO, Click on this box. 5. then type this: =j 5+j 6+j 7+j 8+j 9+j 10 6. Press the ENTER key.

Spreadsheet Addition Formula Guide page 3 1. Now add the third day. Here's how: 2. You want to add these numbers And put the answer HERE 3. This box is called E 19. Its where “E” and “ 19” meet. 4. SO, Click on this box. 5. then type this: =e 19+e 20+e 21+e 22+e 23+e 24 6. Press the ENTER key.

Spreadsheet Addition Formula Guide page 4 1. Now add the fourth day. Here's how: 2. You want to add these numbers And put the answer HERE 3. This box is called J 19. Its where “J” and “ 19” meet. 4. SO, Click on this box. 5. then type this: =j 19+j 20+j 21+j 22+j 23+j 24 6. Press the ENTER key.

Spreadsheet Addition Formula Guide page 5 1. So now you want to add all the totals in this box for the GRAND TOTAL 3. Click on the answer box. And in it type: =e 13+j 13+e 27+j 27. 4. Then press the ENTER key. 2. You want to add these boxes here and have the answer be here