PREMIUM
πŸ“š FPSC SST 2026 Preparation Group
Join Our WhatsApp Group for SST Past Papers & Mock Tests
βœ… Daily MCQs β€’ πŸ’‘ Expert Tips β€’ πŸ“š Past Paper Discussion
Join Group β†’

Which of the following is a valid mixed cell reference?

A. $A$1
B. A1
C. $A1
D. $1A
Correct Answer: C. $A1

A mixed cell reference in Microsoft Excel fixes either the row or the column, but not both. This is done by placing the $ symbol before either the column letter or the row number.

  • $A$1 – Absolute reference (both row and column fixed).
  • A1 – Relative reference (both row and column change).
  • $A1 – Mixed reference (column fixed, row relative). βœ”
  • $1A – Invalid cell reference.

Therefore, the correct answer is: $A1.

0 comments

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top