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

Quiz =IMAGE — 15 Questions

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

Question 1 of 15 1/15

Since which Excel version is =IMAGE available?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

What usually causes #VALUE! in =IMAGE?

Question 5 of 15 5/15

Is argument “width” required in =IMAGE?

Question 6 of 15 6/15

Which function is NOT related to =IMAGE?

Question 7 of 15 7/15

Which function is related to =IMAGE?

Question 8 of 15 8/15

In =IMAGE, which is argument #2?

Question 9 of 15 9/15

Is argument “sizing” required in =IMAGE?

Question 10 of 15 10/15

Which use case fits =IMAGE?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Which formula is a valid example of =IMAGE?

Question 13 of 15 13/15

How many arguments does =IMAGE have in total?

Question 14 of 15 14/15

Is argument “alt_text” required in =IMAGE?

Question 15 of 15 15/15

Does =IMAGE return a dynamic array?

Click a question to see the answer.

1. Since which Excel version is =IMAGE available?

A. Excel 2019
B. Excel 365 ✓
C. All versions
D. Excel 2007 (Compatibility)

Explanation: Version: “Excel 365”.

2. What is the type of argument “alt_text” in =IMAGE?

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

Explanation: Type of “alt_text” is “Text”.

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. Only works in old versions
D. Check the image address and the third input ✓

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

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

A. Requires add-in
B. Only works in old versions
C. Select entire column for best performance
D. Excel returns a #VALUE! error under the following circumstances: For more information, see How to correct a #VALUE! error. ✓

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

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

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

Explanation: “width” is optional.

6. Which function is NOT related to =IMAGE?

A. SORT ✓
B. IMAGE_X
C. XLOOKUP
D. FILTER

Explanation: “SORT” is not related to IMAGE.

7. Which function is related to =IMAGE?

A. REGISTER.ID
B. DOLLAR
C. FILTER ✓
D. CSCH

Explanation: “FILTER” is related to IMAGE.

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

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

Explanation: Argument #2 is “alt_text”.

9. Is argument “sizing” required in =IMAGE?

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

Explanation: “sizing” is optional.

10. Which use case fits =IMAGE?

A. Reporting
B. Reshape Tables
C. Ranking & Top N
D. Dynamic Ranges & Dashboards ✓

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

11. What is the type of argument “height” in =IMAGE?

A. Mixed
B. Text
C. Number ✓
D. Logical

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

12. Which formula is a valid example of =IMAGE?

A. IMAGE("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
B. =IMAGE("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere") ✓
C. =FILTER("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
D. =IMAGE("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere", 0)

Explanation: Correct example: =IMAGE("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")

13. How many arguments does =IMAGE have in total?

A. 4
B. 6
C. 5 ✓
D. 7

Explanation: =IMAGE has 1 required, 4 optional (5 total).

14. Is argument “alt_text” required in =IMAGE?

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

Explanation: “alt_text” is optional.

15. Does =IMAGE return a dynamic array?

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

Explanation: IMAGE does not spill.