Online Access Free C-BOWI-42 Exam Questions

What option do you select to change the Total Revenue to a currency (shown in the attached graphic)?

• A.Right click a number in the Total Revenue column. ^ ^ 2. Select Format Cell.
• B.Right click a number in the Total Revenue column. 2. Select Format Number.
• C.Right click on the edge of the table. U 2. Select Format Table.
• D.Right click the Total Revenue column name. 2. Select Format Number.

You are asked to create a table to display revenue data in three distinct colors. What must you create in a single conditional formatting rule?

• A.Multiple predefined filters
• B.A single formula using the IF function
• C.Multiple Else conditions
• D.A single formula using the WHERE operator

What does the ranking calculation mode Cumulative Percentage keep in the block?

• A.The top/bottom values until the sum reaches a specified percentage of the total.
• B.The top/bottom percentage of the number of rows based on the dimension.
• C.The top/bottom values until the sum reaches a specified value.
• D.The top/bottom number of rows based on the measure.

What can you do with a scope of analysis? (2 answers)

• A.Request the data from the database for drilling.
• B.Provide further detail on data.
• C.Restrict the data retrieved from the database only to the objects on the report.
• D.Perform calculation.

What do you use to conditionally hide a report element?

• A.A formula
• B.A report filter
• C.A query filter
• D.A formatting rule