Test Bank For
Data Visualization Exploring
and Explaining with Data 2nd
Edition By Jeffrey Camm,
James Cochran, Michael Fry,
Jeffrey Ohlmann (All Chapters
1-9, 100% Original Verified, A+
Grade)
All Chapters Arranged
Reverse: 9-1
This is The Original Test Bank
For 2nd Edition, All other Files
in The Market are
Fake/Old/Wrong.
,Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
Indicate the answer choice that best completes the statement or answers the question.
1. Which of these Excel formulas can help identify missing data?
a. =DATABLANK
b. =COUNTBLANK
c. =COUNTMISSING
d. =MISSING
2. Which of these Excel tools can help identify missing data?
a. Format Painter
b. Conditional Formatting
c. Custom Font
d. CTRL F
3. Excel’s COUNTBLANK function can help assess the quality of data by __________.
a. determining which observations have missing values
b. returning the number of blank cells in a column
c. deleting any data errors
d. returning the number of cells that meet a specific
criterion
4. We can use the Excel Conditional Formatting tool to help us identify any missing values by __________.
a. counting the number of blank cells in a column
b. changing the appearance of cells on the basis of conditions that you
specify
c. estimating the value of missing data cells
d. removing any data errors
5. What is the appropriate formula to determine the number of missing values of y in this abstract data set in Excel?
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
a. =COUNTBLANK(B2:B8)
b. =COUNTBLANK(A2:A8)
c. =COUNTIF(B2:B8,0)
d. =COUNTIF(A2:A8,0)
6. What is the appropriate formula to determine the number of missing values of x in this abstract data set in Excel?
a. =COUNTBLANK(B2:B8)
b. =COUNTBLANK(A2:A8)
c. =COUNTIF(B2:B8,0)
Copyright Cengage Learning. Powered by Cognero. Page 2
, Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
d. =COUNTIF(A2:A8,0)
7. Which tool is being used to identify the missing data in this abstract data set in Excel?
a. =COUNTBLANK
b. Conditional Formatting
c. Custom Font
d. CTRL F
8. Which numerical value would the function =COUNTBLANK(B2:B8) return in this abstract data set in Excel?
a. 1
Copyright Cengage Learning. Powered by Cognero. Page 3
Data Visualization Exploring
and Explaining with Data 2nd
Edition By Jeffrey Camm,
James Cochran, Michael Fry,
Jeffrey Ohlmann (All Chapters
1-9, 100% Original Verified, A+
Grade)
All Chapters Arranged
Reverse: 9-1
This is The Original Test Bank
For 2nd Edition, All other Files
in The Market are
Fake/Old/Wrong.
,Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
Indicate the answer choice that best completes the statement or answers the question.
1. Which of these Excel formulas can help identify missing data?
a. =DATABLANK
b. =COUNTBLANK
c. =COUNTMISSING
d. =MISSING
2. Which of these Excel tools can help identify missing data?
a. Format Painter
b. Conditional Formatting
c. Custom Font
d. CTRL F
3. Excel’s COUNTBLANK function can help assess the quality of data by __________.
a. determining which observations have missing values
b. returning the number of blank cells in a column
c. deleting any data errors
d. returning the number of cells that meet a specific
criterion
4. We can use the Excel Conditional Formatting tool to help us identify any missing values by __________.
a. counting the number of blank cells in a column
b. changing the appearance of cells on the basis of conditions that you
specify
c. estimating the value of missing data cells
d. removing any data errors
5. What is the appropriate formula to determine the number of missing values of y in this abstract data set in Excel?
Copyright Cengage Learning. Powered by Cognero. Page 1
,Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
a. =COUNTBLANK(B2:B8)
b. =COUNTBLANK(A2:A8)
c. =COUNTIF(B2:B8,0)
d. =COUNTIF(A2:A8,0)
6. What is the appropriate formula to determine the number of missing values of x in this abstract data set in Excel?
a. =COUNTBLANK(B2:B8)
b. =COUNTBLANK(A2:A8)
c. =COUNTIF(B2:B8,0)
Copyright Cengage Learning. Powered by Cognero. Page 2
, Name Clas Dat
: s: e:
Chapter 9 Telling the Truth with Data Visualization
d. =COUNTIF(A2:A8,0)
7. Which tool is being used to identify the missing data in this abstract data set in Excel?
a. =COUNTBLANK
b. Conditional Formatting
c. Custom Font
d. CTRL F
8. Which numerical value would the function =COUNTBLANK(B2:B8) return in this abstract data set in Excel?
a. 1
Copyright Cengage Learning. Powered by Cognero. Page 3
