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.

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 Design tab.

Extra: In Microsoft Excel and other spreadsheet programs, the **Design** tab is part of the Chart Tools contextual tabs that appear when you select a chart. Contextual tabs only appear when certain objects, such as charts, images, or tables, are actively selected within a worksheet. The purpose of these additional tabs is to provide easy access to features that are relevant only to the specific object selected.

When working with charts, the **Design** tab helps you to modify how the chart looks and to change its layout quickly. For instance, you can select different chart styles, add chart elements like titles or data labels, and change the overall layout of the elements within the chart. The **Switch Row/Column** button specifically allows you to toggle the way data is represented in the chart. If your chart’s data series are not displayed in the manner you prefer (for example, your rows are being displayed as columns, and vice versa), clicking this button will swap the rows and columns, which can significantly change the appearance and interpretation of the data in your chart. This is a quick way to change the chart's data orientation without manually editing the data range or opening a dialog box to adjust the chart's data source.