WorksheetsExcel Cell Reference
Total questions: 26
Worksheet time: 16mins
In the picture, why is D2 through D5 placed in parenthesis?
So Excel knows to total the cells before performing the next operation.
So the total of the cells can be multiplied rather than added.
So the calculation will be done last.
Which response best completes the following statement: A formula is used to
perform calculations or other actions.
find averages.
Look Up data
The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.
total
Sum
percentage
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
$
&
#
In the formula = A$1 * C3 which of the following is the MIXED CELL Reference found in that formula?
*
=
A$1
C3
In the formula =C4*$C$2 which of the following is the ABSOLUTE CELL REFFERENCE found in that formula?
=
C4
*
$C$2
In the formula =B5*$C$2 which of the following is the RELATIVE CELL REFERENCE found in that formula?
$C$2
B5
=
*
A ________________ in Excel is a reference where either the column letter or a row number is fixed. For example, $A1 and A$1 are mixed references.
Relative Cell Reference
Absolute Cell Reference
Mixed Cell References
Abnormal Cell References
$C$2 is an example of a _____________ Cell Reference.
Absolute
Mixed
Relative
locked
What symbol is used in order to make a cell reference an ABSOLUTE CELL REFERENCE?
$
%
?
=
_________________do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.
Relative Cell Reference
Absolute Cell Reference
Mixed Cell References
Abnormal Cell References
Basic cell references that adjust and change when copied especially when using AutoFill.
Absolute Cell Referencing
Relative Cell Referencing
Mixed Cell Referencing
Dynamic Cell Referencing
Which of the following would represent a RANGE of cells?
C1: C9
C1, C2, C3
C1, C8
D1
Which of the following symbols is used to divide in Microsoft Excel?
=
*
/
+
