Advantage Series for Computer Education Search for Software Tutorials

Topics

Windows/
  Internet

Office XP
Office 2000
Office 97
Office 95/4.3
Other Titles
Multimedia

Overview

Our Books
Our Approach
For Instructors
Get Password
Find Your Book Glen & Sarah

Resources

Quizzes
Exercises
Certification
Corrections
Send Us Email

Lotus 123 Rel 3.1

Hutchinson Sawyer and Coulthard

ISBN: 0-256-13490-1
Published: 12/01/1993
Pages: 206 with 5 Chapters
Binding: Perfect Bound

Advantage Series for Computer Education

Online Resources

Student download files:
There are no student download files.

Instructor download files:
There are no instructor download files.

Miscellaneous Web resources:
Check for MHHE Catalog Listing

Print Resources

Related tutorials for students:
Lotus 123 Rel 2.2 (ISBN: 0256134871)
Lotus 123 Rel 2.3 (ISBN: 0256137129)
Lotus 123 Rel 2.4 (ISBN: 0256137153)

Other resource materials:
No other resources are available.

Table of Contents

Session 1: Fundamentals

Why Is This Session Important?
Parts of Lotus 1-2-3 and Add-Ins
Electronic Spreadsheet Development Procedures
Loading Lotus 1-2-3
Moving the Cursor
How the Keyboard and Mouse are Used
Overview of Data Entry
Editing a Cell
Using Menu Mode
Using the UNDO Feature
Getting Help
Working with Ranges
Erasing a Range
Erasing the Spreadsheet Area
Exiting
Summary
Key Terms
Exercises

Session 2: Working with Spreadsheets

Why Is This Session Important?
Entering Text (Labels)
Entering Numbers (Values)
Using the @SUM Function
Formatting Numbers: Currency
Widening Columns
Changing the Current Directory
Saving the Spreadsheet
The SYSTEM Command
Recalculating the Spreadsheet: Changing a Few Numbers
Saving the Spreadsheet More Than Once
Retrieving the Spreadsheet
Printing the Spreadsheet
Print Options
Summary
Key Terms
Exercises

Session 3: Additional Spreadsheet Procedures

Why Is This Session Important?
Copying
Moving
Formatting Commands
Global Commands: Formatting Numbers and Widening Columns
Range Commands: Formatting Numbers and Realigning Labels
@AVG
@MIN
@MAX
@DATE
@IF
Circular References: Avoiding Them
Summary
Key Terms
Exercises

Session 4: Managing a Spreadsheet

Why Is This Session Important?
Range Names
Titles
Windows
Protection
Consolidating Spreadsheets
File-Linking
What Is a Macro?
Creating Macros
Creating Macros Using the Keystroke Recorder
Other Useful Macros
Summary
Key Terms
Exercises

Session 5: Creating Graphs

Why Is This Session Important?
Forms of Business Graphics Presentation
Principles of Graphics Presentation
Saving Graphs: Important Steps to Follow
Using Lotus 1-2-3 to Create and Print Graphs
Creating a Pie Chart
Creating a Simple Bar Chart
Creating a Stacked Bar Chart
Creating a Grouped Bar Chart
Creating a Line Chart
Creating a Table of Graph Names
Printing a Graph
Summary
Key Terms
Exercises

Session 6

Why Is This Session Important?
Using Add-In Software
WYSIWYG Fundamentals
Summary
Key Terms
For Practice

Sorry, there are no quizzes yet available for this title.

Corrections
Submit a Correction

There are no errata details for this title. To report an error, please click the link above to send an e-mail with the book's ISBN, page reference, problem, and the suggested correction.

List All Corrections

Purchasing
Please visit the campus bookstore or contact your McGraw-Hill sales representative at 1-800-338-3987.

To request an instructor copy:
In the U.S.
Outside the U.S.

To purchase this title online, go to:
Amazon.com

ISBN 0256134901

Last updated on April 10, 2003
Send comments or questions to Glen Coulthard
Copyright (c) 2001 by Current Communications Inc.