Excel Chapter 4 Quiz

 

<-----BACK TO REVIEW

1. What is a type of visual aid that presents data and deliver a message?

Outline
Chart
Paragraph


2. Which component of a chart are the descriptive entries?

Category Label
Data Points
Data Series


3. Which component of a chart are groups of data points?

Category Labels
Data Points
Data Series


4. Which component of a chart are the numerical values?

Category Labels
Data Points
Data Series


5. Which of the following chart does NOT present information that is depicted in real numbers?

Pie Chart
Column Chart
Bar Chart


6. Which of the following charts present information that shows percentage?

Bar Cart
Pie Chart
Line Chart


7. Which of the following is not a type of pie chart?

Exploded Pie Chart
3-D Pie Chart
Selected Pie Chart


8. Which of the following charts presents different kinds of data series with two or more different illustrations simultaneously?

Pie Chart
Bar Chart
Combination Chart


9. Which methods of creating a chart involves storing graphs or any objects within a compound document?

Embedding
Using Chart Wizard
Using Chart Sheet


10. Which method of creating a chart involves saving the chart as its own document and connecting it to a particular document?

Embedding
Using Chart Wizard
Linking Charts


11. Which type of chart is used for comparisons that graphs multi-series data along the x-axis (allows the reader to look at the graphs individually)?

Side-by-Side Chart
Stacked Column Chart
Link Chart


12. Which type of chart is used for comparisons as it emphasizes data by stacking categories?

Side-by-Side Chart
Stacked Column Chart
Line Chart


13. Which method of creating a chart involves a separate sheet within Excel which displays the chart?

Embedding
Chart Wizard
Chart Sheet


14. Which of the following is NOT an example of misuse of charts?

Having more than one graphs on a chart
Having improper labels
Adding dissimilar quantities


15. Where can charts be found?

Magazine
Learning Aids
All of the above, charts can be found in anything that deals with recordable data


 

<---BACK TO REVIEW