What is the role of **parentheses `()`** in Excel formulas?
B
To group operations and control order of execution
Analysis & Theory
Parentheses are used to **group expressions** and control the **order of operations** in formulas.
What will the result of `=5 + 2 * 3` be in Excel?
Analysis & Theory
Excel follows standard math rules: multiplication first, then addition: `2 * 3 = 6`, `5 + 6 = 11`.
What will the result of `=(5 + 2) * 3` be in Excel?
Analysis & Theory
`(5 + 2)` evaluates first (7), then `7 * 3 = 21`.
Which of the following Excel formulas demonstrates proper use of parentheses?
C
=IF(A1>10, "Yes", "No")
Analysis & Theory
`=IF(A1>10, "Yes", "No")` has correct and complete parentheses usage.
What error might occur if you forget a closing parenthesis in a formula?
D
Excel shows a tooltip asking to correct the formula
Analysis & Theory
Excel will prompt you to correct the formula if parentheses are mismatched or missing.
Which of these formulas uses **nested parentheses**?
B
=IF(A1>10, SUM(B1:B5), 0)
D
=AVERAGE((A1 + B1) / 2)
Analysis & Theory
`=IF(A1>10, SUM(B1:B5), 0)` has a function `SUM` inside the `IF`, so it uses nested parentheses.
Why is it important to use parentheses when combining different operations in Excel?
C
To control the calculation order
Analysis & Theory
Parentheses **override the default operator precedence**, ensuring calculations happen in the intended order.
Which formula correctly multiplies the sum of A1 and B1 by C1?
Analysis & Theory
`(A1 + B1)` ensures addition happens before multiplying by `C1`.
What does the formula `=((A1 + B1) * (C1 - D1))` do?
A
Adds all values together
C
Multiplies the sum of A1 and B1 by the difference of C1 and D1
Analysis & Theory
`(A1 + B1)` and `(C1 - D1)` are evaluated first, and then multiplied together.
What will Excel return for `=(2 + 3) * (4 + 1)`?
Analysis & Theory
`(2 + 3) = 5` and `(4 + 1) = 5`, so `5 * 5 = 25`.