FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which tab and group in the Chart Tools section of the Ribbon contains the command to switch row and column data?
A
Layout tab, Analysis group
B
Design tab, Type group
C
Design tab, Chart Layouts group
D
Design tab, Data group
Explanation: 

Detailed explanation-1: -This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column.

Detailed explanation-2: -Change font type The “Font” page in the “Format cells” dialog box opens. TAB to the “Font” list. Use the Arrow Keys to select your font and press ENTER.

Detailed explanation-3: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.

Detailed explanation-4: -On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use.

Detailed explanation-5: -You can use Switch Row/Column to change the data being displayed on X-axis to be displayed on Y-axis and vice versa. Click Switch Row / Column. The data will be swapped between X-axis and Y-axis on the chart.

There is 1 question to complete.