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