Selected MCQ

Current Question
MOD() function is used in MS Excel to get ____.
  • A. Dividend
  • B. Remainder
  • C. Quotient
  • D. None of these
Correct Answer: B
Explanation:
MOD returns the remainder (modulus) of a division.
Related Question 1
Which function is used to find the related data in MS Excel?
  • A. VLOOKUP
  • B. FLOOKUP
  • C. RLOOKUP
  • D. HLOOKUP
Correct Answer: A
Explanation:
VLOOKUP searches vertically for related data.
Related Question 2
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 3
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.
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.