Selected MCQ

Current Question
What does the =Proper(TEXT) function do in MS Excel?
  • A. First letter of each word is capitalized
  • B. First letter of the sentence is capitalized
  • C. All letters are capitalized
  • D. None of the above
Correct Answer: A
Explanation:
PROPER converts the first letter of each word in a text string to uppercase.
Related Question 1
What is the function of the IF function in Excel?
  • A. To perform a logical test and return a value based on the result
  • B. To add up a range of cells
  • C. To find the average of a range of cells
  • D. To count the number of cells in a range
Correct Answer: A
Explanation:
The IF function performs a logical test and returns one value if true, another if false.
Related Question 2
Which function calculates the largest value in a set of numbers in Excel?
  • A. Average
  • B. Count
  • C. Minimum
  • D. Maximum
Correct Answer: D
Explanation:
The MAX function returns the largest value in a range.
Related Question 3
Which of the following is not one of Excel’s “what-if” functions?
  • A. Goal seek
  • B. Data Table
  • C. Scenario manager
  • D. Auto Outline
Correct Answer: D
Explanation:
Auto Outline is not a what-if analysis tool.
Related Question 4
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 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.