Formulas: Operators (+,-,*,/) MCQs Quiz | Class 9

Understanding Basic Formulas and Operators in Spreadsheets

In spreadsheet applications like Microsoft Excel or Google Sheets, formulas are expressions that perform calculations on values in your worksheet. A formula always starts with an equals sign (=). The fundamental building blocks of most formulas are arithmetic operators, which allow you to perform basic mathematical calculations like addition, subtraction, multiplication, and division.

Key Concepts of Spreadsheet Formulas

1. Starting a Formula

Every formula in a spreadsheet must begin with an equals sign (=). This tells the application that the contents of the cell should be calculated. If you forget the equals sign, the spreadsheet will treat your entry as simple text.

• Correct: =10+5 (This will display the result, 15)
• Incorrect: 10+5 (This will display the text “10+5”)

2. Arithmetic Operators

These are the symbols used to perform calculations. The four basic arithmetic operators are:

3. Using Cell References

Instead of typing numbers directly into a formula (which is called “hard-coding”), it’s more powerful to use cell references. A cell reference is the address of a cell, like A1, B2, or C5. When you use a cell reference, the formula will use the value currently in that cell. If the value in the cell changes, the formula’s result will automatically update.

• If cell A1 contains the number 50 and cell B1 contains 25:
• The formula =A1+B1 would result in 75.
• The formula =A1/B1 would result in 2.

4. Order of Operations (BODMAS/PEMDAS)

Spreadsheets follow a standard mathematical order of operations to evaluate formulas with multiple operators. This is often remembered by acronyms like BODMAS (Brackets, Orders, Division, Multiplication, Addition, Subtraction) or PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction).

• Multiplication (*) and Division (/) are performed before Addition (+) and Subtraction (-).
• For example, in the formula =10+5*2, the multiplication (5*2) is done first, resulting in 10. Then the addition (10+10) is done, giving a final result of 20.
• You can use parentheses () to control the order. For example, =(10+5)*2 would first calculate the part in parentheses (10+5=15), and then multiply by 2, giving a final result of 30.

Quick Revision Points

• All formulas must start with an equals sign (=).
• The plus sign (+) is for addition.
• The minus sign (-) is for subtraction.
• The asterisk (*) is for multiplication.
• The forward slash (/) is for division.
• Use cell references (e.g., A1, B2) to make formulas dynamic.
• Use parentheses () to control the order of calculations.

Extra Practice Questions

1. Write a formula to add the values in cells A1, B1, and C1.
2. Write a formula to find the average of the values in cells A2 and B2 (hint: add them first, then divide by 2).
3. If A3 contains 100 and B3 contains 20, what is the result of the formula =A3-B3*4?
4. Write a formula to multiply the value in cell C5 by 10 and then add 50 to the result.
5. What is the difference between entering 5*10 and =5*10 into a cell?