CGS 2518 CH.#3 EXAM QUESTIONS
AND ANSWERS
What are the differences and similarities between a line chart and an X Y (scatter )
chart? When should you use each one? - Answer-XY (scatter) chart plots numeric
values on both the y and x axes based on the value of the data
-A line chart plots number values on one axis and category labels equidistantly on the
other axis
-The X Y (Scatter) plots the x-axis in numeric order, and the line chart plots the x-axis
based on the position of the categories in the data range
-Use a XY (scatter) chart when you want to compare sets of numeric data on both the x
and y axis
Explain the difference between the data points in a line chart and an X Y (scatter) chart?
- Answer--For a line chart, data points are plotted along the Y axis based on number
values. the x axis displays categories and plots based on position
-For the XY (scatter) chart- x and y axis are plotted as numeric values
What are the differences between a bar chart and a column chart? Give an example of
when you would use each one - Answer-A Bar chart compares values across categories
in a horizontal orientation. Values are indicated by the length of the bars.
Example: use a bar chart to compare the average price for each product category.
A Column chart compare values across categories in a vertical orientation. Values are
indicated by the height of the columns. Makes it easier to compare the contribution each
category made in a particular year.
Example: use a column chart when comparing the contribution that each type of product
category has made towards revenue for a year. The amount each department made
each year.
What are the differences between a column chart and an area chart? Give an example
of when you would use each one - Answer--A Column chart compare values across
categories in a vertical orientation.
-An area chart displays trends of values over time or by category. Values are indicated
by the filled areas below the lines. area charts combine the features of a line chart with
a bar or column chart.
, -A column chart can be used to compare the amount of each year's sales for each
category. An area chart emphasizes the trend in each category over time.
- a problem with an area chart is one data series might hide another data series
How do pie charts differ from doughnut charts? - Answer--A pie chart displays the
percentage contribution that each category made makes to the whole or 100%. Values
are indicated by the size of the pie slices
-A doughnut chart show the information contained in a pie chart for more than one
series. It compares the contribution of each value in multiples numeric data series
makes to the whole, 100%. Values are indicated by the size of the doughnut segments.
Use a doughnut chart to show how the percentages of consumer purchases for the 3
divisions have changed from year to year
When should you use a stacked line, column, or area chart? How do the stacks charts
differ from regular charts? - Answer--Stacked line is used to show the trend of
contribution of each value over time or categories-stacked column is used to to clearly
show the totals for each category . compare the contribution of each value to a total
across categories. stacked area is used to represent cumulated totals using numbers or
percentages over time. Stacked charts show the aggregate amount of all data for that
category, stacked upon one another. They show the cumulative effects of data in
categories
When should you use a 100% stacked line, column, or area chart? How do the stacked
charts differ from regular charts? - Answer--each contribution is expressed as a
percentage
-A 100% stacked column chart displays each category (year) in a column. It shows the
percentage contribution each value to a total
-100% stacked line displays the trend of the contribution of each value over time-100%
stacked area: displays the percentages each value contributes over time
What chart sub-types are available for the stock chart in Excel? Explain how you
interpret the data markers on each of the sub-types - Answer--The data markers
represent the opening & closing price, the highest & lowest price, the decrease &
increase in stock value.
The 4 sub-types are as follows:
*High-Low- Close: range of lowest to highest stock prices for each time period is shown
by a vertical line. the small horizontal line represents the closing price for the time
period
AND ANSWERS
What are the differences and similarities between a line chart and an X Y (scatter )
chart? When should you use each one? - Answer-XY (scatter) chart plots numeric
values on both the y and x axes based on the value of the data
-A line chart plots number values on one axis and category labels equidistantly on the
other axis
-The X Y (Scatter) plots the x-axis in numeric order, and the line chart plots the x-axis
based on the position of the categories in the data range
-Use a XY (scatter) chart when you want to compare sets of numeric data on both the x
and y axis
Explain the difference between the data points in a line chart and an X Y (scatter) chart?
- Answer--For a line chart, data points are plotted along the Y axis based on number
values. the x axis displays categories and plots based on position
-For the XY (scatter) chart- x and y axis are plotted as numeric values
What are the differences between a bar chart and a column chart? Give an example of
when you would use each one - Answer-A Bar chart compares values across categories
in a horizontal orientation. Values are indicated by the length of the bars.
Example: use a bar chart to compare the average price for each product category.
A Column chart compare values across categories in a vertical orientation. Values are
indicated by the height of the columns. Makes it easier to compare the contribution each
category made in a particular year.
Example: use a column chart when comparing the contribution that each type of product
category has made towards revenue for a year. The amount each department made
each year.
What are the differences between a column chart and an area chart? Give an example
of when you would use each one - Answer--A Column chart compare values across
categories in a vertical orientation.
-An area chart displays trends of values over time or by category. Values are indicated
by the filled areas below the lines. area charts combine the features of a line chart with
a bar or column chart.
, -A column chart can be used to compare the amount of each year's sales for each
category. An area chart emphasizes the trend in each category over time.
- a problem with an area chart is one data series might hide another data series
How do pie charts differ from doughnut charts? - Answer--A pie chart displays the
percentage contribution that each category made makes to the whole or 100%. Values
are indicated by the size of the pie slices
-A doughnut chart show the information contained in a pie chart for more than one
series. It compares the contribution of each value in multiples numeric data series
makes to the whole, 100%. Values are indicated by the size of the doughnut segments.
Use a doughnut chart to show how the percentages of consumer purchases for the 3
divisions have changed from year to year
When should you use a stacked line, column, or area chart? How do the stacks charts
differ from regular charts? - Answer--Stacked line is used to show the trend of
contribution of each value over time or categories-stacked column is used to to clearly
show the totals for each category . compare the contribution of each value to a total
across categories. stacked area is used to represent cumulated totals using numbers or
percentages over time. Stacked charts show the aggregate amount of all data for that
category, stacked upon one another. They show the cumulative effects of data in
categories
When should you use a 100% stacked line, column, or area chart? How do the stacked
charts differ from regular charts? - Answer--each contribution is expressed as a
percentage
-A 100% stacked column chart displays each category (year) in a column. It shows the
percentage contribution each value to a total
-100% stacked line displays the trend of the contribution of each value over time-100%
stacked area: displays the percentages each value contributes over time
What chart sub-types are available for the stock chart in Excel? Explain how you
interpret the data markers on each of the sub-types - Answer--The data markers
represent the opening & closing price, the highest & lowest price, the decrease &
increase in stock value.
The 4 sub-types are as follows:
*High-Low- Close: range of lowest to highest stock prices for each time period is shown
by a vertical line. the small horizontal line represents the closing price for the time
period
