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 106 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

Perkypinki

  • Member
  • Posts: 339
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Adapoids and omomyoids had longer snouts and are the first “true” primates. Adapoids and omomyoids had longer snouts and are the first “true” primates.
How to convert verbal statements into algebraic equations (Part 1) How to convert verbal statements into algebraic equations (Part 1)
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Midsagittal section indicating locations of true and false pelves Midsagittal section indicating locations of true and false pelves
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 ...
Video: Introduction to Tuberculosis

For a complete list of videos, visit our video library