Welcome to Excelling with Excel

More Formulas
(there is a practice exercise at the end of this page)

Look at the formulas below and see if you understand what is happening

1. =A5-B5 (in the formula bar this would tell Excel to subtract)
2. =A3*B3 (in the formula bar this would tell Excel to multiply
3. =A4/B4 (in the formula bar this would tell Excel to divide)

Remember the operators:

1. + means add
2. - means subtract
3. * means multiply
4. / means divide

How to make this happen:

• open a workbook, on the first sheet cell A5 enter 12 and in cell B5 enter 4
• click on cell C5 and in the formula bar, type an equal sign
• THEN click on cell A5, select the subtraction symbol from the numeric keypad, click on cell B5 and then tap enter

basically it goes like this: click on the cell where you want the answer to appear, go to the formula bar and type an = sign THEN click on the cells and operators needed to make the answer appear. Tap enter when you are happy with the formula.

You can check it out in the diagram below.

More Practice
(no calculator, just Excel)
why not try some multplication, division, subtraction and addition problems?
What would the answer be to 122 times 58

• enter 122 in one cell and 58 in the next cell
• click on the cell where you want the answer to appear
• use the formula bar to enter the correct formula and tap enter when you have the formula
• NOW, for the magic of EXCEL - change the 58 to 48 and watch what happens - Excel does this automatically for you. That is why we use formulas and not calculators.
  
  What would the answer be to 1122 divided by 3
  Change the 3 to 6 - again the magic of Excel!

Learning about saving