Statistical =FREQUENCY(data_array, bins_array)

Quiz =FREQUENCY — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =FREQUENCY?

Question 2 of 10 2/10

In =FREQUENCY, which is argument #2?

Question 3 of 10 3/10

How many arguments does =FREQUENCY have in total?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which statement about =FREQUENCY is correct?

Question 6 of 10 6/10

Which formula is a valid example of =FREQUENCY?

Question 7 of 10 7/10

Is argument “bins_array” required in =FREQUENCY?

Question 8 of 10 8/10

Which function is related to =FREQUENCY?

Question 9 of 10 9/10

Which use case fits =FREQUENCY?

Question 10 of 10 10/10

Does =FREQUENCY return a dynamic array?

Click a question to see the answer.

1. What is the output type of =FREQUENCY?

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

Explanation: Output is “Array”.

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

A. criteria
B. lookup_value
C. data_array
D. bins_array ✓

Explanation: Argument #2 is “bins_array”.

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

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

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

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

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

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

5. Which statement about =FREQUENCY is correct?

A. Volatile and recalculates every time
B. 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. ✓
C. FREQUENCY ignores blank cells and text.
D. Only works in old versions

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.

6. Which formula is a valid example of =FREQUENCY?

A. =FREQUENCY(B2:B100, E2:E5, 0)
B. =FREQUENCY(B2:B100, E2:E5) ✓
C. FREQUENCY(B2:B100, E2:E5)
D. =COUNTIF(B2:B100, E2:E5)

Explanation: Correct example: =FREQUENCY(B2:B100, E2:E5)

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

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

Explanation: “bins_array” is required.

8. Which function is related to =FREQUENCY?

A. T.DIST.RT
B. COUNTIF ✓
C. HLOOKUP
D. TRUE

Explanation: “COUNTIF” is related to FREQUENCY.

9. Which use case fits =FREQUENCY?

A. Workdays & Due Dates
B. Conditional Aggregation ✓
C. Probability & Hypothesis Testing
D. Error Handling

Explanation: Use case “Conditional Aggregation” fits FREQUENCY.

10. Does =FREQUENCY return a dynamic array?

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

Explanation: FREQUENCY does not spill.