Anatomy of the Excel Window

1
Anatomy of the Excel Window
2
Basic Vocabulary
Cell Address
Worksheet
3
Worksheet Limits
IV
Last cell in a worksheet!
65536
Cell address of IV65536
4
Typical Spreadsheet
5
Excel Cell Types

• Labels (text)
• Values (data)
• Formulas (calculation)

6
Labels

• Identifies values
• Left justified
• Examples
• Column headings
• Row headings
• Notes

7
Values

• Numbers, dates, times
• Can be used for calculations
• Right justified
• Examples
• 378 11/29/94 44031 (9876)
• Recognized as number if begins with
• _at_ or any digit

Number Date Time
Negative Number
8
Formulas

• Specifies calculations to be performed
• Begins with an equal sign ()
• Can contain cell references, arithmetic
  operators, values and built-in functions
• Recalculates when cell reference changes
• Example A1 B2

Note Without the equal sign, it's just a label.
9
Column Width

• Pound signs in cell indicate column is too small
• Need to widen column

10
Column Width (cont)
Cell not large enough, but adjacent cell is filled
11
Column Width (cont)

• Format, Column, Width, or
• Format, AutoFit Selection, or
• Double-click between columns

12
Using the Mouse

• Select cells to edit data
• Highlight a group of cells (a range) to edit them
  all at once
• Right-click on a cell for options
• Pointer icon
• Thick Select cell(s)
• Thin Crosshair Fill Data/Series/Copy
• Four-Way Move cell(s)

13
Changing Cell Formats

• Easy way use an icon
• Powerful way
• Menu Format Cells
• Shortcut Ctrl-1

14
Format Options

• Comma?
• Dollar Sign?
• Decimal Places?
• Negative Numbers?

15
Additional Cell Formatting

• Data should be formatted so its purpose is clear
• Use borders, colors, shading, font sizes to
  emphasize
• Row Column Titles
• bottom line
• Totals Use Border

1 1