Selected MCQ

Current Question
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 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
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 of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 4
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 5
Functional Dependencies are the types of constraints that are based on ____.
  • A. Key
  • B. Key revisited
  • C. Superset key
  • D. None of these
Correct Answer: A
Explanation:
Functional dependencies are constraints that describe how one set of attributes determines another, typically based on keys.