Selected MCQ

Current Question
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 1
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 2
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 3
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 4
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 5
“IF function” typically refers to a function used in ____.
  • A. Programming
  • B. Mathematics
  • C. Spreadsheets
  • D. Databases
Correct Answer: C
Explanation:
The IF function is a built-in logical function in spreadsheet software like Excel.