Computer Skills/Intermediate/Spreadsheets
< Computer Skills < IntermediateIntermediate spreadsheet concepts include calculations, row and column management, formatting, graphs and charts.
Objectives and Skills
Objectives and skills for spreadsheets include:[1]
- Make simple calculations
- Know how to insert/delete rows/ columns; sort
- Know how to format data: font; color; number; text; etc
- Understand that a change to one cell impacts on another
- Know how to draw graphs and make charts
Multimedia
- Watch YouTube: Simple Formulas.
- Watch YouTube: Modifying Cells, Rows, and Columns.
- Watch YouTube: Sorting.
- Watch YouTube: Format Cells.
- Watch YouTube: Charts.
Activities
- Complete the tutorial Creating Simple Formulas.
- Complete the tutorial Modifying Columns, Rows, and Cells.
- Complete the tutorial Sorting Data.
- Complete the tutorial Formatting Cells.
- Complete the tutorial Working with Charts.
See Also
- Computer Skills/Basic/Spreadsheets
- Computer Skills/Advanced/Spreadsheets
- Computer Skills/Proficient/Spreadsheets
References
This article is issued from Wikiversity - version of the Thursday, August 20, 2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.