Selected MCQ

Current Question
The ____ function in Excel returns the highest value in a set of data that you specify.
  • A. MAX
  • B. AVG
  • C. LRG
  • D. None of these
Correct Answer: A
Explanation:
MAX returns the largest value in a range.
Related Question 1
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 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 function in Excel returns the remainder of a division?
  • A. Divide
  • B. MOD
  • C. ACOT
  • D. None of these
Correct Answer: B
Explanation:
MOD returns the remainder after division.
Related Question 5
In MS Excel, which function automatically totals a column or row of values?
  • A. Total
  • B. ADD
  • C. SUM
  • D. AVG
Correct Answer: C
Explanation:
SUM is the dedicated function for totaling values.