Selected MCQ

Current Question
Which symbol is used for an Excel cell reference?
  • A. +
  • B. $
  • C. !
  • D. None of these
Correct Answer: B
Explanation:
The dollar sign ($) is used to create absolute cell references.
Related Question 1
Which key is used to edit the selected cell in Excel?
  • A. F4
  • B. F10
  • C. F2
  • D. Edit
Correct Answer: C
Explanation:
The F2 key activates edit mode for the selected cell in Excel.
Related Question 2
If a formula references a cell that contains text instead of a numerical value, what error does Excel display?
  • A. #NUM!
  • B. #VALUE!
  • C. #REF!
  • D. #DIV/0!
Correct Answer: B
Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.
Related Question 3
Which of the following methods cannot be used to enter data in an MS Excel cell?
  • A. Pressing the Esc key
  • B. Clicking the formula bar
  • C. Pressing an arrow key
  • D. Pressing the Tab key
Correct Answer: A
Explanation:
Esc cancels editing; the other keys confirm or move after entry.
Related Question 4
In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?
  • A. Absolute reference
  • B. Relative reference
  • C. Mixed reference
  • D. Circular reference
Correct Answer: A
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.
Related Question 5
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.