Enter data and formulas in a spreadsheet.

Entering data should include

  • explaining the difference between text and numbers in cells (i.e., labels, values)
  • explaining that a spreadsheet formula is a combination of values or cell references and mathematical operators
  • inputting and formatting data (i.e., text, numbers)
  • creating an absolute reference
  • exploring the function library
  • using the AutoSum function (i.e., Sum, Average, Count, Max, Min)
  • creating formulas
  • defining and protecting named ranges
  • using freeze panes function
  • using the zoom function
  • using the fill handle features (e.g., copying text and formulas, creating a series).