Question

Owen is a school teacher. He is preparing a spreadsheet on the marks scored in Math in the first semester. He wants to find out the highest marks scored in Math during the last 3 years. Which function can he use to avail this result?

Owen can use the function to find the highest marks scored in Math.

Answer 1

Answer: MAX

Step-by-step explanation:

Quizziz has it marked as correct

Answer 2

This is not an easy question to answer. It's not the answer itself, its what does the key to the answer expect?

Suppose you have numbers in a1 to a7.
You want to know what the maximum number is in those seven cells.
The answer would be
=max(a1:a7)
When you look up help however, it shows the function as
=max()
So it depends on what other questions you have looks like. There's another problem. Some spreadsheets use =max(a1..a7). So you are pretty much dependent on looking this up in the help section (usually f1 when your curser is overtop of Max). But it still depends on what your instructor expects.