Author Question: Which one of the following statements is not true concerning PivotTables in Excel? a. PivotTables ... (Read 98 times)

Capo · **on:** Jun 24, 2018

Which one of the following statements is not true concerning PivotTables in Excel?
a. PivotTables are also known as crosstabulation tables.
b. PivotTables summarize data for two variables.

c. PivotTables are interactive.
d. PivotTables summarize only categorical and quantitative data.

Question 2

Tables should be used instead of charts when
a. the reader needs relative comparisons of data.
b. there are more than two columns of data.
c. the values being displayed have different units or very different magnitudes.
d. the reader need not differentiate the columns and rows.

meganmoser117 · **Reply #1 on:** Jun 24, 2018

Answer to Question 1

d
RATIONALE: A useful type of table for describing data of two variables is a crosstabulation, which provides a tabular summary of data for two variables. Quality ratings are an example of categorical data, and meal prices are an example of quantitative data. A crosstabulation in Microsoft Excel is known as a PivotTable. PivotTables in Excel are interactive, and may be used to display statistics other than a simple count of items.

Answer to Question 2

c
RATIONALE: Tables should be used when the reader needs to refer to specific numerical values, when the reader needs to make precise comparisons between different values and not just relative comparisons, and when the values being displayed have different units or very different magnitudes.