Working with Spreadsheets
o Open, close a spreadsheet application
o Create a new spreadsheet
o Save and Save as
o Use available Help functions
o Use magnification/zoom tools
Cells
o Insert Data
o Select Cells
o Rows and Columns
o Edit Data
o Duplicate, Move and Delete
o Search and Replace
o Sort Data
o Use the undo, redo command
o Use the Auto fill tool
Managing Worksheets
o Insert, delete rows and columns
o Modify column widths & row heights
o Freeze, unfreeze row and column
o Insert & Delete Worksheets
o Rename Worksheet
o Move & Duplicate Worksheet
Formulas and Functions
o Arithmetic Formulas
o Create formulas using cell references
o Understand standard error values associated with using formulas
o Functions
o Use the logical function
Formatting
o Numbers/Dates
o Text Formatting
o Alignment and Border Effects
Charts
o Create Different Types of Charts/Graphs
o Add & Removing Titles & Labels
o Change the Background
o Change Chart/Graph Type
o Resize Charts/Graphs
o Delete Charts/Graphs
Prepare Outputs
o Worksheet Setup
o Check and correct
o Preview and Printing
