Selected MCQ

Current Question
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.
Related Question 1
In MS Excel, which bar is used for formula and data writing?
  • A. Menu bar
  • B. Title bar
  • C. Formula bar
  • D. None of these
Correct Answer: C
Explanation:
The Formula Bar is where you view and edit formulas and cell data.
Related Question 2
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 3
Ctrl+Shift+1 shortcut Keys in excel are used to ____.
  • A. Format the number in comma format
  • B. Format number in currency format
  • C. Format number in date format
  • D. Format number in time format
Correct Answer: A
Explanation:
Ctrl + Shift + 1 applies comma number formatting in Excel.
Related Question 4
Which key is used to edit the selected cell in Excel?
  • A. F4
  • B. F10
  • C. F2
  • D. Edit
Correct Answer: C
Explanation:
The F2 key activates edit mode for the selected cell in Excel.
Related Question 5
Which key is used for help in MS Excel?
  • A. F1
  • B. F2
  • C. F3
  • D. None of these
Correct Answer: A
Explanation:
F1 key opens the Help menu in Excel.