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 58 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
YES! Correct, THANKS for helping me on my review

amit

  • Member
  • Posts: 364
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

true story true story
How to convert verbal statements into algebraic equations (Part 2) How to convert verbal statements into algebraic equations (Part 2)
True Dover Sole True Dover Sole
Anterosuperior view of true pelvis (blue) Anterosuperior view of true pelvis (blue)
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 ...
A diagram showing one of Mendel’s crosses. True-breeding strains of pea plants with smooth and ... A diagram showing one of Mendel’s crosses. True-breeding strains of pea plants with smooth and ...
Video: How eudicots (true dicots) differ from monocots Animation

For a complete list of videos, visit our video library