Selected MCQ

Current Question
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.
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
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 3
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 4
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 5
To add Equation in the cell of the MS-Excel, we put ____ first.
  • A. Addition sign
  • B. Subtraction sign
  • C. Equal sign
  • D. Parenthesis sign
Correct Answer: C
Explanation:
All formulas begin with the equal sign (=).