St. John Neumann School

Sixth Grade

Spreadsheet

Row - going across - rows are numbered
Column - going down - columns are lettered
Copy - Apple-C (or Flower-C)
Paste - Apple-V (or Flower-V)
* - Asterisk (or Splat or Star) - used in computers to indicate multiplication

Formulas
=A1+1 - displays the value of cell A1 plus 1
=A1*2 - displays the value of cell A1 times 2
=SUM(A1:A6) - displays the value of the sum of cells A1 through A6

Exercise 1 - Create a speadsheet, using formulas, which looks like the following, but extend the table to 20 rows:
11
22
34
48
516

Exercise 2 - Create a two-dimensional column chart from the above spreadsheet.

Exercise 3 - Create a two-dimensional line chart from the above spreadsheet.

Exercise 4 - Create a spreadsheet, using formulas, which looks like the following, but extend the table to 12 rows:
123456789101112
24681012141618202224
369121518212427303336
4812162024283236404448

Exercise 5 - Create a 3-D column chart from the above spreadsheet.

Exercise 6 - Create a 3-D line chart from the above spreadsheet.