Which is the correct expression?

Refer to the exhibits.

A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.

Which is the correct expression?
A . =Sum(Sales) >200000
B. =If(Sum(Sales)>200000, Salesman)
C. =Firstname(Salesman=,Rob,, ‘Tom’, ‘Helen’, ‘Rock’, ‘Leif’)
D. = If (WildMatch (Salesman, ‘Rob*’ , "Tom"’, ‘Helen* ‘, ‘Rock*’ , ‘Leif"’) , Sales)

View Answer

Answer: D