Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this unit.

1.

You can only sort measures in a table.

Choose the correct answer.
2.

What can you add to a table to provide more information about a specific dimension?

Choose the correct answer.
3.

When using dimensional hierarchies, you can filter on hierarchy nodes as well as members.

Choose the correct answer.
4.

Which preference determines if a user can update or view a workbook?

Choose the correct answer.
5.

You can define how numeric values are displayed in your table only for all measures.

Choose the correct answer.
6.

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.
7.

When you add an entry to a new Row or Column, it disappears when you refresh the workbook.

Choose the correct answer.
8.

Which option removes any hierarchical display of the dimension members?

Choose the correct answer.
9.

When filtering a dimension, by what can you filter?

There are two correct answers.
10.

You want to display totals in your table. What do you select to call the context menu?

Choose the correct answer.