2 PointsCase-Based Critical Thinking Questions Case 3-1
Sarah has put together the same information in two different charts, shown in the figure above, to show to her boss. She is thinking through the pros and cons of each chart type.
Which chart does a better job of emphasizing the contribution that each category made to a particular year’s performance?

1. THE COLUMN CHART
2. THE AREA CHART
3. BOTH A AND B EQUALLY
4. NEITHER A NOR B DO A GOOD JOB

2 PointsCase-Based Critical Thinking Questions Case 3-2

Ross always looks at data in more than one way. He discovered a feature in Excel where he can show the chart By Column and By Rows, shown in the above figure.
Ross discovers a second way to change the rows and columns without opening a dialog box: he simply clicks the Switch Row/Column button in the Data group on the ____ tab.

1. CHART EDIT
2. CHART INSERT
3. CHART FORMAT
4. CHART TOOLS DESIGN

2 Points____ charts allow three-dimensional data to be plotted in 2-D on two axes.

1. RADAR
2. BUBBLE
3. DOUGHNUT
4. SCATTER

2 PointsCase-Based Critical Thinking Questions Case 3-2

Ross always looks at data in more than one way. He discovered a feature in Excel where he can show the chart By Column and By Rows, shown in the above figure.
When the chart is plotted by rows, what information does it emphasize?

1. COMPARING THE AMOUNT OF EACH YEAR’S SALES FOR EACH OF THE THREE CATEGORIES
2. THE CONTRIBUTION THAT EACH CATEGORY MADE TO EACH YEAR’S PERFORMANCE.
3. THE PERCENTAGE OF TOTAL SALES THAT EACH OF THE THREE CATEGORIES MAKE UP
4. NONE OF THE ABOVE

2 PointsTo change the Source Data, click Select Data in the Data group on the Chart Tools ____ tab to open the Select Data Source dialog box.

1. LAYOUT
2. FORMAT
3. EDIT
4. DESIGN

2 Points____ are the points in a data series at which the x-axis and y-axis values intersect.

1. DATA SERIES
2. DATA POINTS
3. LEGENDS
4. CHART TITLES

2 PointsEach segment in a radar chart is _____.

1. ALWAYS THE SAME SIZE AS THE OTHER SEGMENTS
2. ALWAYS A DIFFERENT SIZE THAN THE OTHER SEGMENTS
3. ALWAYS DEPENDENT ON THE OTHER SEGMENTS
4. ALWAYS STATED AS A PERCENTAGE

2 PointsThe ____ button in the Select Data Source dialog box provides settings for displaying the data series by rows or by columns.

1. SWITCH ROW/COLUMN
2. EDIT
3. HELP
4. TRANSFORM

2 PointsIn a ____ chart values are indicated by the distance from a center point.

1. COLUMN
2. LINE
3. PIE
4. RADAR

2 PointsThe ____ is the descriptive text that identifies the chart’s contents.

1. CHART TITLE
2. CHART LEGEND
3. X-AXIS LABEL
4. Y-AXIS LABEL