Excel 2002 Essentials Basic

1
Excel 2002 EssentialsBasic

• Welcome to

Slide 1-1
2
Getting Started with Excel Project 1 Objectives

• Exploring the Excel Work Area
• Entering Text and Numbers
• Saving a Workbook (and as a Web Page)
• Entering a Formula
• Preparing a Worksheet for Printing
• Printing a Worksheet
• Closing a File and Exiting Excel

Slide 1-2
3
Key Terms for Getting Started
name box
Formatting toolbar
Formula bar
cell
menu bar
cell address
landscape orientation
mouse pointer
long label
column letter
formula
AutoComplete
constants
default
arithmetic operator
current cell
Slide 1-3
4
Key Terms for Getting Started
task pane
Office Assistant
title bar
worksheet window
worksheet
workbook
toolbars
Standard toolbar
status bar
worksheet frame
column letter
scrollbars
row number
spreadsheet
portrait orientation
sheet tab
Slide 1-4
5
Cell References

• Locating a cell is like locating a ship at
  sea. The location of the ship is determined by
  the longitude and latitude of its position.
  Likewise, a cell is known by the row and column
  in which it is found.

Slide 1-5
6
The Worksheet
Like puzzle pieces that work together to make a
puzzle complete, cells work together to make a
worksheeta finished product that explains data.
Slide 1-6
7
Mouse Shapes in Excel
Select a cell
Move selected cells
Copy selected cells
Text insertion point
Edit mode
Slide 1-7
8
Editing Cell Contents

• Double-click the cell and make corrections in the
  cell.
• Press F2 and make corrections in the cell.
• Click in the Formula bar and make corrections
  there.

Slide 1-8
9
Cell Alignments
General alignment for text is left-aligned in
the US, we read from left to right. General
alignment for numbers is right- aligned we lined
up numbers from the decimal point (the right).
Income
You may choose to center a cell, such as a
heading. Merge and Center are perfect for titles
across columns.
Slide 1-9
10
Adjusting Column Widths
Just like the fingers of one hand are covered by
the other hand, text is not gone when it is
covered by text in another cell. Just widen the
column to reveal the text, as you would widen the
space between your hands.
Slide 1-10
11
Saving a Worksheet

• When saving a file, remember to include the
  following filename, disk, and folder.
• Saving a file without these
• three items is like mailing a letter
  without a name, address, and zip code.

Slide 1-11
12
Using Folders
We do not find toilets in the living room or
stoves in the bedroom. We organize our homes by
room. We should likewise organize our files into
appropriate folders.
Slide 1-12
13
Getting Help

• Office Assistant Ask him a question and get a
  list of possible solutions. Also access the
  Contents, Answer Wizard, and Index help text.
• Whats This? Learn more about a particular
  object in an Access window.
• Ask a Question Get help without using the
  Office Assistant character.
• Online Help Access Microsofts Web page for
  more help.

Slide 1-13
14
Basics Rules for Formulas

• Begin with an equal sign ()
• Use cell references when possible
• Use the following operators
• Addition
• Subtraction -
• Multiplication
• Division /
• Exponent

Slide 1-14
15
Document Orientation
Document orientation is similar to
paintings Landscapes are wider than tall, and
portraits are taller than wide.
Slide 1-15
16
Print Preview
We like to see pictures in catalogs to help us.
Descriptions are not enough. Use Print Preview to
see what the output of your document will be
before you buy it. Dont rely on the
description in design view.
Slide 1-16
17
Sample Exam Question
Available Only in Lecture