At Universal Containers, the VP of Service has requested a visual indicator flag on each
case, based on the case priority. High-priority cases should be flagged red, medium-priority
should be flagged yellow, and low-priority cases should be flagged green. Which formula
would accomplish this requirement? (Choose 2 answers)
A. CASE(Priority, “Low”, “img/samples/flag_green.gif”, “Medium”,
“img/samples/flag_yellow.gif”, “High”, “img/samples/flag_red.gif”, “/s.gif”)
Explanation: The formula for creating a visual indicator flag on each case based on the case priority should use the IMAGE and CASE functions. The IMAGE function returns an
image for a given URL, and the CASE function evaluates an expression and returns a
value based on that expression. Option A and D use these functions correctly, while option
B and C do not.