Lecture

Excel: Basics Review

Anatomy of the Excel Window

Name Box

Formula Bar

Worksheet

Selected Cell

Rows

Columns

Cell Address

Basic Vocabulary

B 3

Worksheet Limits

Last cell in a worksheet!

65536

IV

Cell address of IV65536

20032007+

XFD

Last cell in a worksheet!

Cell address of XFD10485761,048,576

Typical Spreadsheet

FormulasValues

Titles Labels Borders

Excel Cell Types

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

Labels

• Identifies values• Left justified• Examples:

– Column headings– Row headings– Notes

Values

• Numbers, dates, times• Can be used for calculations• Right justified• Examples:

378 11/29/94 4:40:31 (9876)

• Recognized as number if begins with– + = @ # $ or any digit

Number Date Time Negative Number

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.

Column Width

• Pound signs in cell indicate column is too small

• Need to widen column

Column Width (cont)

Cell not large enough, but adjacent cell is filled

Cell still not large enough, but adjacent cell is empty

Column Width (cont)

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

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)

Changing Cell Formats

• Easy way: use an icon

• Powerful way:– Menu: Format | Cells– Shortcut: Ctrl-1

Format Options

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

Additional Cell Formatting

• Data should be formatted so it’s purpose is clear

• Use borders, colors, shading, font sizes to emphasize:

•Row & Column Titles•“bottom line” • Totals – Use Border

1

+

1

Additional Features

• Header/Footer• Print• Freeze • Compare• Lists

Header & Footer

• Your spreadsheets should have your logo in the header

• Insert – Header/Footer

Page Setup Options

• Your spreadsheets should fit on one page• Must have the appropriate header• Be centered vertically and horizontally