Excel Basic Formulas and Operators – Learn Excel Step by Step - Lesson 38

Social Media Point
FREE COMPUTER DIPLOMA
Module 7 – Lesson 38

Basic Formulas and Operators in MS Excel

Master Automatic Calculations, Mathematical Operators, Cell References, Order of Operations, Parentheses, and Practical Expense Sheets

1. What is an Excel Formula?

A formula is an instruction used to perform calculations in Excel. A formula can contain numbers, cell references, mathematical operators, and functions.

Important rule: Every Excel formula must begin with an equal sign (=).

For example, type =10+20 in a cell and press Enter. Excel displays the result 30.

2. Using Cell References in Formulas

Instead of typing numbers directly, you can use cell references. Excel calculates using the values stored in those cells.

CellValue
A1100
B150

Enter =A1+B1 in cell C1. Excel displays 150.

3. Basic Mathematical Operators

OperatorMeaningExampleResult
+Addition=10+515
-Subtraction=10-55
*Multiplication=10*550
/Division=10/52
^Power=2^38
%Percentage=50*10%5

4. Addition Formula

The plus sign (+) adds values.

Example: If A1 contains 100 and B1 contains 200, enter:

=A1+B1
Result: 300

5. Subtraction Formula

The minus sign (-) subtracts one value from another.

=A1-B1
If A1 is 500 and B1 is 150, the result is 350.

6. Multiplication Formula

The asterisk (*) is used for multiplication in Excel.

=A1*B1
If A1 is 20 and B1 is 5, the result is 100.

7. Division Formula

The forward slash (/) divides one value by another.

=A1/B1
If A1 is 100 and B1 is 4, the result is 25.

Note: Dividing by zero causes a #DIV/0! error.

8. Percentage Formula

To calculate a percentage, divide the obtained value by the total value and format the result as a percentage.

Example: A student obtains 400 marks out of 500.
Formula: =400/500
Result: 0.8, or 80% when formatted as Percentage.

9. Order of Operations

Excel follows the mathematical order of operations. Multiplication and division are performed before addition and subtraction unless parentheses change the order.

FormulaResultExplanation
=10+5*2205 × 2 first, then add 10
=(10+5)*230Parentheses first, then multiply

10. Using Parentheses

Parentheses help control the order of calculations.

For example, =(A1+B1)*C1 adds A1 and B1 first, then multiplies the result by C1.

11. Practical Exercise

Create the following expense sheet in Excel:

ItemQuantityPriceTotal
Notebook5100500
Pen1020200
File450200
  1. Enter the headings in cells A1:D1.
  2. Enter the items and their quantities and prices.
  3. In D2, enter =B2*C2.
  4. Copy the formula down to D3 and D4.
  5. In D5, enter =D2+D3+D4 to calculate the total expense.
  6. Save the file as Basic Formulas Practice.xlsx.

12. Lesson Summary

  • Excel formulas begin with =.
  • + adds, - subtracts, * multiplies, and / divides.
  • ^ calculates powers and % represents percentages.
  • Cell references can be used instead of typing numbers.
  • Parentheses control the order of calculations.

13. Test Your Knowledge – Interactive MCQs

Enter your name and select your answers. Each answer locks immediately with instant feedback.

Basic Formulas and Operators – Online MCQ Test

10 Questions | 10 Marks | One-Time Selection

Answered: 0 / 10 Questions Live Score: 0 / 10

Final Test Result

Congratulations! You have completed Lesson 38. Continue to Lesson 39 to advance further in your Excel diploma program.

© Social Media Point | Free Digital Education

Previous Post Next Post