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

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

Question 2 of 15 2/15

In =IMAGE, which is argument #1?

Question 3 of 15 3/15

Which category does =IMAGE belong to?

Question 4 of 15 4/15

How many optional arguments does =IMAGE have?

Question 5 of 15 5/15

Which statement about =IMAGE is correct?

Question 6 of 15 6/15

Which is the correct syntax of =IMAGE?

Question 7 of 15 7/15

Since which Excel version is =IMAGE available?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which formula is a valid example of =IMAGE?

Question 10 of 15 10/15

Which function is related to =IMAGE?

Question 11 of 15 11/15

Which function is NOT related to =IMAGE?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

In =IMAGE, which is argument #3?

Question 15 of 15 15/15

What is the output type of =IMAGE?

Click a question to see the answer.

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

A. Only works in old versions
B. Requires add-in
C. Output is always a dynamic array
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

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

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

Explanation: Argument #1 is “source”.

3. Which category does =IMAGE belong to?

A. Lookup & Reference ✓
B. Engineering
C. Financial
D. Compatibility

Explanation: Category is “Lookup & Reference”.

4. How many optional arguments does =IMAGE have?

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

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

5. Which statement about =IMAGE is correct?

A. To work around the URL limit of 255 characters, avoid copying a long URL from the browser address bar. Instead, right click the image in the browser, select Copy image link, paste the value into a cell in Excel, and then reference that cell as source. For example, if the long URL is copied to F10, create the following function call: =IMAGE(F10).
B. If source is a URL that requires authentication, the image doesn't render.
C. Be careful customizing the height and width as it may skew the aspect ratio, or the proportional relationship between the original image height and width. ✓
D. Output is always a dynamic array

Explanation: Correct: Be careful customizing the height and width as it may skew the aspect ratio, or the proportional relationship between the original image height and width.

6. Which is the correct syntax of =IMAGE?

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

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

7. Since which Excel version is =IMAGE available?

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

Explanation: Version: “Excel 365”.

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

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

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

9. 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", 0)
B. =FILTER("https:⁠//support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
C. IMAGE("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") ✓

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

10. Which function is related to =IMAGE?

A. FILTER ✓
B. BYROW
C. HIDDEN
D. MIRR

Explanation: “FILTER” is related to IMAGE.

11. Which function is NOT related to =IMAGE?

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

Explanation: “VLOOKUP” is not related to IMAGE.

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

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

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

13. What is the type of argument “source” in =IMAGE?

A. Reference
B. Date
C. Text ✓
D. Value

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

14. In =IMAGE, which is argument #3?

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

Explanation: Argument #3 is “sizing”.

15. What is the output type of =IMAGE?

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

Explanation: Output is “Mixed”.