It’s time to put what you’ve learned to the test, get 8 questions right to pass this unit.
1.
If you choose Add Data Source for Formulas, no table is created on the worksheet, allowing you to use formulas to design your own table layouts.
Choose the correct answer.
2.
Which option removes any hierarchical display of the dimension members?
Choose the correct answer.
3.
What can you add to a table to provide more information about a specific dimension?
Choose the correct answer.
4.
You can use only standard Excel formulas in the SAP Analytics Cloud, Add-in for Microsoft Excel.
Choose the correct answer.
5.
What are the supported data sources for SAP Analytics Cloud, Add-In for Microsoft Excel?
There are four correct answers.
6.
When filtering a dimension, by what can you filter?
There are two correct answers.
7.
You can only sort measures in a table.
Choose the correct answer.
8.
Your worksheet has multiple tables based on different data sources. Each data source uses a variable to filter the data. You want to change your initial responses to all the variables. What do you select?
Choose the correct answer.
9.
When using dimensional hierarchies, you can filter on hierarchy nodes as well as members.
Choose the correct answer.
10.
You want to display totals in your table. What do you select to call the context menu?