Question

question 1\
excel follows pemdas. what does excel evaluate first in the formula =a1-b1/c1?\
□ a1 - c1\
□ a1 - b1\
□ a1 / b1\
□ b1 / c1

Explanation:

PEMDAS (Parentheses, Exponents, Multiplication and Division, Addition and Subtraction) dictates the order of operations. In the formula \(=A1 - B1/C1\), division (\(B1/C1\)) has higher precedence than subtraction (\(A1 - \) the result of \(B1/C1\)). So Excel evaluates \(B1/C1\) first.

Answer:

D. B1 / C1