Home › MCQs › Basic Computer/IT › Question #11510
Back to Questions
Basic Computer/IT QUESTION #11510
Question 1
Which function in spreadsheet software returns the highest value in a specified range?
  • Average
  • Count
  • Minimum
  • Maximum✔️
Correct Answer Explanation
The MAX function in MS Excel returns the largest value from a set of numbers. Syntax: =MAX(A1:A10). Related functions: MIN (smallest), AVERAGE (mean), COUNT (count of numeric values), LARGE (kth largest value). MAX ignores text and logical values by default.