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]
When you create a graph, you ____
A
select all the data.
B
select what you want to affect.
C
select the first cell only.
D
select the entire spreadsheet.
Explanation: 

Detailed explanation-1: -On the Insert tab, select the chart type you want. On the Chart Design tab, select Select Data. Click in the Chart data range box, and then select the data in your worksheet.

Detailed explanation-2: -If you want to compare values, use a pie chart-for relative comparison-or bar charts-for precise comparison. If you want to compare volumes, use an area chart or a bubble chart. If you want to show trends and patterns in your data, use a line chart, bar chart, or scatter plot.

There is 1 question to complete.