Which of the following is an absolute cell reference ?A!B!1B$B$1C#b#1DB1 Correct answer: B Explanation$B$1 has fixed column and row, so it is an absolute reference. Join the discussion Report an error