Sp00kyAsianBread
Answered

NEED HELP AGAIN

When you see the =C7*$B$3 formula, what will happen when it is copied to the cell directly below the active cell using the fill handle?
    
  A. Both cell references will remain the same.

  B. The C7 cell reference will remain the same and $B$3 will increase to $B$4.

  C. The C7 cell reference will increase to C8 and $B$3 will increase to $B$4.

  D. The C7 cell reference will increase to C8 and $B$3 will remain the same.
 

Answer :

the answer to the question is D)

Answer:

D. The C7 cell reference will increase to C8 and $B$3 will remain the same.

Explanation:

When you have a formula in a cell that you need to put in the ones below that one, you have the option to drag the fill handle into the cells you need.  This will make the formula to appear in those cells and it will change according to the number of the row. However, if you need that one or more value to remain the same, you have to put a dollar sign before the letter and another one before the number to lock them so when you drag the formula, those values won't change. So, acording to this, when you see the =C7*$B$3 formula and it is copied to the cell directly below the active cell using the fill handle, the C7 cell reference will increase to C8 and $B$3 will remain the same.

Other Questions