Compatibility
=QUARTILE(array,quart)
Quiz =QUARTILE — 10 Questions
10 quiz questions about =QUARTILE — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
How many required arguments does =QUARTILE have?
Explanation: =QUARTILE has 2 required, 0 optional (2 total).
Question 2 of 10
2/10
Does =QUARTILE return a dynamic array?
Explanation: QUARTILE does not spill.
Question 3 of 10
3/10
Which statement about =QUARTILE is correct?
Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.
Question 4 of 10
4/10
Which use case fits =QUARTILE?
Explanation: Use case “Ranking & Top N” fits QUARTILE.
Question 5 of 10
5/10
Which function is NOT related to =QUARTILE?
Explanation: “TAN” is not related to QUARTILE.
Question 6 of 10
6/10
Which is the correct syntax of =QUARTILE?
Explanation: Correct syntax: =QUARTILE(array,quart)
Question 7 of 10
7/10
Is argument “array” required in =QUARTILE?
Explanation: “array” is required.
Question 8 of 10
8/10
How many arguments does =QUARTILE have in total?
Explanation: =QUARTILE has 2 required, 0 optional (2 total).
Question 9 of 10
9/10
Since which Excel version is =QUARTILE available?
Explanation: Version: “All versions”.
Question 10 of 10
10/10
Is argument “quart” required in =QUARTILE?
Explanation: “quart” is required.