NEW
Font size
S
M
L
XL
WorksheetsQuizziz Game - Excel Lesson 4 - Using Basic Formulas
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Which of the following is not an arithmetic operator?
a)
+
b)
-
c)
*
d)
]
2.
Per the order of operations, which of the following is calculated first?
a)
Addition (+) and subtraction (−) (left to right)
b)
Exponentiation (ˆ)
c)
Percent (%)
d)
Negative number (−)
3.
Which of the following is an acceptable name for a named range?
a)
C7
b)
subtotal_west
c)
subtotal west
d)
subtotal/west
4.
Which of the following is an example of an absolute cell reference?
a)
A9
b)
A$9
c)
$A$9
d)
A9:E9
5.
Which of the following is an example of a mixed cell reference?
a)
A9
b)
A$9
c)
$A$9
d)
A9:E9
6.
True or False? To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
a)
True
b)
False
c)
N/A
d)
N/A
7.
True or False? Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.
a)
True
b)
False
c)
N/A
d)
N/A
8.
True or False? You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.
a)
True
b)
False
c)
N/A
d)
N/A
9.
True or False? The order of operations determines which parts of a formula are calculated before other parts of the formula.
a)
True
b)
False
c)
N/A
d)
N/A
10.
True or False? The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).
a)
True
b)
False
c)
N/A
d)
N/A
Reset
