ctc TrainCanada development site
placeholder
GoalSheet Explorer
TITLE:
GOAL DESCRIPTION:
Title:
Quattro Pro
Level Id
1
Description
Students will gain the knowledge, the skills and the confidence to create, format, enhance and print simple spreadsheets.
Prerequisites
Prerequisites include an introductory course on Windows or equivalent working knowledge of the software
Goalsheetgoals
TITLE:
GOAL DESCRIPTION:
Enter Text Enter Values, Numbers and Dates Select Columns and Rows Use the QuickFill Option Use Quick Correct
TITLE:
GOAL DESCRIPTION:
Format Cells Format Columns Format Rows Use the Format Painter Use Format Styles
TITLE:
GOAL DESCRIPTION:
Use the Undo Function Insert and Delete Columns and Rows Insert and Delete Notebooks Name a Notebook Use Find and Replace Options
TITLE:
GOAL DESCRIPTION:
Understand the Concept of Formulas Enter Simple Formulas Copy Formulas Understand Absolute versus Relative References
TITLE:
GOAL DESCRIPTION:
Understand the Concepts Use the QuickSum Feature Use Basic Functions
TITLE:
GOAL DESCRIPTION:
Use the Spell Checker Use Page Setup Insert Page Breaks Insert Headers and Footers
TITLE:
GOAL DESCRIPTION:
Use the Drawing Toolbar Manipulate Objects Format Objects Group and Ungroup Objects Insert Picture
TITLE:
GOAL DESCRIPTION:
Create a Chart with the Chart Expert Use the Chart Options
TITLE:
GOAL DESCRIPTION:
Customize Toolbars Create a New Toolbar
TITLE:
GOAL DESCRIPTION:
Use Quick Fill Option QuickFill
TITLE:
GOAL DESCRIPTION:
Create Name Ranges Use Range Names in Formulas
TITLE:
GOAL DESCRIPTION:
Create a List Sort a List Use Sort Options
TITLE:
GOAL DESCRIPTION:
Hide and Show Columns and Rows Protect Cells Protect Notebook Share Notebooks
TITLE:
GOAL DESCRIPTION:
Create a Subtotal Using SmartLabel Setup Create Multi-Level Subtotals
TITLE:
GOAL DESCRIPTION:
Review Concepts Statistical Formulas Use VLOOKUP Use Array Formulas Use Nested If Statements
TITLE:
GOAL DESCRIPTION:
Add Comments Hide Comments Edit and Delete Comments Print Comments
TITLE:
GOAL DESCRIPTION:
Create Bar/Pie/Line Charts Create Exploding Pie Charts Modify Chart Elements Add Text Print Charts
TITLE:
GOAL DESCRIPTION:
Create Custom Views Print Custom Views Share Custom Vieews