excel charting quiz mr. geerdes friday, february 27
TRANSCRIPT
![Page 1: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/1.jpg)
Excel Charting Quiz
Mr. Geerdes
Friday, February 27
![Page 2: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/2.jpg)
The charts of a spreadsheet file are erased when the spreadsheet file is saved and closed.
![Page 3: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/3.jpg)
False
![Page 4: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/4.jpg)
Charts may be printed from the chart window under view.
![Page 5: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/5.jpg)
False
![Page 6: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/6.jpg)
To switch from a spreadsheet window to a chart window, choose Chart from the File Menu.
![Page 7: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/7.jpg)
False
![Page 8: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/8.jpg)
When the spreadsheet data changes, charts created from the spreadsheet will also change.
![Page 9: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/9.jpg)
True
![Page 10: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/10.jpg)
Excel automatically creates a line chart when the Create New Chart command is chosen.
![Page 11: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/11.jpg)
False
![Page 12: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/12.jpg)
Charts are a graphical representation of spreadsheet data.
![Page 13: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/13.jpg)
True
![Page 14: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/14.jpg)
Bar charts are the best way to represent data groups that are part of a whole.
![Page 15: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/15.jpg)
False
![Page 16: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/16.jpg)
Line charts are well suited for representing trends over a period of time.
![Page 17: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/17.jpg)
True
![Page 18: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/18.jpg)
A chart that produces a “cloud’ of data points not connected by lines and is the best way to plot two series
of data on one plot point.
![Page 19: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/19.jpg)
Scatter
![Page 20: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/20.jpg)
A column chart represents values in the spreadsheet by varying heights of rectangles.
![Page 21: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/21.jpg)
True
![Page 22: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/22.jpg)
What type of chart represents values in a spreadsheet by points connected by a line?
![Page 23: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/23.jpg)
Line
![Page 24: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/24.jpg)
What type of chart vertical uses rectangles to represent values in a spreadsheet?
![Page 25: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/25.jpg)
Column
![Page 26: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/26.jpg)
What type of chart is represented by a circle divided in portions?
![Page 27: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/27.jpg)
Pie
![Page 28: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/28.jpg)
What command is chosen to create a new sheet in for a newly created chart?
![Page 29: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/29.jpg)
Move Chart
![Page 30: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/30.jpg)
Unless you rename a chart, what will Excel name the first chart prepared from a spreadsheet?
![Page 31: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/31.jpg)
Chart1
![Page 32: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/32.jpg)
What three characteristics may be added to a chart to help identify what the chart represents?
![Page 33: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/33.jpg)
Legends, Labels, Titles
![Page 34: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/34.jpg)
Where do you go under Select Data Source to make changes if the X and Y axis data are not correct?
![Page 35: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/35.jpg)
Series and/or Category
![Page 36: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/36.jpg)
Name six options you have for data labels in a chart.
![Page 37: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/37.jpg)
X-value, Y-value, Value, Series Name, Percentage, Category
Name
![Page 38: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/38.jpg)
If no plot points appear in an X-Y Scatter Chart, what is the name of the Data Option you choose and then go to Switch Row/Column
(series/category) to reverse the X and Y axis values.
![Page 39: Excel Charting Quiz Mr. Geerdes Friday, February 27](https://reader036.vdocuments.us/reader036/viewer/2022062719/56649ef05503460f94c00a3a/html5/thumbnails/39.jpg)
Select Data Source