NEW
Font size
S
M
L
XL
WorksheetsComputer Apps- Excel Formulas & Cell References
Total questions: 30
Worksheet time: 14mins
Name
Class
Date
1.
#### means you entered a formula incorrectly.
a)
True
b)
False
2.
What symbol always begins a formula?
a)
IF
b)
#
c)
=
d)
(
3.
What is the Excel symbol for multiplying?
a)
/
b)
( )
c)
X
d)
*
4.
######### means
a)
I entered the formula wrong
b)
The cell needs to be bigger
c)
hashtag, hashtag, hashtag
d)
Something is incorrect
5.
If you want to subtract two numbers in a formula, which formula would be correct?
a)
=1.2*3
b)
=e3+e7
c)
=A2-30
d)
-E7=A3
6.
This operator symbol is for what type of operation? /
a)
addition
b)
subtraction
c)
multiplication
d)
division
7.
Which of the following has a cell reference?
a)
5%
b)
=4*3.7
c)
=G4/E3
d)
sub-total
8.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Format
b)
Summations
c)
Cell
d)
Formulas
9.
=Sum(A5:A10)
a)
Formula
b)
Function
10.
Excel uses the Order of Operations
a)
True
b)
False
11.
The Order of Operations means to do what first?
a)
section in Parentheses
b)
subtraction
c)
work from left to right
d)
addition
12.
What is the main purpose of using cell references when doing formulas & functions?
a)
So you don't have to redo the math if something changes
b)
It feels fancier therefore you're smarter
c)
It's the ONLY way to get the right math answer
d)
Confuse students in Info Tech class
13.
Which of the following formulas includes an absolute cell reference?
a)
=B1/$B$25
b)
=B1/B25
c)
=B1*#B#25
d)
=AVERAGE(B1:B25)
14.
What symbol is used to designate an absolute cell reference?
a)
$
b)
!
c)
@
d)
#
15.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
16.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
17.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
18.
What is this: =4*D5
a)
cell
b)
equation
c)
formula
d)
operator
19.
Which of the following is a CORRECTLY keyed formula?
a)
A1=A2
b)
7+3
c)
=7+3
d)
==A1/A2
20.
Which of the following is an INCORRECTLY typed formula?
a)
=A1/A6
b)
=8*4
c)
A1/A2=
d)
=SUM(A1:A4)
21.
A prewritten formula built into Excel
a)
Function
b)
Formula
c)
Operation
d)
Cell
22.
$b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
23.
b17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
24.
$b17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
25.
b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
26.
In the formula =A4*B2^3-F14, which operation is done first?
a)
*
b)
^
c)
-
d)
+
27.
The formula that multiplies the contents of cell B4 by 18.5
a)
18.5*b4
b)
=18.5*b4
c)
18.5*b4=
d)
18.5(b4)
28.
=MAX(A4:G8)
a)
Function
b)
Formula
29.
=AVG(C14:H14)
a)
Function
b)
Formula
30.
=10*C4
a)
Function
b)
Formula
Reset
