14
QuizMultiple Choice

Create a Presentation — Unit test

Question 14 • Introduction to Information Technology - EL3701

Which of the following is true of operations within a spreadsheet program’s built-in functions?

Answer
A
Operations within parentheses, then multiplication and division, and then addition and subtraction are computed.
B
Operations within parentheses, then addition and subtraction, and then multiplication and division are computed.
C
Multiplication and division, then addition and subtraction, and then operations within parentheses are computed.
D
Addition and subtraction, then multiplication and division, and then operations within parentheses are computed.

Explanation

Spreadsheet formulas follow the usual order of operations: calculations inside parentheses are done first, followed by multiplication and division, then addition and subtraction. Therefore, the true statement is “Operations within parentheses, then multiplication and division, and then addition and subtraction are computed.”

AI-written and checked against the verified answer.

Previous
Next