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

How many arguments does =FREQUENCY have in total?

Question 2 of 10 2/10

Which statement about =FREQUENCY is correct?

Question 3 of 10 3/10

Does =FREQUENCY return a dynamic array?

Question 4 of 10 4/10

Which function is NOT related to =FREQUENCY?

Question 5 of 10 5/10

In =FREQUENCY, which is argument #1?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which is the correct syntax of =FREQUENCY?

Question 8 of 10 8/10

Is argument “data_array” required in =FREQUENCY?

Question 9 of 10 9/10

What is the output type of =FREQUENCY?

Question 10 of 10 10/10

Which category does =FREQUENCY belong to?

Click a question to see the answer.

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

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

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

2. Which statement about =FREQUENCY is correct?

A. Select entire column for best performance
B. Output is always a dynamic array
C. Only works in old versions
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.

3. Does =FREQUENCY return a dynamic array?

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

Explanation: FREQUENCY does not spill.

4. Which function is NOT related to =FREQUENCY?

A. BESSELJ ✓
B. COUNTIFS
C. COUNTIF
D. PERCENTRANK-INC

Explanation: “BESSELJ” is not related to FREQUENCY.

5. In =FREQUENCY, which is argument #1?

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

Explanation: Argument #1 is “data_array”.

6. What is the type of argument “data_array” in =FREQUENCY?

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

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

7. 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)

8. Is argument “data_array” required in =FREQUENCY?

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

Explanation: “data_array” is required.

9. What is the output type of =FREQUENCY?

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

Explanation: Output is “Array”.

10. Which category does =FREQUENCY belong to?

A. Web
B. Statistical ✓
C. Math & Trig
D. Logical

Explanation: Category is “Statistical”.