San Francisco State University - FIN 353 1)A is a visual control that allows you to more easily filter one or more pivot tables

San Francisco State University - FIN 353

1)A is a visual control that allows you to more easily filter one or more pivot tables. Furthermore, a     can be on a different worksheet than the pivot table, making interactive dashboards much easier to create.

1. 1. data field
   2. structured reference
   3. calculated column
   4. calculated field
   5. slicer

2. Data fields are in             and records are in           .
   1. columns; columns
   2. rows; columns
   3. rows; rows
   4. columns; rows
   5. None of the above

3. 

   Which would be the result in cell B7?

a. 40%

b. 60%

c. 50%

d. 90%

e. 100%