Selected MCQ

Current Question
“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.
Related Question 1
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 2
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 3
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 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
Computers that are used in large organizations such as insurance companies and banks, where many people frequently need to use same data, are ____.
  • A. Mainframe computers
  • B. Supercomputers
  • C. Hybrid computers
  • D. Desktop computers
Correct Answer: A
Explanation:
Mainframe computers are designed for high-volume data processing in large organizations.