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:

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

The correct answer is option 2- (C), (A), (D), (B).

Order of mathematical operations in solving data in electronic spreadsheet:

(C) () Brackets

(A)* Multiplication

(D) / Division

(B) + Addition

Order of mathematical operations (expressions)-

Computer math uses the rules of Algebra. Any operation(s) contained in brackets will be carried out first followed by any exponents. After that, Excel considers division or multiplication operations to be of equal importance, and carries out these operations in the order they occur left to right in the equation. The same goes for the next two operations – addition and subtraction. They are considered equal in the order of operations. Whichever one appears first in an equation, either addition or subtraction is the operation carried out first.