|
|
| Line 18: |
Line 18: |
| {{:OER4Schools/Spreadsheet exercises/4}} | | {{:OER4Schools/Spreadsheet exercises/4}} |
| {{:OER4Schools/Spreadsheet exercises/5}} | | {{:OER4Schools/Spreadsheet exercises/5}} |
|
| |
| '''1. Basic Calculations'''
| |
|
| |
| * [http://inpics.net/tutorials/calc2/basics13.html Add]
| |
| * [http://inpics.net/tutorials/calc2/basics21.html Subtract]
| |
| * [http://inpics.net/tutorials/calc2/basics24.html Multiply]
| |
| * [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]
| |
