Ask Question

Which answer shows a correctly written absolute reference?

Answers (1)
  1. 7 November, 09:17
    An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both. You will generally use the $A$2 format when creating formulas that contain absolute references. The other two formats are used much less frequent
Know the Answer?