| S/N | ARITHMETIC OPERATOR | FIRST NUMBER | SECOND NUMBER | RESULT |
| 1 | Addition (+) | 13 | 3 | 16 |
| 2 | Subtraction (-) | 21 | 9 | 12 |
| 3 | Division (/) | 33 | 12 | 2.75 |
| 4 | Multiplication (*) | 7 | 3 | 21 |
Let’s now use Microsoft excel to achieve the above results
Create a folder on your computer in my documents folder and give it a name Excel Tutorials
For this tutorial, we will be using Microsoft Excel 2013. The good news is even if you have Microsoft Excel 2007 or 2010, you will still be able to follow the tutorial and get the same result.
Open Excel. You will get a window similar to the one shown below. The outlook of Excel will depend on your version.
- Enter the data in your worksheet as shown in the image above.
- We will now perform the calculations using the respective arithmetic operators. When performing calculations in Excel, you should always start with the equal (=) sign.
- Let’s start with the one for addition. Write the following formula in E2 Excel (Result column)
- =C2+D2
HERE,
- “=” tells Excel to evaluate whatever follows after the equal sign
- “C2” is the cell address of the first number given by C representing the column letter and 2 representing the row number
- “D2” is the cell address of the second number given by D representing the column letter and 2 representing the row number
Press enter key on the keyboard when done. You should get 16 as the result.
Tutorial exercise 1
Using the knowledge gained in the above example, try to write the formulas for subtraction, division, and multiplication.
