To edit the content of a cell

1. select the cell
2. Go to the edit box
3. Make your correction to the cell contents

OR

If you want to completely change the contents of a cell

1. Select the cell
2. Type in the new data.

If you want to use a formula you must type an = sign first. When you work with formulas use cell references. E.g. if you wanted to add the contents of two cells A2 and B2 the formula would be

=A2+B2

To multiply two cells =A2*B2

To subtract two cells =A2-B2

To divide two cells =A2/B2

There are some built in formulas such as the Sum formula, which we use later. It is important that you follow the layout of this formula exactly, or it will not work.

As an exercise we are going to put together the following spreadsheet

In the period column in the first free space enter the following formula:

=SUM(B2:F2)

In the next one down enter: =SUM(B3:F3)

In the next one down enter =SUM(B4:F4)

In the next one down enter =SUM(B5:F5)

Note that the numbers change each time. These refer to the rows, as we are going to a new row each time we change the number to match the row number.

In the TOTAL row under week1 enter the formula =SUM(B2:B5)

In the TOTAL row under week2 enter the formula =SUM(C2:C5)

In the TOTAL row under week3 enter the formula =SUM(D2:D5)

In the TOTAL row under week4 enter the formula =SUM(E2:E5)

Note that this time because we are changing columns it is the letters that change in the formulas this time.

Once you enter the formula the calculations are done automatically. If you change a figure in your spreadsheet then the totals columns change automatically. The formulas take care of that.

Finally: The profit is the total wages taken away from the sales. So the formula in the Profit row will be = B7-B6, you then repeat this across the row changing the letters as you go, so the next one is

=C7-C6 and so on.