India Exam Junction
[PSSSB Law Officer, 2026]
4. Which Excel function returns the largest value in a range?
LARGE
MAX
TOP
HIGH
Correct Answer :
MAX
Solution
The MAX function in Excel is designed to return the largest numerical value from a range of cells. The LARGE function can also be used but requires an additional argument to specify the k-th largest value (e.g., LARGE(range, 1) returns the largest value), while MAX is more direct for the absolute largest value.