OpenOffice Spreadsheet Tutorials

Open OpenOffice Spreadsheet on your computer. Follow along with the instructions. Show Mrs. Carrier the completed work at the completion of each tutorial.

1. Enter Data



2. Edit Data




3. Format Numbers



4. Cells, Formatting, Formulas




5. Formatting, Graphs & Charts, Column Widths

You need a spreadsheet with data to crate the chart. Enter the following information on a spreadsheet with the words Week 1 in cell C3.
You can copy the data below and paste in a spreadsheet to get it started.
Note that my numbers below do not exactly match those on the tutorial, but they are close enough to use for the graph.
The title is Takings for the Week. The X axis is Weeks and the Y axis is Value in Dollars.

Week 1
Week 2
Week 3
Week 4
Monday
12.80
17.30
11.36
14.97
Tuesday
14.80
18.80
17.48
17.17
Wednesday
6.80
14.76
12.56
12.23
Thursday
3.40
7.48
5.23
5.08
Friday
58.90
61.90
29.00
10.47



6. Sorting Data




7. AutoSum Formula





8. Entering Formulas - (Note: He messes up the first formula but then gets it right!)