Selected MCQ

Current Question
In MS Excel 2016, a window can be split into two parts by which of the following options?
  • A. Format → Window → Split
  • B. View → Window → Split
  • C. Page Layout → Split
  • D. None
Correct Answer: B
Explanation:
Split is available in the View tab.
Related Question 1
Which of the following shortcuts is used to bring the desktop to the top of other windows?
  • A. WinKey + M
  • B. WinKey + D
  • C. WinKey + SHIFT + M
  • D. WinKey + CTRL + F
Correct Answer: B
Explanation:
Win + D shows the desktop (minimizes all windows).
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
In MS Excel 2016, = Now () is used ____.
  • A. To show the day name
  • B. To show time only
  • C. To show date and time
  • D. To show the current date and time
Correct Answer: D
Explanation:
NOW() returns the current date and time.
Related Question 4
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 5
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.