Statistical =FREQUENCY(data_array, bins_array)

Quiz =FREQUENCY — 15 Questions

15 quiz questions about =FREQUENCY — test syntax, arguments, examples & errors!

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

← FREQUENCY ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “bins_array” in =FREQUENCY?

Question 2 of 15 2/15

How many optional arguments does =FREQUENCY have?

Question 3 of 15 3/15

Is =FREQUENCY volatile?

Question 4 of 15 4/15

Which function is related to =FREQUENCY?

Question 5 of 15 5/15

How many required arguments does =FREQUENCY have?

Question 6 of 15 6/15

Which is the correct syntax of =FREQUENCY?

Question 7 of 15 7/15

Does =FREQUENCY return a dynamic array?

Question 8 of 15 8/15

In =FREQUENCY, which is argument #2?

Question 9 of 15 9/15

Since which Excel version is =FREQUENCY available?

Question 10 of 15 10/15

Which function is NOT related to =FREQUENCY?

Question 11 of 15 11/15

Which statement about =FREQUENCY is correct?

Question 12 of 15 12/15

What is the output type of =FREQUENCY?

Question 13 of 15 13/15

Which category does =FREQUENCY belong to?

Question 14 of 15 14/15

How many arguments does =FREQUENCY have in total?

Question 15 of 15 15/15

Is argument “bins_array” required in =FREQUENCY?

Click a question to see the answer.

1. What is the type of argument “bins_array” in =FREQUENCY?

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

Explanation: Type of “bins_array” is “Array”.

2. How many optional arguments does =FREQUENCY have?

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

Explanation: =FREQUENCY has 2 required, 0 optional (2 total).

3. Is =FREQUENCY volatile?

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

Explanation: FREQUENCY is not volatile.

4. Which function is related to =FREQUENCY?

A. DCOUNTA
B. ISREF
C. COUNTIF ✓
D. BITAND

Explanation: “COUNTIF” is related to FREQUENCY.

5. How many required arguments does =FREQUENCY have?

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

Explanation: =FREQUENCY has 2 required, 0 optional (2 total).

6. Which is the correct syntax of =FREQUENCY?

A. =FREQUENCY(data_array, bins_array, 0)
B. FREQUENCY(data_array, bins_array)
C. =COUNTIF(data_array, bins_array)
D. =FREQUENCY(data_array, bins_array) ✓

Explanation: Correct syntax: =FREQUENCY(data_array, bins_array)

7. Does =FREQUENCY return a dynamic array?

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

Explanation: FREQUENCY does not spill.

8. In =FREQUENCY, which is argument #2?

A. value
B. criteria
C. bins_array ✓
D. range

Explanation: Argument #2 is “bins_array”.

9. Since which Excel version is =FREQUENCY available?

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

Explanation: Version: “All versions”.

10. Which function is NOT related to =FREQUENCY?

A. PERCENTRANK-INC
B. LOGNORM.INV ✓
C. COUNTIFS
D. COUNTIF

Explanation: “LOGNORM.INV” is not related to FREQUENCY.

11. Which statement about =FREQUENCY is correct?

A. Text is always ignored
B. Requires add-in
C. Select entire column for best performance
D. The number of elements in the returned array is one more than the number of elements in bins_array. The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results. The extra cell returns the number of values in data_array that are greater than the third interval value. ✓

Explanation: Correct: The number of elements in the returned array is one more than the number of elements in bins_array. The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results. The extra cell returns the number of values in data_array that are greater than the third interval value.

12. What is the output type of =FREQUENCY?

A. Date
B. Mixed
C. Array ✓
D. Value

Explanation: Output is “Array”.

13. Which category does =FREQUENCY belong to?

A. Statistical ✓
B. Cube
C. Logical
D. Information

Explanation: Category is “Statistical”.

14. How many arguments does =FREQUENCY have in total?

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

Explanation: =FREQUENCY has 2 required, 0 optional (2 total).

15. Is argument “bins_array” required in =FREQUENCY?

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

Explanation: “bins_array” is required.