Question

Task Instructions Add the Year 2022 data series to the chart (using cells B3:D7).

Answer 1

To add the Year 2022 data series to the chart, select the range B3:D7 and insert a line chart.

Step-by-step explanation:

To add the Year 2022 data series to the chart using cells B3:D7, follow these steps:

1. Select cell B3.
2. Hold the Shift key and select cell D7 to select the range B3:D7.
3. Click on the Chart tab in the Excel ribbon.
4. Click on the Insert Line or Area Chart button to insert a line chart.
5. The chart will now display the Year 2022 data series.