Correct Answer:
B. Max ( )
Correct answer: Max ( ). MAX() returns the largest value in a range.
Background: MAX() looks at a range of numbers and returns the largest. Similar functions are MIN(), SUM(), AVERAGE(), and COUNT().
- Sum ( ): SUM() adds values.
- Min ( ): MIN() returns the smallest value.
- Average ( ): AVERAGE() returns the mean.
Did you know? Example: =MAX(A1:A10) returns the highest value in cells A1 to A10 and ignores text.
Memory trick: MAX = maximum = the biggest.
Is this answer helpful and correct?
0 agree0 disagree