Statistical =MAX(number1, [number2], ...)

Quiz =MAX — 10 Questions

10 quiz questions about =MAX — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← MAX ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =MAX have in total?

Question 2 of 10 2/10

How many optional arguments does =MAX have?

Question 3 of 10 3/10

Which formula is a valid example of =MAX?

Question 4 of 10 4/10

How many required arguments does =MAX have?

Question 5 of 10 5/10

Since which Excel version is =MAX available?

Question 6 of 10 6/10

Which statement about =MAX is correct?

Question 7 of 10 7/10

Is =MAX volatile?

Question 8 of 10 8/10

What is the type of argument “number1” in =MAX?

Question 9 of 10 9/10

Is argument “number1” required in =MAX?

Question 10 of 10 10/10

Which is the correct syntax of =MAX?

Click a question to see the answer.

1. How many arguments does =MAX have in total?

A. 2
B. 4
C. 1 ✓
D. 3

Explanation: =MAX has 1 required, 0 optional (1 total).

2. How many optional arguments does =MAX have?

A. 2
B. —
C. 1
D. 0 ✓

Explanation: =MAX has 1 required, 0 optional (1 total).

3. Which formula is a valid example of =MAX?

A. =MAX(A2:A6, 0)
B. =MAX(A2:A6) ✓
C. =LARGE(A2:A6)
D. MAX(A2:A6)

Explanation: Correct example: =MAX(A2:A6)

4. How many required arguments does =MAX have?

A. 2
B. 3
C. 0
D. 1 ✓

Explanation: =MAX has 1 required, 0 optional (1 total).

5. Since which Excel version is =MAX available?

A. Excel 2007 (Compatibility)
B. Excel 365
C. All versions ✓
D. Excel 2019

Explanation: Version: “All versions”.

6. Which statement about =MAX is correct?

A. Text is always ignored
B. If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
C. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
D. Volatile and recalculates every time

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

7. Is =MAX volatile?

A. No ✓
B. Yes
C. No
D. —

Explanation: MAX is not volatile.

8. What is the type of argument “number1” in =MAX?

A. Array
B. Number ✓
C. Text
D. Reference

Explanation: Type of “number1” is “Number”.

9. Is argument “number1” required in =MAX?

A. No
B. Yes
C. —
D. Yes ✓

Explanation: “number1” is required.

10. Which is the correct syntax of =MAX?

A. MAX(number1, [number2], ...)
B. =MAX(number1, [number2], ..., 0)
C. =LARGE(number1, [number2], ...)
D. =MAX(number1, [number2], ...) ✓

Explanation: Correct syntax: =MAX(number1, [number2], ...)