|
|
| (One intermediate revision by the same user not shown) |
| Line 13: |
Line 13: |
| this order: | | this order: |
|
| |
|
| {{:/1}} | | {{:OER4Schools/Spreadsheet exercises/1}} |
| {{:/2}} | | {{:OER4Schools/Spreadsheet exercises/2}} |
| {{:/3}} | | {{:OER4Schools/Spreadsheet exercises/3}} |
| {{:/4}} | | {{:OER4Schools/Spreadsheet exercises/4}} |
| {{:/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]
| |
