Practice Max (2.3) - Spreadsheet – Functions and Charts

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the MAX function do in spreadsheets?
Show hintHide hint
Think about finding the highest score or value.
Question 2.
Write the syntax for the MAX function.
Show hintHide hint
Remember to start with an equal sign.
3Question 3.
What value does the MAX function return?
- Smallest number
- Average value
- Largest number
Show hintHide hint
Think about what maximum means!
4Question 4.
Is it possible to use the MAX function with text data?
- True
- False
Show hintHide hint
Consider the types of data suitable for calculations.
Question 5.
You are analyzing student scores ranging from 0 to 100. If a student scored 95, and others scored 90, 85, and 92, what will =MAX(A1:A4) return if A1 to A4 contains these scores?
Show hintHide hint
Identify which of those numbers is the largest.
Question 6.
In a sales report, your team has recorded sales of different products with varying numbers. How can you formulate your data to extract the max sales? Provide an example of applying the MAX function to your data set.
Show hintHide hint
Make sure you're referencing the correct range.

5 more questions in this section. Enroll free to practise them all.