1 Which chart type is best suited for showing the distribution of a dataset as parts of a whole?
a) Line Chart
b) Bar Chart
c) Pie Chart
d) Scatter Chart
Answer: c) Pie Chart
2 What feature in Excel allows you to visually highlight specific data points or ranges in a chart?
a) Conditional Formatting
b) Data Labels
c) Chart Styles
d) Trendlines
Answer: b) Data Labels
3 Which chart type would you use to display trends over time with continuous data?
a) Bar Chart
b) Column Chart
c) Line Chart
d) Pie Chart
Answer: c) Line Chart
4 How can you add a secondary axis to a chart in Excel?
a) Right-click on the data series and select “Format Data Series”
b) Use the “Chart Tools” and select “Add Secondary Axis”
c) Insert a new chart and select “Secondary Axis”
d) Use the “Design” tab and choose “Add Secondary Axis”
Answer: a) Right-click on the data series and select “Format Data Series”
5 Which option allows you to combine multiple chart types in a single chart for better data visualization?
a) Change Chart Type
b) Chart Styles
c) Combo Chart
d) Data Series Formatting
Answer: c) Combo Chart
6 What is the purpose of using a scatter plot in Excel?
a) To show the relationship between two numeric variables
b) To compare categories of data
c) To display hierarchical data
d) To show data distribution in a table format
Answer: a) To show the relationship between two numeric variables
7 How can you customize the color scheme of a chart in Excel?
a) By using the “Format” tab under Chart Tools and selecting “Change Colors”
b) By applying conditional formatting to the data range
c) By manually formatting each data series
d) By editing the chart data source
Answer: a) By using the “Format” tab under Chart Tools and selecting “Change Colors”
8 Which feature in Excel charts allows you to display a trend line to show data trends over time?
a) Data Labels
b) Trendline
c) Data Series
d) Chart Title
Answer: b) Trendline
9 To highlight data trends and patterns in a PivotChart, which tool would you use?
a) Slicer
b) Data Bars
c) Conditional Formatting
d) Data Labels
Answer: a) Slicer
10 What is the use of “Chart Elements” in Excel?
a) To add, remove, or format elements like titles, legends, and axes in a chart
b) To change the chart type
c) To adjust data ranges
d) To refresh the chart data
Answer: a) To add, remove, or format elements like titles, legends, and axes in a chart