1 Which feature in Excel allows you to change the color scheme of a chart?
a) Chart Styles
b) Data Labels
c) Chart Title
d) Data Series
Answer: a) Chart Styles
2 How can you add a chart title in Excel?
a) By clicking on the chart and typing directly
b) By selecting “Chart Elements” and then “Chart Title”
c) By using the “Insert” menu and selecting “Title”
d) By right-clicking on the chart and choosing “Format Title”
Answer: b) By selecting “Chart Elements” and then “Chart Title”
3 What does the “Format Axis” option allow you to customize in a chart?
a) The data labels
b) The axis labels, scale, and line style
c) The chart background
d) The chart title
Answer: b) The axis labels, scale, and line style
4 Which option is used to adjust the position of a legend in a chart?
a) Right-click on the legend and select “Format Legend”
b) Drag and drop the legend to a new location
c) Use the “Chart Styles” menu to reposition the legend
d) Delete and reinsert the legend
Answer: b) Drag and drop the legend to a new location
5 How can you change the chart type of a specific data series within an existing chart?
a) By selecting the data series and then choosing “Change Chart Type”
b) By right-clicking on the chart and selecting “Edit Data Series”
c) By using the “Chart Tools” and selecting “Format Data Series”
d) By deleting and recreating the data series
Answer: a) By selecting the data series and then choosing “Change Chart Type”
6 To add data labels to a chart, which steps should you follow?
a) Click on the chart and select “Add Chart Element” then “Data Labels”
b) Right-click on the data series and choose “Add Data Labels”
c) Use the “Chart Styles” to include data labels
d) Add a text box manually to the chart
Answer: a) Click on the chart and select “Add Chart Element” then “Data Labels”
7 Which feature allows you to format the background of a chart?
a) Chart Area
b) Plot Area
c) Data Series
d) Chart Title
Answer: a) Chart Area
8 How can you change the format of a specific data point within a chart?
a) Right-click on the data point and select “Format Data Point”
b) Use the “Format Axis” options
c) Change the data source for the chart
d) Modify the chart style
Answer: a) Right-click on the data point and select “Format Data Point”
9 What is the purpose of the “Chart Elements” button in Excel?
a) To change the chart type
b) To format individual data points
c) To add or remove elements such as titles, legends, and labels
d) To adjust the chart size
Answer: c) To add or remove elements such as titles, legends, and labels
10 To apply a predefined color scheme to a chart, which option should you use?
a) Chart Styles
b) Format Data Series
c) Data Labels
d) Change Chart Type
Answer: a) Chart Styles