Charts and Graphs – Excel MCQs

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”