contestada

Using a $ sign before a column label ________.

a. keeps the reference to the row fixed,
b. but allows the column reference to change keeps the reference to column fixed,
c. but allows the row reference to change allows both the row and column references to change
d. keeps the reference to both the row and column fixed

Respuesta :

beritop1089

Answer:

The alignment of the choices are off but here's the explanation for solving this question below;

Explanation:

Using a $ sign before a column label, keeps the reference to column fixed,

but allows the row reference to change. Generally, putting a dollar sign ($) before a column label or row label  puts an absolute reference to that respective column or row while keeping the other changing. For example;

In $C5, "C"  is the column reference while "5" is the row reference. Because there is $ sign before C, that column  will be fixed and the row will change

Baraq

Every sign or symbol depicts certain purpose of notation. Hence, the above sign before a column label does this:

  • a. keeps the reference to the row fixed,

Uses of the sign

Using a $ sign before a column label keeps the reference to column fixed but allows the row reference to change. -Using a $ sign before both the row and column labels keeps the reference to cell fixed no matter where the formula is copied.

Therefore, the answer is as given above.

learn more about Microsoft Excel from here: https://brainly.com/question/1538272

Otras preguntas