Selected MCQ

Current Question
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 1
Which key is used for Find in Excel?
  • A. CTRL+C
  • B. CTRL+F
  • C. ALT+SHIFT+D
  • D. ALT+SHIFT+F
Correct Answer: B
Explanation:
Ctrl+F opens the Find dialog in Excel.
Related Question 2
Which function is used to find the string length in “FPSC,” and answers “4”?
  • A. Len(“FPSC”)
  • B. Length(“FPSC”)
  • C. Str(FPSC)
  • D. None of these
Correct Answer: A
Explanation:
The Len() function returns the number of characters in a string.
Related Question 3
Which is used for arranging data in ascending and descending order in MS Excel?
  • A. Data, Order
  • B. Data, all
  • C. Data, Sort
  • D. None of these
Correct Answer: C
Explanation:
The Sort command arranges data in ascending or descending order.
Related Question 4
The “Count” function is used to find which type of cells?
  • A. Numeric cells
  • B. Alphanumeric cells
  • C. Non-empty cells
  • D. None of these
Correct Answer: A
Explanation:
COUNT works only on numeric cells.
Related Question 5
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.