Microsoft Excel Review Cell Referencing (2nd Form)

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?

• =

• *

• /

• +