FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these statements about creating charts is TRUE?
A
You can change the chart type even after it has been created.
B
Charts are always 2-dimensional
C
A chart cannot be moved once it’s created.
D
You must select your data first before creating a chart.
Explanation: 

Detailed explanation-1: -You can change the type of chart you think would best represent your data at any time. To change the Clustered Column to Pie, select your chart. On the Chart Design tab, click Change Chart Type > Pie > Pie. Your new chart type will show in your spreadsheet.

Detailed explanation-2: -Apply a custom chart template to a new or an existing chart To apply the custom template to an existing chart, click on the chart, and then click Chart Design tab on the ribbon > click Change Chart Type > click Templates, and then select the custom template.

Detailed explanation-3: -Change the format of a selected chart element Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then select the chart element that you want to format.

Detailed explanation-4: -You can create a chart for your data in Excel for the web. Depending on the data you have, you can create a column, line, pie, bar, area, scatter, or radar chart. Click anywhere in the data for which you want to create a chart. To plot specific data into a chart, you can also select the data.

There is 1 question to complete.