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 105 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
Wow, this really help

bitingbit

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

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?

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.

Did you know?

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

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Apparent and True Orbits of Alpha Centauri. Apparent and True Orbits of Alpha Centauri.
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.
How to convert verbal statements into algebraic equations (Part 3) How to convert verbal statements into algebraic equations (Part 3)
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)
Video: Role of the respiratory system - effect of altered ventilation rates

For a complete list of videos, visit our video library