This topic contains a solution. Click here to go to the answer
« previous next »

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

Capo

  • Hero Member
  • *****
  • Posts: 545
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.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

meganmoser117

  • Sr. Member
  • ****
  • Posts: 303
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.


Capo

  • Member
  • Posts: 545
Reply 2 on: Jun 24, 2018
Excellent

Chelseyj.hasty

  • Member
  • Posts: 319
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

True Forget-Me-Not True Forget-Me-Not
True Friendship True Friendship
Ratings of Perceived Contradictions in Political Statements Ratings of Perceived Contradictions in Political Statements
How to convert verbal statements into algebraic equations (Part 3) How to convert verbal statements into algebraic equations (Part 3)
How to convert verbal statements into algebraic equations (Part 4) How to convert verbal statements into algebraic equations (Part 4)
Excel hardware is introducing a new product on a new product line of capacity 800 units per ... Excel hardware is introducing a new product on a new product line of capacity 800 units per ...
Video: Stroke volume - preload, sarcomere length and Frank -Starling law

For a complete list of videos, visit our video library