Absolute Reference Review Lesson

SLIDESMANIA.COM

Microsoft

EXCEL -

ABSOLUTE

REFERENCING

SLIDESMANIA.COM

ABSOLUTE REFERENCE

Absolute referencing means
fixing a cell or making a cell
absolute/unchangeable within a
copied formula. As a result, no
matter where the formula is
copied, reference will always be
made to the fixed cell.

$B$2

Multiple Choice

What is an absolute reference?

• The cell reference is made fixed/unchanged when copied in a formula

• The cell reference changes when copied in a formula

Multiple Choice

What symbol is used to designate an absolute cell reference?

• *

• $

• @

• !

SLIDESMANIA.COM

situations

requiring a cell
reference to be

absolute

1. When creating formulas that
need to reference a specific cell

consistently, regardless of their
position when copied or filled.

2. When working with large datasets

and needing to refer to fixed values
like tax rates or constants.

3. When using formulas in data

analysis where you want to apply the
same reference to multiple cells in
different calculations.

Multiple Choice

All of the following scenarios EXCEPT are where absolute cell referencing can be used in Excel

• • When creating formulas that

  •  need to reference a specific cell consistently, regardless of their position when copied or filled.

• • When working with large datasets and needing to refer to fixed values like tax rates or constants.

• When using working with various cell reference that can be changed

• • When using formulas in data analysis where you want to apply the same reference to multiple cells in different calculations.

SLIDESMANIA.COM

POPULAR

EXAMPLES FOR
USING ABsOLUTE

REFERENCE

Popular examples for
using

as

absolute

values are discounts
being offered to all
clients/customers or
for all items in a
spreadsheet, interest
rates, salary increase
percentages. etc.

Multiple Choice

Absolute cell reference formula can be used to calculate the following EXCEPT

• Interest Rates

• Salary Increase

• Room Rates

• Shoe Size

SLIDESMANIA.COM

MAKING A CELL
reference
ABSOLUTE

To fix a cell in a formula,
press the f4 function key
while entering the
formula. The key must
be pressed directly after
the name of the cell
that is being fixed. An
example of a formula
with a fixed cell is =B8 *
$B$3.

1.

Multiple Choice

To fix a cell in a formula, the --------------- function key must be press while entering the formula.

• F1

• F12

• F4

• F5

Multiple Choice

Which of the following formulas includes an absolute cell reference?

• =B1/$B$25

• =B1/B25

• =B1*#B#25

• =AVERAGE(B1:B25)

Multiple Choice

$b$17 is what type of reference?

• 
  absolute

• relative

• mixed varying column

• mixed varying row