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

QAn absolute reference is written using:

ID: #25656 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 3 views
Question Info
#25656Q 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 % sign ✔ ✖
  • B $ sign ✔ ✖
  • C & sign ✔ ✖
  • D @ sign ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

Absolute references use the $ (dollar) sign before the column letter and/or row number, like $A$1. The $ 'locks' that part of the reference.

Why the other options are incorrect:

  • Option A: The % sign is used for percentage formatting, not absolute references.
  • Option C: The & sign is used for text concatenation in Excel formulas.
  • Option D: The @ sign has other special uses in Excel but doesn't create absolute references.
 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? Cell A5 refers to: 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? To select the entire worksheet, click on: What is a spreadsheet?