Statistical =GROWTH(known_y's, [known_x's], [new_x's], [const])

Quiz =GROWTH — 10 Questions

10 quiz questions about =GROWTH — test syntax, arguments, examples & errors!

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

← GROWTH ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which formula is a valid example of =GROWTH?

Question 2 of 10 2/10

What is the type of argument “known_x's” in =GROWTH?

Question 3 of 10 3/10

Which function is NOT related to =GROWTH?

Question 4 of 10 4/10

Is =GROWTH volatile?

Question 5 of 10 5/10

What is the output type of =GROWTH?

Question 6 of 10 6/10

What is the type of argument “const” in =GROWTH?

Question 7 of 10 7/10

Which function is related to =GROWTH?

Question 8 of 10 8/10

Which category does =GROWTH belong to?

Question 9 of 10 9/10

Which statement about =GROWTH is correct?

Question 10 of 10 10/10

What is the type of argument “known_y's” in =GROWTH?

Click a question to see the answer.

1. Which formula is a valid example of =GROWTH?

A. =GROWTH(B2:B13, A2:A13, A14:A16) ✓
B. =LOGEST(B2:B13, A2:A13, A14:A16)
C. GROWTH(B2:B13, A2:A13, A14:A16)
D. =GROWTH(B2:B13, A2:A13, A14:A16, 0)

Explanation: Correct example: =GROWTH(B2:B13, A2:A13, A14:A16)

2. What is the type of argument “known_x's” in =GROWTH?

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

Explanation: Type of “known_x's” is “Range”.

3. Which function is NOT related to =GROWTH?

A. PHONETIC ✓
B. FORECAST-LINEAR
C. TREND
D. LOGEST

Explanation: “PHONETIC” is not related to GROWTH.

4. Is =GROWTH volatile?

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

Explanation: GROWTH is not volatile.

5. What is the output type of =GROWTH?

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

Explanation: Output is “Array”.

6. What is the type of argument “const” in =GROWTH?

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

Explanation: Type of “const” is “Logical”.

7. Which function is related to =GROWTH?

A. STEYX
B. LOGEST ✓
C. ISTEXT
D. DEVSQ

Explanation: “LOGEST” is related to GROWTH.

8. Which category does =GROWTH belong to?

A. Engineering
B. Statistical ✓
C. Lookup & Reference
D. Math & Trig

Explanation: Category is “Statistical”.

9. Which statement about =GROWTH is correct?

A. Only works in old versions
B. Requires add-in
C. Volatile and recalculates every time
D. Formulas that return arrays must be entered as array formulas after selecting the correct number of cells. ✓

Explanation: Correct: Formulas that return arrays must be entered as array formulas after selecting the correct number of cells.

10. What is the type of argument “known_y's” in =GROWTH?

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

Explanation: Type of “known_y's” is “Range”.