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

In =FREQUENCY, which is argument #2?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =FREQUENCY, which is argument #1?

Question 4 of 10 4/10

Is =FREQUENCY volatile?

Question 5 of 10 5/10

Which category does =FREQUENCY belong to?

Question 6 of 10 6/10

What is the output type of =FREQUENCY?

Question 7 of 10 7/10

Which statement about =FREQUENCY is correct?

Question 8 of 10 8/10

How many required arguments does =FREQUENCY have?

Question 9 of 10 9/10

How many optional arguments does =FREQUENCY have?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

Explanation: Argument #2 is “bins_array”.

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

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

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

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

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

Explanation: Argument #1 is “data_array”.

4. Is =FREQUENCY volatile?

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

Explanation: FREQUENCY is not volatile.

5. Which category does =FREQUENCY belong to?

A. Date & Time
B. Financial
C. Text
D. Statistical ✓

Explanation: Category is “Statistical”.

6. What is the output type of =FREQUENCY?

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

Explanation: Output is “Array”.

7. Which statement about =FREQUENCY is correct?

A. 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. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Output is always a dynamic array

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.

8. How many required arguments does =FREQUENCY have?

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

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

9. How many optional arguments does =FREQUENCY have?

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

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

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

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

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