Microcomputer Applications

1
Microcomputer Applications
MIS 1503 -- Spring 2004

• Getting Started with Excel

Instructor John Seydel, Ph.D.
2
Administrative Stuff

• Today
• Excel
• Projects 1 2
• Wednesday
• Project 3
• Quiz
• Prepare by
• Reading through text sections
• Completing multiple choice sections and other
  end-of-project material
• Reviewing notes
• Any questions?
• Word
• Excel
• Other . . . ?

3
Summary of Objectives

• Get started with Excel (Project 1)
• Become familiar with the excel work area
• Enter text and numbers
• Save a workbook
• Get help
• Enter formulae
• Prepare a worksheet for printing
• Print a worksheet
• Close a file and exit excel
• Modify worksheets (Project 2)
• Open an existing workbook
• Select worksheet items
• Use autofill
• Insert and delete rows and columns
• Copy and move cell contents
• Use autosum
• Copy a formula with relative references
• Spell-check a worksheet

4
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
5
More Key Terms
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
6
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.

7
Mouse Shapes in Excel
Select a cell
Move selected cells
Copy selected cells
Text insertion point
Edit mode
8
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.
9
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.
10
Basics Rules for Formulas

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

11
Document Orientation
Document orientation is similar to
paintings Landscapes are wider than tall, and
portraits are taller than wide.
12
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.
13
Key Terms for Modifying Data
relative reference
AutoSum
Spelling Checker
shortcut menu
function
absolute reference
range
fill handle
AutoCorrect
clipboard
select
autofill
14
Save Versus Save As
Save As different name, different location, or
both
Save Same location, same filename
15
Recognizing a Selected Range
A selected range has a different fill than the
rest of the worksheet. However, the first cell is
not colored like the rest. You still know it is
selected by the outline around the selection,
including the first cell. In this example, all
10s are selected.
16
Examples of AutoFills

• Days of the Week
• Months of the Year
• Quarter Numbers

• Numeric Sequences
• Dates
• Times

1 2 3
Slide 2-5
17
Steps to Copy and Paste
Step 1 Select the item
Slide 2-6
18
AutoSum Equation
The function
SUM(B3D7)
Indicates this item will be a calculation
The range of cells that will be calculated
Slide 2-7
19
Relative vs. Absolute References
An e-mail address can be accessed from
any computer, just like a relative cell
reference changes when copied.
A home address is a permanent address, just like
an absolute cell reference does not change.
Slide 2-9
20
Summary of Objectives

• Get started with Excel (Project 1)
• Become familiar with the excel work area
• Enter text and numbers
• Save a workbook
• Get help
• Enter formulae
• Prepare a worksheet for printing
• Print a worksheet
• Close a file and exit excel
• Modify worksheets (Project 2)
• Open an existing workbook
• Select worksheet items
• Use autofill
• Insert and delete rows and columns
• Copy and move cell contents
• Use autosum
• Copy a formula with relative references
• Spell-check a worksheet

21
Appendix
22
Organizing Your Desktop

• Note the following structure
• Desktop (or Floppy drive root folder)
• Misc
• HomePage.txt
• HomePage.htm
• astate_logo.jpg
• Day1
• FirstExcel.xls
• Access
• Excel
• PowerPoint
• Word
• ProposalLetter-WB2L.doc
• AddressLabels-WB2L.doc
• OfficeSoftware-WB3L.doc
• Create the above folder/file structure
• Files are indicated by their extensions
• Folders are those names without extensions

23
Copying Desktop to a Floppy

• Open Windows Explorer (should already be open)
• Scroll to top in Folders panel and click on
  Desktop
• In Contents panel select the folders youve
  created
• Click on first
• While holding down the Ctrl key, click on the
  other folders
• Click on Edit on the Menu bar
• Scroll to and click on floppy disk in Folders
  panel
• Click on Paste on the Menu bar

24
Setting up Windows Explorer

• Start by setting the view to details
• Click on View in the menu bar
• Select Details
• Then make extensions visible
• Click on Tools in the menu bar
• Then select Folder Options
• Click on the View tab
• Uncheck the Hide extensions . . . box
• Click on OK
• Make the settings universal
• Click on Tools and then Folder Options
• Click on the View tab
• Click the Apply to All Folders button
• Now you should be able to complete Wednesdays
  exercise