Question: Which of the following operators is ranked first in Excel 2010?
A Addition (+)
B Subtraction (-)
C Multiplication (×)
D Brackets ( )
Answer: Brackets ( )
| Operator |
Description |
Example |
Operator Precedence in Excel |
| 1. |
Brackets ( ) |
Expressions within brackets are evaluated first. |
(A1 + B1) × (C1 – D1) |
Follows BODMAS Rule
|
| 2. |
Exponentiation (^) |
Exponents are calculated next. |
A12 |
| 3. |
Multiplication (×) |
Multiplication takes precedence over addition and subtraction. |
A1 ×B1 |
| 4. |
Division (/) |
Division is calculated before addition and subtraction. |
A1 / B1 |
| 5. |
Addition (+) |
Addition is evaluated after multiplication and division. |
A1 + B1 |
| 6. |
Subtraction (-) |
Subtraction comes last in the order of operations. |
A1 – B1 |
