CPT 105

Franklin College

Fall 2005

Erich Prisner

###

rows and columns

recomputes everything automatically

into cells: text/labels, numbers/data (input cells) , functions/formulas (output
cells)

worksheets, rows, columns, and cells; addresses,

the standard toolbar, undo,

active cells, moving

data types: numbers, dates, percentages, currencies,

formatting cells

column width, row height, inserting rows and columns, freezing,

charts

formulas: start always with an "="-sign. type in addresses instead
of data! Selct cells by clicking or typing.

Basic Mathematical operations: +, -, *, /

copying formulas: fill down and right, absolute and relative referencing (positioning)

functions as prepackaged formulas. Ranges and how to select them.

The function wizard

SUM, AVERAGE, IF, maybe MAX, COUNT, PMT

sorting

## What you need to be able to do for the Excel quiz

#### Formatting:

- simple features: color, width, font, ...
- date, currency, number
- Conditional Formatting
- freezing
- inserting rows and columns

#### Formulas & Functions:

- elementary formulas: achieving the sum or product or quotient or
difference of two cell values,
- SUM
- AVERAGE
- IF
- copying formulas
- absolute versus relative referencing

#### Charts