< Computer Skills < Intermediate

Intermediate 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

  1. YouTube: Simple Formulas
  2. YouTube: Modifying Cells, Rows, and Columns
  3. YouTube: Sorting
  4. YouTube: Format Cells
  5. YouTube: Charts

Activities

  1. Complete the tutorial Creating Simple Formulas.
  2. Complete the tutorial Modifying Columns, Rows, and Cells.
  3. Complete the tutorial Sorting Data.
  4. Complete the tutorial Formatting Cells.
  5. Complete the tutorial Working with Charts.

See Also

References

This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.