AnswersComputer Applications - Office 2016 - EL3520 APivot Tables and Pivot Charts

Pivot Tables and Pivot Charts Answers

11 verified answers1 views
1
Free Preview

How will Excel summarize the data to create PivotTables?

A
summarize by row but not by column
B
summarize by column but not by row
C
summarize by individual cells
D
summarize by row and by column
2
Free Preview

What is the definition of transactional data in Excel?

A
All cells have values and formulas.
B
Single cells have formulas and results.
C
Single cells have values but not formulas.
D
Multiple cells have header rows.
3

What is a PivotTable?

A
a chart that visualizes the data in a table
B
an image that symbolizes the result of a calculation
C
a table of source data that can be exported to other programs
D
an interactive table that summarizes and organizes data
4

What command activates the Analyze contextual tab to appear?

A
inserting a table
B
inserting a PivotTable
C
altering a chart
D
inserting a chart
5

What do newly created PivotTables look like?

A
They are identical to the original table.
B
They are empty.
C
They are invisible.
D
They contain too much data.
6

What function would be used if you want to compare all other rows with the first row?

A
SUM function
B
Difference From Option
C
Percentage of Total
D
PivotChart
7

What is the purpose of the GETPIVOTDATA function?

A
to export the PivotTable data into another worksheet
B
to quickly put the PivotTable into a PivotChart
C
to quickly put the PivotTable data into a pie chart
D
to pull specific information from PivotTable to answer the question
8

How are PivotCharts different from regular charts?

A
They are interactive.
B
They contain images.
C
They have more color options.
D
They contain styles.
9

What are slicers used for?

A
checking the accuracy of data
B
accurately charting data
C
adding data to a table
D
quickly filtering data
10

Which group in the Timeline Tools contextual tab would help you alter the color of a timeline?

A
Arrange
B
Styles
C
Size
D
Show
11

What is the first step needed before you can add a timeline to a PivotTable?

A
Click Insert Timeline.
B
Select the PivotTable.
C
Click Insert on the ribbon.
D
Click the Design contextual tab.

Did you find these answers helpful?

More from this Course

Assignment
9 verified answers

Pivot Tables and Pivot Charts

Assignment
9 verified answers

Pivot Tables and Pivot Charts

Instruction
11 verified answers

Instruction

Pivot Tables and Pivot Charts Answers — Computer…