By Columns By Rows

Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure.
-When the chart is plotted by rows, what information does it emphasize?
A) comparing the amount of each year's sales for each of the three categories
B) the contribution that each category made to each year's performance
C) the percentage of total sales that each of the three categories make up
D) none of the above

Question

By Columns By Rows
  
Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure.
-When the chart is plotted by rows, what information does it emphasize?
A) comparing the amount of each year's sales for each of the three categories 
B) the contribution that each category made to each year's performance 
C) the percentage of total sales that each of the three categories make up 
D) none of the above

Quizplus · Accepted Answer

When the chart is plotted by rows, it emphasizes the contribution that each category made to each year's performance. This is because each row represents a category and the columns represent the sales for each year. By looking at each row, we can see the proportion of sales for that category in each year, making it clear which categories are contributing the most to overall performance in each year.

By Columns by Rows