In Microsoft Excel 2016, the formula '=IF(G5=L5,"Yes", "No")' is a _____ function.
A)text
B)logical
C)lookup & reference
D)math & trig

Name: In Microsoft Excel 2016, the formula '=IF(G5=L5,"Yes", "No")' is a _____ function. A)text B)logical C)lookup & reference D)math & trig
Brand: Quizplus
Rating: 4.7 (38 reviews)

Question

Quizplus · Accepted Answer

The formula '=IF(G5=L5,"Yes", "No")' is an example of a logical function in Excel, as it evaluates a condition (whether G5 equals L5) and returns one value if the condition is true and another value if the condition is false.

In Microsoft Excel 2016, the Formula '=IF(G5=L5,"Yes", "No")' Is a _____