Selected MCQ

Current Question
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 1
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 2
When adding two cells in a spreadsheet, which of the following represents the correct formula?
  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Correct Answer: B
Explanation:
=A1+A2 is the correct basic addition formula.
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
Which area in an Excel window allows entering values and formulas?
  • A. Title bar
  • B. Menu bar
  • C. Formula bar
  • D. Standard toolbar
Correct Answer: C
Explanation:
The Formula Bar is the dedicated area for entering and editing content.
Related Question 5
In MS Excel, a mathematical formula contains ____.
  • A. Label
  • B. Numeric Value
  • C. Both A & B
  • D. None of these
Correct Answer: C
Explanation:
Excel formulas can use both labels (cell references) and numeric values.