WorksheetsMicrosoft Excel Review Cell Referencing (2nd Form)
Total questions: 10
Worksheet time: 5mins
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?
=
*
/
+
