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 112 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
Great answer, keep it coming :)

FergA

  • Member
  • Posts: 352
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

IgA antibodies protect body surfaces exposed to outside foreign substances. IgG antibodies are found in all body fluids. IgM antibodies are the first type of antibody made in response to an infection. IgE antibody levels are often high in people with allergies. IgD antibodies are found in tissues lining the abdomen and chest.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

True Friendship True Friendship
Adapoids and omomyoids had longer snouts and are the first “true” primates. Adapoids and omomyoids had longer snouts and are the first “true” primates.
A recruiting poster for the “True Sons of Freedom” encouraged African Americans to enlist. In fact, A recruiting poster for the “True Sons of Freedom” encouraged African Americans to enlist. In fact,
How to convert verbal statements into algebraic equations (Part 2) How to convert verbal statements into algebraic equations (Part 2)
How to convert verbal statements into algebraic equations (Part 4) How to convert verbal statements into algebraic equations (Part 4)
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: Embryonic development - Week 3

For a complete list of videos, visit our video library