1 Which chart type is best for showing the relationship between two variables?
a) Bar Chart
b) Pie Chart
c) Line Chart
d) Scatter Plot
Answer: d) Scatter Plot
2 What does a pie chart display?
a) Trends over time
b) Parts of a whole
c) Comparisons between different categories
d) Relationships between two variables
Answer: b) Parts of a whole
3 Which chart type is ideal for comparing categories across different periods?
a) Line Chart
b) Column Chart
c) Scatter Plot
d) Pie Chart
Answer: b) Column Chart
4 What feature in Excel allows you to add a visual representation of data trends in a chart?
a) Data Labels
b) Chart Title
c) Data Series
d) Trendline
Answer: d) Trendline
5 In Excel, which chart type is most suitable for showing data changes over a period of time?
a) Bar Chart
b) Column Chart
c) Line Chart
d) Pie Chart
Answer: c) Line Chart
6 What is the purpose of adding a data label to a chart in Excel?
a) To display data values directly on the chart
b) To change the color of the chart
c) To add a chart title
d) To filter data in the chart
Answer: a) To display data values directly on the chart
7 Which type of chart would you use to show the percentage contribution of each category to a total?
a) Scatter Plot
b) Bar Chart
c) Pie Chart
d) Line Chart
Answer: c) Pie Chart
8 How can you change the chart type for an existing chart in Excel?
a) By deleting the chart and creating a new one
b) By right-clicking the chart and selecting “Change Chart Type”
c) By editing the data source
d) By changing the chart title
Answer: b) By right-clicking the chart and selecting “Change Chart Type”
9 What does the X-axis typically represent in a line chart?
a) Categories or time periods
b) Data values
c) Series names
d) Percentages
Answer: a) Categories or time periods
10 In Excel, how can you add a secondary axis to a chart?
a) By selecting “Add Secondary Axis” from the chart tools
b) By using the “Chart Elements” option
c) By right-clicking on the chart and selecting “Format Axis”
d) By selecting “Move Chart” from the chart tools
Answer: c) By right-clicking on the chart and selecting “Format Axis”