Case 19-2 Pablo works as an assistant at a local art gallery. He is completing a worksheet that shows sales for the previous year. Now he wants to create a chart to represent the data. Pablo wants to use only part of the data in a column chart. What should he do first?
A) Click the Column button
B) Select the data he wants to use in the chart
C) Click the Insert tab
D) Select all the data in the worksheet

Question

Quizplus · Accepted Answer

Pablo should select the data he wants to use in the chart first before clicking on the Column button or going to the Insert tab. This will ensure that only the desired data is represented in the chart. Selecting all the data in the worksheet or jumping straight to the chart type button or Insert tab could result in irrelevant or confusing data being included in the chart.

Case 19-2 Pablo Works as an Assistant at a Local