Spreadsheets

Using the Application

First Steps with Spreadsheets

Open and Close a Spreadsheet Application
Create a New Spreadsheet
Save a Spreadsheet to a Location on a Drive
Save a Spreadsheet Under Another Name
Save a Spreadsheet in Another File Type
Switch Between Worksheets, Open Spreadsheets
Use Available Help Functions
Close a Spreadsheet

Adjust Settings

Use Magnification/Zoom Tools
Display, Hide Built-In Toolbars
Freeze, Unfreeze Row and/or Column Titles
Modify Basic Options/Preferences in the Application

Cells

Insert Data

Enter a Number, Date, Text in a Cell

Select Cells

Select a Cell, Range or Adjacent Cells and Non-Adjacent Cells, Entire Worksheet
Select a Row, Range or Adjacent Rows, Range of Non-Adjacent Rows
Select a Column, Range or Adjacent Columns, Range of Non-Adjacent Columns

Rows and Columns

Insert Rows, Columns into a Worksheet
Delete Rows, Columns in a Worksheet
Modify Column Widths, Row Heights

Edit Data

Insert Additional Cell Content, Replace Existing Cell Content
Use the Undo, Redo Command

Duplicate, Move, Delete

Duplicate the Content of a Cell, Cell Range
Use the Auto Fill Tool/Copy Handle to Copy, Increment Data Entries
Move the Contents of a Cell, Cell Range Delete Cell Contents

Search and Replace

Use the Search Command for Specific Content in a Worksheet
Use the Replace Command for Specific Content in a Worksheet

Sort Data

Sort a Cell Range

Worksheets

Handling Worksheets

Insert a New Worksheet
Rename a Worksheet
Delete a Worksheet
Duplicate a Worksheet within a Spreadsheet, Between Open Spreadsheets
Move a Worksheet within a Spreadsheet, Between Open Spreadsheets

Formulas and Functions

Arithmetic Formulas

Generate Formulas Using Cell References and Arithmetic Operators
Recognise and Understand Standard Error Values Associated with Using Formulas

Cell Referencing

Understand and Use Relative, Mixed, Absolute Cell Referencing in Formulas

Working with Functions

Generate Formulas Using Sum, Average, Minimum, Maximum, Count Functions
Generate Formulas Using the Logical Function If

Formatting

Numbers/Dates

Format Cells to Display Numbers to a Specific
Number of Decimal Places
Format Cells to Display a Date Style
Format Cells to Display a Currency Symbol
Format Cells to Display Numbers as Percentages

Contents

Change Cell Content Appearance
Apply Formatting to Cell Contents
Apply Different Colours to Cell Content, Cell Background
Copy the Formatting from a Cell, Cell Range to Another Cell, Cell Range
Apply Text Wrapping to Contents Within a Cell

Alignment, Border Effects

Align Contents in a Cell, Cell Range
Centre a Title Over a Cell Range
Adjust Cell Content Orientation
Add Border Effect to a Cell, Cell Range

Charts/Graphs

Using Charts/Graphs

Create Different Types of Charts/Graphs from Spreadsheet Data
Add and Remove Title, Label to Chart/Graph
Change the Background Colour in a Chart/Graph
Change the Column, Bar, Line, Pie Slice Colours in the Chart/Graph
Change the Chart/Graph Type
Duplicate, Move Charts/Graphs Within a Worksheet, Between Open Spreadsheets
Resize, Delete Charts/Graphs

Prepare Outputs

Worksheet Setup

Change Worksheet Margins
Change Worksheet Orientation, Change Paper Size
Adjust Page Setup to Fit Worksheet Contents on One Page
Add, Modify Text in Headers, Footers in a Worksheet
Insert Fields into Headers and Footers

Preparation

Understand the Importance of Checking
Calculations and Text Before Distribution
Preview a Worksheet
Turn On, Off Display of Gridlines and Display of Row and Column Headings
Apply Automatic Title Row(s) Printing on every Page of a Printed Worksheet

Printing

Know How to Print Cell Ranges, Selected Worksheets and Entire Spreadsheets