WHICH EXCEL CELL REFERENCE DOES NOT CHANGE WHEN COPIED

O Level Online Exam

NIELIT O Level Exam

Which Excel cell reference does not change when copied?

Copy करने पर कौन-सा Excel cell reference नहीं बदलता है?

A. Partial

B. Relative

C. Mixed

D. Absolute

Correct Answer is :

D. Absolute

Explanation

An absolute reference such as $A$1 remains fixed when copied.

$A$1 जैसी Absolute Reference copy करने पर नहीं बदलती।