Spreadsheet - Functions and Charts › MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet › Question #25662
Single Choice Moderate

Q$A1 is:

ID: #25662 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 4 views
Question Info
#25662Q ID
ModerateDifficulty
MCQ Quiz - Chapter Summary - Class 8 - SpreadsheetTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Absolute reference ✔ ✖
  • B Relative reference ✔ ✖
  • C Mixed reference (column absolute) ✔ ✖
  • D Range ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

$A1 has the column locked with $ (column A is fixed), but the row 1 is relative (will change). This makes it a Mixed reference with column absolute.

Why the other options are incorrect:

  • Option A: Absolute reference has $ before BOTH parts ($A$1).
  • Option B: Relative reference has NO $ signs (A1).
  • Option D: A range is multiple cells (A1:B5), not a single cell reference.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which is a spreadsheet program? Which operator gives the remainder? COUNT function ignores: Which key toggles reference types in Excel? A range of cells from A1 to A5 is written as: Which key is held to select non-adjacent cells? Cell A5 refers to: What is a cell reference? What is a formula? Reference $A1 means: