Selected MCQ

Current Question
Which one of the following functions is not found in MS Excel?
  • A. Max
  • B. Min
  • C. Mean
  • D. Median
Correct Answer: C
Explanation:
MEAN is not a built-in function (use AVERAGE instead).
Related Question 1
Which of the following is not one of Excel’s “what-if” functions?
  • A. Goal seek
  • B. Data Table
  • C. Scenario manager
  • D. Auto Outline
Correct Answer: D
Explanation:
Auto Outline is not a what-if analysis tool.
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
Which of the following is not a function in Microsoft Excel?
  • A. SUM
  • B. MAX
  • C. MIN
  • D. AVG
Correct Answer: D
Explanation:
AVG is not valid; the correct function is AVERAGE.
Related Question 4
With which of the following do all formulas in Excel start?
  • A. /
  • B. =
  • C. +
  • D. &
Correct Answer: B
Explanation:
Every formula in Excel must begin with the equals sign (=).
Related Question 5
Which of the following Excel features allows users to evaluate values and return a result?
  • A. Formulas
  • B. Formatting
  • C. Filters
  • D. Insertions
Correct Answer: A
Explanation:
Formulas and functions evaluate data and return results.