You are reviewing a report with the following statement in a variable: =If([Sales revenue] 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue]

Question

You are reviewing a report with the following statement in a variable:

=If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue] < 200000) Then "Low Performer" Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000?

Accepted Answer

D. They will not have a performance value assigned.

Answer

A. They will be Top Performers.

Answer

B. They will be Average Performers.

Answer

C. They will not be included in the report.

You are reviewing a report with the following statement in a variable: =If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else

Question

Options

How the community answered

Community Discussion