Selected MCQ

Current Question
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 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 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 3
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 4
Actual working area of Computer's Microsoft Excel is ____.
  • A. Workbook
  • B. Worksheet
  • C. Notesheet
  • D. Notebook
Correct Answer: B
Explanation:
The worksheet (spreadsheet) is the actual working area in Excel.
Related Question 5
Which function calculates the largest value in a set of numbers in Excel?
  • A. Average
  • B. Count
  • C. Minimum
  • D. Maximum
Correct Answer: D
Explanation:
The MAX function returns the largest value in a range.