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

QFormula =A1*$B$1 uses:

ID: #25696 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25696Q 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 Only relative ✔ ✖
  • B Only absolute ✔ ✖
  • C Mixed (one absolute) ✔ ✖
  • D Only text ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

This formula uses A1 (relative) AND $B$1 (absolute) combined. Since it mixes both reference types in one formula, it's a mixed usage.

Why the other options are incorrect:

  • Option A: 'Only relative' would be =A1*B1, without the $ signs.
  • Option B: 'Only absolute' would be =$A$1*$B$1, with $ on both.
  • Option D: The formula uses cell references, not text.
 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?