Moving on to editing a formula, I may realize, oh, I've got it wrong.

I didn't mean to do that. So the first way I can edit a formula is to click into the formula bar, move around with the arrow keys within that, delete what I had wrong.

So say I had typed in a 20 instead of a 2.

Then click on the correct cell, which is A2 and press enter to accept the change.

When we look at order precedents, multiplication and division are always done before plus and minus.

So let's add some extra items into this formula.

I'm going to type the three into cell A3, and I'm going to go into the formula in B4 and edit that.

I'm going to add a multiplication, so multiply asterisk sign by what's in a three, and press enter.

Let's see what has happened.

The 2 times 3 has been done first to give me 6.

Then the 10 in A1 has been added to give me 16.

There's no need to put a brackets around A2 and A3 because Excel automatically does the multiplication first.

However, if I did want the addition to happen first, then I could put brackets in.

So I would put brackets around A1 and A2.

Press enter, and we can see what has happened is the 10 plus 2 has been done first to give me 12.

That's then been multiplied by 3 to give 36.

The same is also true of exponential, brackets and exponential, both work before multiplication and division, which both work before addition and subtraction.

Lastly, I want to show how to copy a formula.

I'm going to change my formula back to what it was before.

So just delete out the multiplication and delete out the brackets.

And then what I'm gonna do is I'm going to copy that.

So I'm gonna use the ribbon.

In order to do that, I go up to the ribbon and I click on the copy icon.

I then move to the cell I want to copy to. So I'm going to move to the right and I click on the paste icon.

What's happened is that as I've copied to the right, the cells the formula was relating to have also moved to the right.

So instead of being A1 plus A2, it is now B1 plus B2.

If I were to do that again and copy down instead of to the right, if I click into my B4 formula, I copy move down and paste.

We can see that the cells that are being added have now moved down as well.

So I've got 2 plus 3 equals 5, as opposed to the 10 plus 2 equaling 12 that was using the ribbon.

Alternatively, I could have used my keyboard to copy and paste.

So if I click the cell I want to copy, then control C, move to where I want to paste, and then control V or enter.