USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Design
|
|
|
Layout
|
|
|
Format
|
|
|
Analyze
|
Detailed explanation-1: -On the Insert tab, select the Insert Chart dropdown menu, and then click any chart option. The chart will now appear in the worksheet. When you click anywhere in the chart, the Chart tab appears in the ribbon.
Detailed explanation-2: -Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Design, and then click the More button in the PivotTable Styles gallery to see all available styles. Pick the style you want to use. If you don’t see a style you like, you can create your own.
Detailed explanation-3: -On the Design tab, in the PivotTable Style Options group, do one of the following: To alternate each row with a lighter and darker color format, click Banded Rows. To alternate each column with a lighter and darker color format, click Banded Columns.
Detailed explanation-4: -Change PivotChart Type Click the Design tab on the ribbon. Click the Change Chart Type button. Select a new chart type and click OK.