Relative and absolute reference

You want to create a formula that multiplies the values in column A by a constant in cell B1. If you want to copy the formula down without changing the reference to B1, which formula should you use in cell C2?

  • =A2*B1
  • =$A2*B1
  • =A2*$B$1
  • =A2*$B1