Selected MCQ

Current Question
Which keyword is used to find the number of values in a column?
  • A. Total
  • B. Add
  • C. Count
  • D. Sum
Correct Answer: C
Explanation:
The COUNT function tallies the number of numeric values in a range.
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
What is the maximum number of columns that can be inserted in MS Word Table?
  • A. 35
  • B. 45
  • C. 55
  • D. 63
Correct Answer: D
Explanation:
A Word table can have a maximum of 63 columns.
Related Question 3
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 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
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.