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

QA mixed reference has:

ID: #25661 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25661Q 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 Both column and row locked ✔ ✖
  • B One of column or row locked ✔ ✖
  • C Nothing locked ✔ ✖
  • D Two sheets locked ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

A mixed reference locks EITHER the column OR the row (not both). Examples: $A1 locks only column A, while A$1 locks only row 1.

Why the other options are incorrect:

  • Option A: Both column AND row locked is an Absolute reference ($A$1), not a Mixed one.
  • Option C: Nothing locked is a Relative reference (A1), not Mixed.
  • Option D: 'Two sheets locked' isn't a valid concept — references lock rows or columns, not sheets.
 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: