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).