Editing and updating chart data MCQs PowerPoint

By: Prof. Dr. Fazal Rehman Shamil | Last updated: July 23, 2024

1. How can you access the data source for a chart in PowerPoint?

a) Select the chart, go to the “Chart Design” tab, and click on “Edit Data”
b) Right-click on the chart and choose “Edit Data”
c) Use the “Insert” tab to open the data source
d) Go to the “Format” tab and select “Edit Data”
Answer: a) Select the chart, go to the “Chart Design” tab, and click on “Edit Data”

2. What happens when you click “Edit Data” for a chart in PowerPoint?

a) An Excel spreadsheet opens where you can modify the chart data
b) The chart’s formatting options are displayed
c) A new chart is created with default data
d) The chart is deleted from the slide
Answer: a) An Excel spreadsheet opens where you can modify the chart data

3. How do you update the chart data if the data source has changed?

a) Select the chart, go to the “Chart Design” tab, and click on “Refresh Data”
b) Right-click on the chart and choose “Update Data”
c) Use the “Insert” tab to refresh the chart data
d) Go to the “Format” tab and select “Update Chart”
Answer: a) Select the chart, go to the “Chart Design” tab, and click on “Refresh Data”

4. How can you add new data series to an existing chart?

a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to add a new series
b) Right-click on the chart and choose “Add Data Series”
c) Use the “Insert” tab to add new data series
d) Go to the “Format” tab and select “Add Series”
Answer: a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to add a new series

5. What is the function of the “Select Data” option in the “Chart Design” tab?

a) To modify the data range and series for the chart
b) To change the chart type
c) To apply new styles to the chart
d) To edit the chart’s title
Answer: a) To modify the data range and series for the chart

6. How can you remove a data series from a chart?

a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to remove the series
b) Right-click on the data series and choose “Remove”
c) Use the “Insert” tab to delete the data series
d) Go to the “Format” tab and select “Delete Series”
Answer: a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to remove the series

7. What should you do to change the data labels in a chart?

a) Select the chart, go to the “Chart Design” tab, and click on “Add Chart Element” > “Data Labels”
b) Right-click on the data labels and choose “Edit Labels”
c) Use the “Insert” tab to adjust data labels
d) Go to the “Home” tab and select “Edit Data Labels”
Answer: a) Select the chart, go to the “Chart Design” tab, and click on “Add Chart Element” > “Data Labels”

8. How do you adjust the data range used for a chart?

a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to adjust the range
b) Right-click on the chart and select “Change Data Range”
c) Use the “Insert” tab to modify the data range
d) Go to the “Format” tab and select “Adjust Data Range”
Answer: a) Select the chart, go to the “Chart Design” tab, and click “Select Data” to adjust the range

9. What is the purpose of the “Edit Data” command in the “Chart Design” tab?

a) To open the Excel data sheet where you can edit the chart’s data
b) To apply different chart styles
c) To change the chart type
d) To update the chart title
Answer: a) To open the Excel data sheet where you can edit the chart’s data

10. How can you change the chart data labels to show different values?

a) Select the chart, go to the “Chart Design” tab, and click “Add Chart Element” > “Data Labels” to modify their display
b) Right-click on the data labels and select “Change Values”
c) Use the “Insert” tab to adjust the data labels’ values
d) Go to the “Home” tab and choose “Change Data Labels”
Answer: a) Select the chart, go to the “Chart Design” tab, and click “Add Chart Element” > “Data Labels” to modify their display