Spreadsheets

Google Sheets Sites:

Basic Skills of the Spreadsheet

  • define basic spreadsheet terminology
  • identify a cell reference
  • enter, edit, or delete data into a cell
  • select a cell or a range of cells
  • modify column width and row height
  • format data: font, size, color, and style
  • merge and center data
  • align data within a cell
  • fill a cell with color
  • apply borderlines
  • apply number formats to data
  • alter the number of decimal places
  • calculate the total number using AutoSum
  • sort data alphabetically or numerically
  • graph data
  • format a graph to alter its appearance
  • insert clip art or picture file
  • scale, move, and rotate objects
  • insert and delete columns or rows
  • view a worksheet using the sheet tabs
  • print a workbook or worksheet
  • print preview a worksheet
  • copy formatting from a cell to another
  • cut, copy and paste a selection of cells

Advanced Skills of the Spreadsheet

  • fill cells with a series using AutoFill
  • calculate data using formulas
  • troubleshoot an error message
  • use absolute cell references
  • use statistical functions
  • format a cell using conditional formatting
  • apply an autoformat to a selection of cells
  • produce a pivot table and chart
  • perform a what-if analysis
  • hide or unhide columns
  • define a name for a cell
  • customize the header or footer
  • filter data
  • produce multi-level sorts
  • add a trend line to a graph
  • change the chart type
  • view a document in page break view
  • insert or delete worksheets
  • rename or color a sheet tab
  • copy a worksheet
  • customize print settings
  • set page breaks and print area