Target Exam

CUET

Subject

Accountancy Part C

Chapter

Spreadsheet

Question:

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:

Options:

(A), (B), (C), (D)

(A), (D), (B), (C)

(B), (A), (D), (C)

(C), (B), (D), (A)

Correct Answer:

(A), (D), (B), (C)

Explanation:

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.