0To keep a cell reference fixed to column B and row 5 when a formula is copied to other cells, it should be written as:AB5B$B5CB$5D$B$5 Correct answer: D Join the discussion Report an error Share