Selected MCQ

Current Question
MS Excel will not be able to calculate which of the following formulae?
  • A. =SUM(Sales)-A5
  • B. =SUM(A1:A5)/5
  • C. =SUM(A1:A5)*(10)
  • D. =SUM(A1:A5)-10
Correct Answer: A
Explanation:
“Sales” is not a valid cell reference or defined name, so Excel cannot calculate it.
Related Question 1
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.
Related Question 2
After creating the table, which of the following is correct?
  • A. Fields cannot be deleted
  • B. Fields cannot be added, but only once
  • C. Fields cannot be deleted
  • D. None of these
Correct Answer: D
Explanation:
After the table is created, fields can normally be added or deleted.
Related Question 3
Which of the following pane is not available in the Task Pane of PowerPoint?
  • A. Task Pane
  • B. Web Pane
  • C. Word Art
  • D. Search result
Correct Answer: C
Explanation:
Word Art is inserted as an object, not shown as a task pane.
Related Question 4
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 5
What formula is used to calculate monthly mortgage payments in Excel?
  • A. PMT
  • B. GMT
  • C. PST
  • D. None of these
Correct Answer: A
Explanation:
PMT is a financial function that calculates the periodic payment amount.