Computer Skills/Intermediate/Spreadsheets

From Wikiversity
Jump to navigation Jump to search

Intermediate spreadsheet concepts include calculations, row and column management, formatting, graphs and charts.

Objectives and Skills[edit | edit source]

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[edit | edit source]

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

Activities[edit | edit source]

  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[edit | edit source]

References[edit | edit source]