1-2-3 Millennium Edition 9.5: Worksheets

Course description

Overview: Students will learn how to build, format, and print a basic worksheet.

Prerequisites: Windows 98: Introduction or equivalent knowledge.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

*     Realize the disadvantages of paper spreadsheets and be familiar with the basics of the 1-2-3 environment by examining a paper spreadsheet and starting the 1-2-3 program.

*     Create and save a basic worksheet by entering text, values, and formulas; access different areas of a worksheet by using the keyboard and the mouse.

*     Modify a worksheet by editing existing data; create formulas by using 1-2-3’s built-in @Functions; and use a number of techniques to access 1-2-3’s On-Line Help system.

*     Insert rows into the worksheet and move data by using shortcut menus and the drag-and-drop technique.

*     Copy data and quickly fill ranges with data by using shortcut menus and the SmartFill technique.

*     Change the appearance of the worksheet by using the status bar and the InfoBox.

*     Prepare a document for printing by using the Spell Check feature and a variety of printing options.

*     Learn the basics of using three-dimensional workbooks, creating charts, and using SmartMasters.

Course content

Lesson 1: 1-2-3 Basics

The Paper Spreadsheet

Starting 1-2-3

The 1-2-3 Window

Lesson 2: Entering Data and Navigating in a Worksheet

Entering and Correcting Data

Using Formulas

Opening a Second File

Navigation and Movement Techniques

Lesson 3: Modifying a Worksheet

Working with Ranges

Using @Functions

Editing Cell Contents

Using the 1-2-3 On-line Help

Lesson 4: Inserting Rows and Moving Data

Inserting Rows and Ranges

Moving Data

Lesson 5: Copying Data

Copying Data

Absolute References

Using Fill by Example

Lesson 6: Formatting Techniques

Formatting Cell Contents by Using the Status Bar

Formatting Text by Using the InfoBox

Formatting Numbers by Using the InfoBox

Copying Styles

Lesson 7: Printing a Worksheet

Checking Spelling

Using Print Preview

Page Setup and Print Options

Lesson 8: Additional Features

Introduction to a Three-dimensional Workbook

Creating a Basic Chart

Using SmartMasters