Finding Unknown Using Formula of Volume of Rectangular Box
Which of the ...
Question
Which of the following shows absolute cell reference?
[0.88 marks]
A
$C$4
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
B
C$4
No worries! We‘ve got your back. Try BYJU‘S free classes today!
C
C4$
No worries! We‘ve got your back. Try BYJU‘S free classes today!
D
$C4
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution
The correct option is A$C$4 An absolute reference in Excel refers to a reference that is ’locked’ so that the rows and columns do not change when they are copied. It is represented by adding a '$' sign before the row and column.