Multiple choice technology

The sales tax rate is in cell H2. Sales totals are in cells B2:B20. To calculate the tax on each sale, you'll enter a formula in cell C2, to multiply the sales total in B2, by the sales tax rate. Then, you'll copy the formula down to cell B20. Which formula should you use?

  1. =B2*$H$2
  2. =$B$2*$H$2
  3. =B$2*$H$2

  4. =B2*H2
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To copy a formula down while keeping one reference fixed, use absolute referencing with dollar signs. $H$2 anchors the tax rate so it doesn't change when copied, while B2 changes to B3, B4, etc. Options B and C incorrectly anchor B2 (which should change), and D lacks absolute referencing so H2 would also change.

Keep practicing — related questions