× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
d
4
N
3
3
R
3
k
3
o
3
Z
3
j
3
s
3
d
3
J
3
1
3
New Topic  
oloka oloka
wrote...
Posts: 365
Rep: 0 0
6 years ago
______ are visual methods of displaying data.
 a. Tables b. Charts
  c. PivotTables d. Crosstabs

Q. 2

A _____________ is a graphical presentation of the relationship between two quantitative variables.
 a. histogram b. bar chart
  c. pie chart d. scatter chart

Q. 3

Fields may be chosen to represent all of the following except ____________ in the body of a PivotTable.
 a. rows b. columns
  c. values d. filters

Q. 4

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.
Read 1247 times
3 Replies

Related Topics

Replies
wrote...
6 years ago
Ans. #1

b
RATIONALE: Charts are used to display and analyze data.

Ans. #2

d
RATIONALE: A scatter chart is a graphical presentation of the relationship between two quantitative variables.

Ans. #3

d
RATIONALE: Fields may be chosen to represent rows, columns, or values in the body of the PivotTable Report.

Ans. #4

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.
oloka Author
wrote...
6 years ago
All correct
wrote...
6 years ago
Happy to help
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1550 People Browsing
Related Images
  
 313
  
 342
  
 470