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.
-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.
A) CHART EDIT
B) CHART INSERT
C) CHART FORMAT
D) CHART TOOLS FORMAT

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.
-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.
A) CHART EDIT 
B) CHART INSERT 
C) CHART FORMAT 
D) CHART TOOLS FORMAT

Quizplus · Accepted Answer

The Switch Row/Column button is located on the Chart Tools Format tab in the Data group. Therefore, the best choice is D, Chart Tools Format.

By Columns by Rows