Question

You would like the cell reference in a formula to remain the same when you copy

it from cell A9 to cell B9. This is called a/an _______ cell reference.
a) absolute
b) active
c) mixed
d) relative

Answer 1

A is the right option absolute

Answer 2

The answer is:

A) Absolute cell reference

Step-by-step explanation:

An absolute cell reference is used in Excel when you want to keep a specific cell reference constant in a formula, regardless of where the formula is copied. Absolute cell references in a formula are identified by the dollar sign ($) before the column letter and row number.

Hope this helped you!! Have a good day/night!!