Selected MCQ

Current Question
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 1
If you want to add the contents of cells A1 and A2 together in Excel, which formula would you use?
  • A. =SUM(A1, A2)
  • B. #NAME?
  • C. =A1 + A2
  • D. None of these
Correct Answer: C
Explanation:
The simple addition formula =A1+A2 directly adds the two cells.
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 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 4
New line in the same cell shortcut key in Excel?
  • A. Alt + Shift
  • B. Ctrl + Enter
  • C. Alt + Enter
  • D. Shift + Enter
Correct Answer: C
Explanation:
Alt+Enter inserts a line break in the cell.
Related Question 5
____ adds new line in same cell shortcut key in Excel.
  • A. Alt + Shift
  • B. Ctrl + Enter
  • C. Alt + Enter
  • D. Shift + Enter
Correct Answer: C
Explanation:
Alt+Enter inserts a new line in the same cell.