Which symbol is used for addition in Excel formulas?
A
* B
- C
+ D
=
Analysis & Theory
The `+` symbol is used to add numbers in Excel formulas, like `=A1+B1`.
Which operator is used for subtraction in Excel?
A
/ B
* C
- D
^
Analysis & Theory
The `-` operator is used to subtract numbers, e.g., `=A1-B1`.
Which symbol represents multiplication in Excel formulas?
A
x B
* C
# D
%
Analysis & Theory
The `*` asterisk is used for multiplication, such as `=A1*B1`.
What operator is used to divide values in Excel?
A
- B
/ C
: D
\
Analysis & Theory
The `/` forward slash is used for division, for example, `=A1/B1`.
Which operator is used for exponentiation (power) in Excel?
A
** B
^ C
% D
EXP
Analysis & Theory
The `^` caret symbol is used to raise a number to a power, e.g., `=A1^2`.
Which operator is used to calculate the remainder (modulus) in Excel?
A
% B
MOD C
REM D
#
Analysis & Theory
Excel uses the `MOD(number, divisor)` function, not the `%` symbol, to calculate remainders.
What is the result of the formula `=10+5*2`?
A
30 B
25 C
20 D
35
Analysis & Theory
Multiplication has higher precedence than addition, so `5*2` is evaluated first: `10 + 10 = 20`.
How can you change the order of operations in a formula?
A
Use square brackets B
Use curly braces C
Use parentheses `()` D
Use quotation marks
Analysis & Theory
Parentheses `()` can be used to change the order, e.g., `=(10+5)*2` results in 30.