Question

IV
and
a. AVERAGE
b. MAX
*. If you copy the formula =$B7 to another cell, which of these options will you observe in
result?
a. The row part remains the same.
The column part remains the same.
both row and column parts remain the same.
row and column parts change.
d. Both row as​

Answer 1

The column part remains the same as you have made the column part constant by adding dollar sign $