|
|
| (4 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| | <noinclude>{{OER4SchoolsRinfo |
| | |title=Spreadsheet exercises |
| | |tagline=A set of basic spreadsheet exercises to get you started |
| | }}</noinclude> |
| | |
| This activity will orientate you to make use of OpenOffice for creating | | This activity will orientate you to make use of OpenOffice for creating |
| spreadsheets and databases which can be useful for investigating maths | | spreadsheets and databases which can be useful for investigating maths |
| Line 8: |
Line 13: |
| this order: | | this order: |
|
| |
|
| '''1. Basic Calculations'''
| | {{:OER4Schools/Spreadsheet exercises/1}} |
| | | {{:OER4Schools/Spreadsheet exercises/2}} |
| * [http://inpics.net/tutorials/calc2/basics13.html Add]
| | {{:OER4Schools/Spreadsheet exercises/3}} |
| * [http://inpics.net/tutorials/calc2/basics21.html Subtract]
| | {{:OER4Schools/Spreadsheet exercises/4}} |
| * [http://inpics.net/tutorials/calc2/basics24.html Multiply]
| | {{:OER4Schools/Spreadsheet exercises/5}} |
| * [http://inpics.net/tutorials/calc2/basics28.html Divide]
| |
| * [http://inpics.net/tutorials/calc2/basics31.html Calculate averages]
| |
| * [http://inpics.net/tutorials/calc2/basics35.html Find the maximum value]
| |
| | |
| '''2. Formatting Worksheets'''
| |
| | |
| * [http://inpics.net/tutorials/calc2/format2.html Format text]
| |
| * [http://inpics.net/tutorials/calc2/format11.html Format cells]
| |
| * [http://inpics.net/tutorials/calc2/format23.html Adjust columns and rows]
| |
| * [http://inpics.net/tutorials/calc2/format28.html Print worksheets]
| |
| | |
| '''3. Manipulating Data'''
| |
| | |
| * [http://inpics.net/tutorials/calc2/data2.html Move, copy, and paste]
| |
| * [http://inpics.net/tutorials/calc2/data12.html Add / delete columns]
| |
| * [http://inpics.net/tutorials/calc2/data18.html Add / delete rows]
| |
| * [http://inpics.net/tutorials/calc2/data23.html Employ multiple worksheets]
| |
| * [http://inpics.net/tutorials/calc2/data26.html Employ AutoFill]
| |
| * [http://inpics.net/tutorials/calc2/data32.html Insert / delete worksheets]
| |
| | |
| '''4. Advanced Calculations'''
| |
| | |
| * [http://inpics.net/tutorials/calc2/calc2.html Create formulas across worksheets]
| |
| * [http://inpics.net/tutorials/calc2/calc8.html Employ absolute references]
| |
| * [http://inpics.net/tutorials/calc2/calc17.html Employ the function wizard]
| |
| | |
| '''5. Making Data Visible'''
| |
| | |
| * [http://inpics.net/tutorials/calc2/vis2.html Add notes]
| |
| * [http://inpics.net/tutorials/calc2/vis5.html Freeze panes]
| |
| * [http://inpics.net/tutorials/calc2/vis9.html Create charts]
| |
