which of the following is an example of an absolute reference? c7 $b$3
which of the following is an example of an absolute reference? c7 $b$3
Answer
Brief Explanations:
In spreadsheet - related concepts, an absolute reference in Excel is indicated by the dollar sign ($). The cell reference $B$3 has dollar signs before both the column letter and the row number, which means it will not change when the formula is copied or moved. In contrast, C7 is a relative reference.
Answer:
$B$3