Order of mathematical operations in solving data in electronic spreadsheet:
(A)* Multiplication
(B) + Addition
(C) () Brackets
(D) / Division
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → (C), (A), (D), (B)
Excel follows the order of operations of algebra, set out in the book as BEMDAS:
(C) ( ) Brackets
(A) * Multiplication
(D) / Division
(B) + Addition
Multiplication and division carry equal weight and are worked from left to right as they appear in the formula; both come after brackets and before addition.
NCERT (2026-27 edition):
|
