Question

Q3: If you copy the formula =$B38 into another cell, the result will be:
A: The column part will remain the same
B: The row part will remain the same
C: Both the column and row will remain the same
D: Both will change

Answer 1

Answer:

Answer is A

Explanation:

Please mark me as a brainliest

Answer 2

Answer:

The correct answer is option A

Explanation:

• First of all, SB38 is not a formula, and neither is $B38 if that is what you mean. It needs to have an equals sign before it. If it does, then it depends on where it is copied as to what the new formula will be. If it is =SB38 then there are lots of ways it will change. If it is $B38, then the B will not change wherever it is copied, but the 38 will.
• The $ put in front of the column or row row part of a cell address will freeze that part of the address. For the $B38 cell address, it's the B column that will remain the same. This option is very practical when you wish to copy a formula but keep the same cell references. You have to think if you need to freeze the column if you wish to copy the formula horizontally. The same can be said for the row reference if you wish to copy the formula vertically.

Learn more about information about the excel:

• https://brainly.in/question/15229950
• https://brainly.in/question/22516619