Selected MCQ

Current Question
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 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
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 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
What is the function of the IF function in Excel?
  • A. To perform a logical test and return a value based on the result
  • B. To add up a range of cells
  • C. To find the average of a range of cells
  • D. To count the number of cells in a range
Correct Answer: A
Explanation:
The IF function performs a logical test and returns one value if true, another if false.