QUESTION 20
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:

QUESTION 21
Which Pos() function syntax should you use to find the location of the space in the Category string “Evening wear”? Please choose the correct answer.
Response:

QUESTION 22
Identify from the correct option from the following – To Navigate from Section to Section? Please choose the correct answer.
Response:

QUESTION 23
Which of the following filter components are used to restrict data? (3 answers)

QUESTION 24
In what application mode can you freeze column headers?
Please choose the correct answer.
Response:

QUESTION 25
Which is a benefit of using query drill?
Please choose the correct answer.
Response:

QUESTION 26
Select the correct sequence To Format a Bar Chart?
Please choose the correct answer.
Response:

QUESTION 27
What is the maximum number of sub-alerts that an alerter can contain?
Please choose the correct answer.
Response:

QUESTION 28
Which sort option should you use to add Temporary Values?
Please choose the correct answer.
Response:

QUESTION 29
Which two methods can you use to apply report filters to a BusinessObjects Web Intelligence 4.0 document (WID)? There are 2 correct answers to this question.
Response:

QUESTION 30
Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY. What syntax do you use to show only the names SMITH and SMYTH?

QUESTION 31
In the Query Panel, you can view and modify the default query properties. The query properties allow you to perform following actions, identify the correct answers from the following options? There are 2 correct answers to this question Response:

QUESTION 32
What is the output of the following expression when the CurrentDate is January 31, 2014?
If (MonthNumberOfYear(CurrentDate()) = l;
Year(CurrentDate())-l;
Year(CurrentDate()))

QUESTION 33
What items can be presented in a free-standing cell? (2 answers)

QUESTION 34
Which operator allows you to select exactly one value as the operand for a query filter?