1.
Which of the following functions is included in SAP BusinessObjects Analysis, edition for Microsoft Office?
2.
Which of the following statements regarding refreshing mode in BEx Analyzer is correct?
3.
What can you define when using the formula mode in BEx Analyzer?
4.
You create a workbook with exceptions in BEx Analyzer. Your customer does not like the standard colors for Bad 1 and Good 2 exceptions.
What do you use to change the color settings in BEx Analyzer?
 
5.
What is the purpose of design mode in BEx Analyzer?
6.
You want to create a query in BEx Query Designer that produces a table as shown in the attached screenshot.
What do you have to use to accomplish this?
7.
You use BEx Query Designer to create a query with the characteristic "Material" in the rows and the key figure "Sales Volume" in the columns. Now you create an exception (Bad 3, Critical 2 and Good 1) and activate it. After executing the query, all values under Sales Volume are colored. You now edit the exception and click the Exception Only Affects Results button.
What happens in the report?
8.
What is the difference between navigation attributes and display attributes in a BEx Query definition?
9.
You want to create a calculated key figure at InfoProvider level.
Which key figures can you use?
10.
What is the result of setting the "constant selection" property in the Extended tab of a restricted key figure?