Which of the following operators is ranked first in Excel 2010?
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 | |