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

QReference $A1 means:

ID: #25703 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 6 views
Question Info
#25703Q 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 Row locked ✔ ✖
  • B Column locked ✔ ✖
  • C Both locked ✔ ✖
  • D None locked ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

$A1 has $ before A (column), locking the column. The row 1 is relative (will change when copied). So only the COLUMN is locked.

Why the other options are incorrect:

  • Option A: Row locked would be A$1 (with $ before the number).
  • Option C: Both locked would be $A$1 (with two $ signs).
  • Option D: None locked would be A1 (no $ at all).
 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: A spreadsheet consists of: What is a cell reference? What is a formula?