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.  A1^{2}  
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 