wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
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.

flag
Suggest Corrections
thumbs-up
2
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Finding Unknown using Formula of Volume of Rectangular Box
MATHEMATICS
Watch in App
Join BYJU'S Learning Program
CrossIcon