Without understanding this, you will not work with excel with ease.

For example: Sum (B2:F2) Coping down will increment the row 2 to 3.

You want to lock in the cell in a formula so that when you copy across or down the particular cell does not change.

Place the Insert beam in the formula before, in the middle or after the cell that needs to be locked.

Hit F4 key. This will place a signs next to the letter and row number.

For example, if you need the value in G2 and it must be used for all the rows, then you must lock it.

For example, G2 is the cell I want to use, it should look like this: G2.

If the formula is very large, you may make other typing mistakes.

Therefore, B3 becomes B4 which then becomes B5 and G2 will become G3 which then becomes G4.

The last 2 formulas will produce a zero values become something times nothing gives you ZERO.

The columns are names, salary, bonus amount and total salary (salary plus bonus).

Use small numbers rather than large ones like in the example xl sheet.

So use 100 200 300.

Take out a calculator and you the calculations.

The 15 is the constant cell and you are ALWAYS using that number.

In xl that ALWAYS cell is the ABSOLUTE cell (each of these words begin with the letter A).

In relative addressing a1 will become a2 and so forth as you autofill down.

Excel Set Ro To Relative Addressing How To Control Cookies

To find out more, including how to control cookies, see here.

Excel For Mac How To Set Macro To Relative Addressing