What effect does changing a cell reference from 'C5' to '$C5' have when a formula is copied to another cell?

Question

Computer Science · MS Excel

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

The column reference is absolute, but the row is relative

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on MS Excel?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · MS Excel

Which of the following territories was annexed by Lord Dalhousie under the pretext of misgovernance, and not directly through the Doctrine of Lapse?

What was the primary stated reason for the Partition of Bengal in 1905 by Lord Curzon?

Answer 1

The row reference is absolute, but the column is relative

Answer 2

Both the column and row references become absolute

Answer 3

The column reference is absolute, but the row is relative

Answer 4

Both the column and row references remain relative

Related Practice Questions