The arithmetic operations which we perform by using spreadsheets follow what order of mathematical (expression) operations rules?
(A) Brackets
(B) Division or multiplication
(C) Addition and subtraction
(D) Exponents
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 2
Correct answer: Option (2) → (A), (D), (B), (C)
Concept: Order of mathematical operations (operator precedence / BODMAS) in a spreadsheet, from Spreadsheet.
A spreadsheet evaluates an expression in this order: (A) Brackets first, then (D) Exponents, then (B) Division or Multiplication (equal priority, left to right), and finally (C) Addition and Subtraction. Hence A, D, B, C.