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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Is argument “height” required in =IMAGE?
Explanation: “height” is optional.
Question 2 of 10
2/10
What is the type of argument “source” in =IMAGE?
Explanation: Type of “source” is “Text”.
Question 3 of 10
3/10
In =IMAGE, which is argument #2?
Explanation: Argument #2 is “alt_text”.
Question 4 of 10
4/10
Which category does =IMAGE belong to?
Explanation: Category is “Lookup & Reference”.
Question 5 of 10
5/10
What is the type of argument “height” in =IMAGE?
Explanation: Type of “height” is “Number”.
Question 6 of 10
6/10
What is the type of argument “sizing” in =IMAGE?
Explanation: Type of “sizing” is “Number”.
Question 7 of 10
7/10
What is the type of argument “alt_text” in =IMAGE?
Explanation: Type of “alt_text” is “Text”.
Question 8 of 10
8/10
Which formula is a valid example of =IMAGE?
Explanation: Correct example: =IMAGE("https://support.content.office.net/en-us/../media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
Question 9 of 10
9/10
What is the output type of =IMAGE?
Explanation: Output is “Mixed”.
Question 10 of 10
10/10
Is argument “width” required in =IMAGE?
Explanation: “width” is optional.