Florida National University Business Question Business & Finance, Florida National University Florida National University Business Question Question Description Question 1 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 years performance? THE COLUMN CHART THE AREA CHART BOTH A AND B EQUALLY NEITHER A NOR B DO A GOOD JOB Question 2 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. CHART EDIT CHART INSERT CHART FORMAT CHART TOOLS DESIGN Question 3 2 Points____ charts allow three-dimensional data to be plotted in 2-D on two axes. RADAR BUBBLE DOUGHNUT SCATTER Question 4 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? COMPARING THE AMOUNT OF EACH YEARS SALES FOR EACH OF THE THREE CATEGORIES THE CONTRIBUTION THAT EACH CATEGORY MADE TO EACH YEARS PERFORMANCE. THE PERCENTAGE OF TOTAL SALES THAT EACH OF THE THREE CATEGORIES MAKE UP NONE OF THE ABOVE Question 5 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. LAYOUT FORMAT EDIT DESIGN Question 6 2 Points____ are the points in a data series at which the x-axis and y-axis values intersect. DATA SERIES DATA POINTS LEGENDS CHART TITLES Question 7 2 PointsEach segment in a radar chart is _____. ALWAYS THE SAME SIZE AS THE OTHER SEGMENTS ALWAYS A DIFFERENT SIZE THAN THE OTHER SEGMENTS ALWAYS DEPENDENT ON THE OTHER SEGMENTS ALWAYS STATED AS A PERCENTAGE Question 8 2 PointsThe ____ button in the Select Data Source dialog box provides settings for displaying the data series by rows or by columns. SWITCH ROW/COLUMN EDIT HELP TRANSFORM Question 9 2 PointsIn a ____ chart values are indicated by the distance from a center point. COLUMN LINE PIE RADAR Question 10 2 PointsThe ____ is the descriptive text that identifies the charts contents. CHART TITLE CHART LEGEND X-AXIS LABEL Y-AXIS LABEL "Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."