Microsoft Excel 2016 - Module 8 Quiz

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

1. A ____ is a visual way to show how two variables relate to each other. *

1 point

pivotline

guideline

timeline

trendline

2. A ____ is an interactive view of worksheet data. *

1 point

PivotChart report

trendline

PivotTable report

2-D column chart

3. A ____ report is an interactive chart that allows users to change the groupings that graphically present data. *

1 point

SlicerChart

PivotChart

TrendChart

2-D Column chart

4. ____ reports are visual representations of PivotTables. *

1 point

PivotChart

Slicer

Data Marker

Calculated field

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

trend

change

alignment

arrangement

6. You can add a trendline to all of the following EXCEPT a(n) ____ chart. *

1 point

inventory

pie

scatter

bubble

7. The ____ value is a number from 0 to 1 that measures the strength of a trend. *

1 point

A-squared

P-squared

R-squared

T-squared

8. Which of the following is the path to the PivotChart menu? *

1 point

(INSERT tab | Charts group)

(HOME tab | Charts group)

(VIEW tab | Data group)

(INSERT tab | Images group)

9. Which of the following is the path to the Move Chart button? *

1 point

(PIVOTCHART TOOLS LAYOUT tab | Location group)

(PIVOTCHART TOOLS FORMAT tab | Location group)

(PIVOTCHART TOOLS DESIGN tab | Location group)

(PIVOTCHART TOOLS OPTIONS tab | Location group)

10. Which of the following is the path to the ‘Add Chart Element’ button? *

1 point

(PIVOTCHART TOOLS DESIGN tab | Analysis group)

(PIVOTCHART TOOLS DESIGN tab | Chart Layouts group)

(PIVOTCHART TOOLS FORMAT tab | Analysis group)

(PIVOTCHART TOOLS FORMAT tab | Options group)

11. Charts with ____ are often reformatted to start the vertical axis at a number other than zero. *

1 point

data layouts

indices

trendlines

baselines

12. You can filter the PivotTable report by ____. *

1 point

Total 2014 Sales

Revenue Venue

Total 2015 Sales

Average 2014 Sales

13. In PivotTables, ____ fields correspond to columns in the original data. *

1 point

row

index

summary

category

index

data

summary

15. When creating a PivotTable report, the active cell should be positioned ____. *

1 point

anywhere in the range that contains the data

in cell A1

anywhere outside the range that contains the data

There is no active cell in a PivotTable report.

16. Which of the following is the path to the PivotTable button? *

1 point

(INSERT tab | Text group)

(HOME tab | Analysis group)

(INSERT tab | Tables group)

(TABLES tab | Analysis group)

17. Which of the following is the path to the Report Layout button? *

1 point

(PIVOTTABLE TOOLS LAYOUT tab | Design group)

(PIVOTTABLE TOOLS DESIGN tab | Layout group)

(PIVOTTABLE TOOLS FORMAT tab | Layout group)

(PIVOTTABLE TOOLS DESIGN tab | Theme group)

18. Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____. *

1 point

organizing

implementing

sorting

filtering

19. Which of the following is the path to the PivotTable Styles gallery More button? *

1 point

(INSERT tab | Table Styles group)

(PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)

(HOME tab | Paint Styles group)

(PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group)

20. To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu. *

1 point

Subtotal Values By

Summarize Values By

Total Values By

Calculate Values By

Submit

Clear form

This form was created inside of Professional Tutor, LLC. Report Abuse

Forms