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

QTo lock a discount rate cell for multiple items, use:

ID: #25693 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 4 views
Question Info
#25693Q 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 Relative reference ✔ ✖
  • B Absolute reference ✔ ✖
  • C Mixed reference (row only) ✔ ✖
  • D None ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

Absolute reference (like $A$1) locks the cell so that when the formula is copied to multiple product rows, all of them use the SAME discount rate from that fixed cell.

Why the other options are incorrect:

  • Option A: Relative reference would move to a different cell for each product — you'd lose the discount cell.
  • Option C: Mixed (row only) partially locks the reference but may still shift columns.
  • Option D: 'None' would leave the reference relative — not what you want here.
 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? COUNT function ignores: Which operator gives the remainder? Reference $A1 means: 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?