Microsoft Excel 2016 - Module 8 Quiz
Email address *
1. A ____ is a visual way to show how two variables relate to each other. *
1 point
2. A ____ is an interactive view of worksheet data. *
1 point
3. A ____ report is an interactive chart that allows users to change the groupings that graphically present data. *
1 point
4. ____ reports are visual representations of PivotTables. *
1 point
5. A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables. *
1 point
6. You can add a trendline to all of the following EXCEPT a(n) ____ chart. *
1 point
7. The ____ value is a number from 0 to 1 that measures the strength of a trend. *
1 point
8. Which of the following is the path to the PivotChart menu? *
1 point
9. Which of the following is the path to the Move Chart button? *
1 point
10. Which of the following is the path to the ‘Add Chart Element’ button? *
1 point
11. Charts with ____ are often reformatted to start the vertical axis at a number other than zero. *
1 point
12. You can filter the PivotTable report by ____. *
1 point
13. In PivotTables, ____ fields correspond to columns in the original data. *
1 point
14. In a PivotTable, ____ fields correspond to summary values of original data across categories. *
1 point
15. When creating a PivotTable report, the active cell should be positioned ____. *
1 point
16. Which of the following is the path to the PivotTable button? *
1 point
17. Which of the following is the path to the Report Layout button? *
1 point
18. Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____. *
1 point
19. Which of the following is the path to the PivotTable Styles gallery More button? *
1 point
20. To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu. *
1 point
Submit
This form was created inside of Professional Tutor, LLC. Report Abuse