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: |
(A), (B), (C), (D) (A), (D), (B), (C) (B), (A), (D), (C) (C), (B), (D), (A) |
(A), (D), (B), (C) |
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. |