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?
Please choose the correct answer.
Response:

• A.They will not have a performance value assigned.
• B.They will be Average Performers.
• C.They will not be included in the report.
• D.They will be Top Performers.

Comment: *

Name: *

Email: *

Verification: *

Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?
There are 2 correct answers to this question.
Response:

• A.Left()
• B.LeftTrim()
• C.Concatenate()
• D.LeftPad()

Comment: *

Name: *

Email: *

Verification: *

Design mode provides access to the following toolboxes and their associated functions. What are they?
There are 3 correct answers to this question
Response:

• A.Data Access
• B.Analysis task
• C.Report Element
• D.Improve function
• E.Matches data task

Comment: *

Name: *

Email: *

Verification: *

How do you change the dimension on which a section is based?

• A.1. Right click in a blank area of the section.
  2. Select Format Selection.
  3. Modify dimension after "Section on".
• B.1. Right click the section cell.
  2. Select Sort.
  3. Select Advanced.
  4. Remove existing dimension.
  5. Add the new dimension.
• C.1. Right click the section cell.
  2. Select Edit Formula.
  3. Choose the new dimension.
• D.1. Right click in a blank area of the section.
  2. Select Edit Selection.
  3. Choose the new dimension.

Comment: *

Name: *

Email: *

Verification: *

List the different ways you can use to display professional reports by using Web Intelligence document features?
There are 3 correct answers to this question
Response:

• A.As a double-block report containing large amounts of data
• B.As a folder containing large amounts of data
• C.As a multiple-block report containing large amounts of data
• D.As a table (horizontal, vertical, form or cross table)
• E.As a chart (bar, box, column, line, map, pie, point, radar or tag cloud)

Comment: *

Name: *

Email: *

Verification: *