WorksheetsMS Excel: Performing Operations using Formulas and Functions
Total questions: 7
Worksheet time: 2mins
Name
Class
Date
1.
Which of the following pertains to a cell reference that moves as you copy it on a different cell?
a)
Relative
b)
Absolute
c)
Mixed
d)
Undetermined
2.
Which of these symbols is the anchor of an absolute cell reference?
a)
#
b)
&
c)
$
d)
~
3.
Which of the following cell reference is an absolute cell reference?
a)
=A14
b)
=$K$9
c)
=M$13
d)
=$P6
4.
On which of the following cells is =Summary!A1 referencing?
a)
Cell A1
b)
Cell A1 on the Summary Tab
c)
A name ranged called "Summary!A1"
d)
Something that does not exist
5.
Which of the following functions belong to the Math & Trig category? (Please Select 2)
a)
SUMIF
b)
SUM
c)
COUNTIF
d)
AVERAGE
e)
COUNTIFS
6.
Which of the following functions counts cells that are NOT BLANK?
a)
COUNTA
b)
COUNTIF
c)
COUNT
d)
COUNTBLANK
7.
Which of these functions displays the highest value within the selected cell range?
a)
HIGH
b)
LOW
c)
MAX
d)
MIN
100 %
