Model

Excel1_1.txt

1) Essential Skills:

Open, save, print, copy, edit

Print: part of spreadsheet, whole spread sheet,

whole workbook

Save: save as an Excel file, as a text file

Import: input Excel and text files

Copy spreadsheet, rename spread sheet

F1: help; F5 (go to e.g., A155); F9 recalculate

2. Format: Fix decimal places, width of a column, comma, %;

Working with cells, rows and columns : hide columns

3. formula: Totaling rows and columns automatically

Sum(d1:d10), average(A1:A20), etc.

4. Ctrl-~ Show all the formulae

[ push ctrl and tilde at the same time, tilde is the key below

Esc or to the left of 1 ]

5. Relative and absolute references:

A1 is called relative, $A$1 is called absolute

and $A1 and A$1 is called mixed.

The difference between relative and absolute references

When you create a formula, references to cells or ranges are usually based

upon their position relative to the cell that contains the formula. In the

following example, cell B6 contains the formula =A5; Microsoft Excel finds

the value one cell above and one cell to the left of B6. This is known as a

relative referencing.

When you copy a formula that uses relative references, the references in

the pasted formula update and refer to different cells relative to the

position of the formula. In the following example, the formula in cell B6

has been copied to cell B7. The formula in cell B7 has changed to =A6, which

refers to the cell that is one cell above and to the left of cell B7.

If you don't want references to change when you copy a formula to a different

cell, use an absolute reference. For example, if your formula multiples cell

A5 with cell C1 (=A5*C1) and you copy the formula to another cell, both...