Arrange the following mathematical operations in the correct sequence order in which an electronic spreadsheet (MS Excel) processes equations from highest priority to lowest priority (PEMDAS/BODMAS):(A) * Multiplication(B) + Addition(C) ( ) Brackets(D) / DivisionChoose the correct answer from the options given below:
- A(A), (B), (C), (D)
- B(C), (A), (D), (B)
- C(B), (A), (D), (C)
- D(C), (B), (D), (A)
Solution & Step-by-step Explanation
Electronic spreadsheets follow strict operational hierarchies (resembling BODMAS/PEMDAS standards) to parse mathematical expressions:First Priority: Operations inside Brackets (C) are evaluated first.Second Priority: Multiplication (A) and Division (D) hold equal precedence ranks and are executed left-to-right as they appear.Third Priority: Addition (B) and Subtraction hold the lowest priority.Looking at the options, sequencing (C) (A) (D) (B) correctly mirrors this hierarchical top-to-bottom operation logic.