BA 201 MIDTERM UPDATED ACTUAL QUESTIONS AND
CORRECT ANSWERS
Question:
1. Which Excel command will return all modes when more
than one mode exists?
Answer:
MODE.MULT
Question:
2. In a survey of patients in a local hospital, 62.42% of the
respondents indicated that the health care providers
needed to spend more time with each patient. Who
makes up the population?
Answer:
All patients in a local hospital
Question:
3. A manager of a fast food restaurant wants the drive-thru
employee to ask every fifth customer if he or she is
satisfied with the service. Who makes up the population?
Answer:
All customers who use the drive-thru window of this fast food restaurant
Question:
4. Which of the following relationships would have a
negative correlation coefficient?
Answer:
Supply and demand
Question:
5. Data-ink is the ink used in a table or chart that
Answer:
is necessary to convey the meaning of the data to the audience.
Question:
6. In many cases, white space in a chart can improve
Answer:
readability.
, Question:
7. Tables should be used instead of charts when
Answer:
the values being displayed have different units or very different magnitudes.
Question:
8. Which one of the following statements is not true
concerning PivotTables in Excel?
Answer:
PivotTables can be built using data arrayed in rows.
Question:
9. Fields may be chosen to represent all of the following
except ____________ in the body of a PivotTable.
Answer:
filters
Question:
10. A _____________ is a graphical presentation of the relationship
between two quantitative variables
Answer:
scatter chart
Question:
11. __________ are visual methods of displaying data.
Answer:
charts
Question:
12. A _____________ is a line that provides an approximation of the
relationship between the variables.
Answer:
trendline
Question:
13. The following image is a
Answer:
line chart
CORRECT ANSWERS
Question:
1. Which Excel command will return all modes when more
than one mode exists?
Answer:
MODE.MULT
Question:
2. In a survey of patients in a local hospital, 62.42% of the
respondents indicated that the health care providers
needed to spend more time with each patient. Who
makes up the population?
Answer:
All patients in a local hospital
Question:
3. A manager of a fast food restaurant wants the drive-thru
employee to ask every fifth customer if he or she is
satisfied with the service. Who makes up the population?
Answer:
All customers who use the drive-thru window of this fast food restaurant
Question:
4. Which of the following relationships would have a
negative correlation coefficient?
Answer:
Supply and demand
Question:
5. Data-ink is the ink used in a table or chart that
Answer:
is necessary to convey the meaning of the data to the audience.
Question:
6. In many cases, white space in a chart can improve
Answer:
readability.
, Question:
7. Tables should be used instead of charts when
Answer:
the values being displayed have different units or very different magnitudes.
Question:
8. Which one of the following statements is not true
concerning PivotTables in Excel?
Answer:
PivotTables can be built using data arrayed in rows.
Question:
9. Fields may be chosen to represent all of the following
except ____________ in the body of a PivotTable.
Answer:
filters
Question:
10. A _____________ is a graphical presentation of the relationship
between two quantitative variables
Answer:
scatter chart
Question:
11. __________ are visual methods of displaying data.
Answer:
charts
Question:
12. A _____________ is a line that provides an approximation of the
relationship between the variables.
Answer:
trendline
Question:
13. The following image is a
Answer:
line chart
