Concept:In spreadsheet applications, an absolute cell reference keeps both the column and the row fixed when a formula is copied.
Explanation:To make a cell reference absolute, place the dollar symbol before the column letter and also before the row number.
The given cell is G5, where G is the column and 5 is the row.
Therefore, the absolute address is written as
$G$5.
If a formula containing
$G$5 is copied to another cell, the reference still points to cell G5.
This is different from a relative cell reference, which changes according to its new position.
Answer:$G$5 (option C).