1 Which chart type is best suited for showing comparisons between different categories?
a) Line Chart
b) Pie Chart
c) Bar Chart
d) Scatter Plot
Answer: c) Bar Chart
2 What is the primary purpose of a line chart in Excel?
a) To compare individual data points
b) To show parts of a whole
c) To display trends over time
d) To represent data in percentage
Answer: c) To display trends over time
3 Which chart type is most appropriate for illustrating the proportion of each category within a whole dataset?
a) Column Chart
b) Line Chart
c) Pie Chart
d) Scatter Plot
Answer: c) Pie Chart
4 To visualize the relationship between two sets of numeric data, which chart type should you use?
a) Pie Chart
b) Column Chart
c) Scatter Plot
d) Area Chart
Answer: c) Scatter Plot
5 Which chart type is ideal for showing changes in data across categories or time periods in a horizontal layout?
a) Bar Chart
b) Line Chart
c) Pie Chart
d) Column Chart
Answer: a) Bar Chart
6 What does the X-axis typically represent in a bar chart?
a) Categories
b) Values
c) Time periods
d) Series names
Answer: a) Categories
7 In a pie chart, how is each slice typically labeled?
a) By data values
b) By categories
c) By percentages
d) By both categories and percentages
Answer: d) By both categories and percentages
8 How do you create a combo chart in Excel, combining different chart types like column and line?
a) By selecting “Insert Combo Chart” from the chart options
b) By manually drawing multiple charts on the same sheet
c) By using the “Change Chart Type” option and selecting multiple types
d) By adding data labels to different charts
Answer: a) By selecting “Insert Combo Chart” from the chart options
9 Which chart type would you use to compare the values of different data series across a common category?
a) Pie Chart
b) Line Chart
c) Column Chart
d) Scatter Plot
Answer: c) Column Chart
10 To change the chart type of an existing chart to a different type, what steps should you take?
a) Right-click on the chart and select “Change Chart Type”
b) Edit the data range and reinsert the chart
c) Delete the chart and create a new one
d) Use the “Chart Tools” to apply a different chart style
Answer: a) Right-click on the chart and select “Change Chart Type”