Lookup & Reference =IMAGE(source, [alt_text], [sizing], [height], [width])

Quiz =IMAGE — 10 Questions

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

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

← IMAGE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #VALUE! in =IMAGE?

Question 2 of 10 2/10

In =IMAGE, which is argument #2?

Question 3 of 10 3/10

Does =IMAGE return a dynamic array?

Question 4 of 10 4/10

Which is the correct syntax of =IMAGE?

Question 5 of 10 5/10

In =IMAGE, which is argument #1?

Question 6 of 10 6/10

Which function is related to =IMAGE?

Question 7 of 10 7/10

What is the fix for #VALUE! in =IMAGE?

Question 8 of 10 8/10

Is argument “width” required in =IMAGE?

Question 9 of 10 9/10

What is the type of argument “width” in =IMAGE?

Question 10 of 10 10/10

Which use case fits =IMAGE?

Click a question to see the answer.

1. What usually causes #VALUE! in =IMAGE?

A. Output is always a dynamic array
B. Excel returns a #VALUE! error under the following circumstances: For more information, see How to correct a #VALUE! error. ✓
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: Excel returns a #VALUE! error under the following circumstances: For more information, see How to correct a #VALUE! error. — Fix: Check the image address and the third input

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

A. height
B. source
C. width
D. alt_text ✓

Explanation: Argument #2 is “alt_text”.

3. Does =IMAGE return a dynamic array?

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

Explanation: IMAGE does not spill.

4. Which is the correct syntax of =IMAGE?

A. =IMAGE(source, [alt_text], [sizing], [height], [width]) ✓
B. =IMAGE(source, [alt_text], [sizing], [height], [width], 0)
C. IMAGE(source, [alt_text], [sizing], [height], [width])
D. =FILTER(source, [alt_text], [sizing], [height], [width])

Explanation: Correct syntax: =IMAGE(source, [alt_text], [sizing], [height], [width])

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

A. value
B. height
C. criteria
D. source ✓

Explanation: Argument #1 is “source”.

6. Which function is related to =IMAGE?

A. FILTER ✓
B. SHEET
C. ROUNDUP
D. ISERR

Explanation: “FILTER” is related to IMAGE.

7. What is the fix for #VALUE! in =IMAGE?

A. Check the image address and the third input ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. Text is always ignored

Explanation: Excel returns a #VALUE! error under the following circumstances: For more information, see How to correct a #VALUE! error. — Fix: Check the image address and the third input

8. Is argument “width” required in =IMAGE?

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

Explanation: “width” is optional.

9. What is the type of argument “width” in =IMAGE?

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

Explanation: Type of “width” is “Number”.

10. Which use case fits =IMAGE?

A. Descriptive Statistics
B. Forecasting & Trends
C. Dynamic Ranges & Dashboards ✓
D. Reporting

Explanation: Use case “Dynamic Ranges & Dashboards” fits IMAGE.