Excel Charts MCQs (Multiple-Choice Questions)

1. What is the primary purpose of a chart in Microsoft Excel?

1. To visualize data graphically
2. To encrypt worksheet data
3. To replace formulas
4. To protect a workbook

Answer: A) To visualize data graphically

Explanation:

Excel charts represent worksheet data graphically, making comparisons, trends, relationships, and patterns easier to understand.

2. Which Excel tab is primarily used to insert a chart?

1. Home
2. Insert
3. Review
4. Formulas

Answer: B) Insert

Explanation:

Charts can be inserted from the Insert tab by choosing a suitable chart type or using Recommended Charts.

3. Which Excel feature analyzes selected data and recommends suitable chart types?

1. Quick Analysis
2. Recommended Charts
3. Goal Seek
4. Scenario Manager

Answer: B) Recommended Charts

Explanation:

Recommended Charts analyzes the selected data and suggests chart types that may be suitable for presenting it.

4. Which keyboard shortcut can create a chart quickly from selected data in Excel?

1. Alt + F1
2. Ctrl + F1
3. Alt + C
4. Ctrl + Shift + C

Answer: A) Alt + F1

Explanation:

Pressing Alt + F1 creates a chart using the selected data on the current worksheet.

5. Which chart type is commonly used to compare values across different categories?

1. Column chart
2. Stock chart
3. Radar chart
4. Surface chart

Answer: A) Column chart

Explanation:

Column charts are commonly used to compare values among categories and can also show changes over time.

6. In a standard column chart, where are categories typically displayed?

1. Vertical axis
2. Horizontal axis
3. Secondary axis only
4. Depth axis only

Answer: B) Horizontal axis

Explanation:

In a typical column chart, categories appear along the horizontal axis and values are represented along the vertical axis.

7. Which chart type is particularly useful when category labels are long?

1. Bar chart
2. Pie chart
3. Radar chart
4. Surface chart

Answer: A) Bar chart

Explanation:

Bar charts place categories along the vertical axis and values along the horizontal axis, making long category labels easier to display.

8. Which chart is generally suitable for showing a trend over time?

1. Line chart
2. Pie chart
3. Doughnut chart
4. Radar chart

Answer: A) Line chart

Explanation:

Line charts are commonly used to display trends or changes across an ordered sequence such as months, quarters, or years.

9. Which chart is most appropriate for showing how categories contribute to a single whole?

1. Pie chart
2. Scatter chart
3. Stock chart
4. Surface chart

Answer: A) Pie chart

Explanation:

A pie chart displays the relationship of individual values to a whole and is most useful when the categories form one meaningful total.

10. What is a major difference between a pie chart and a doughnut chart?

1. A doughnut chart can contain more than one data series
2. A pie chart always contains two data series
3. A doughnut chart cannot show percentages
4. A pie chart requires X and Y coordinates

Answer: A) A doughnut chart can contain more than one data series

Explanation:

A doughnut chart can represent multiple data series using multiple rings, while a standard pie chart represents one data series.

11. Which chart is specifically designed to display the relationship between X and Y numerical values?

1. Scatter chart
2. Pie chart
3. Doughnut chart
4. Radar chart

Answer: A) Scatter chart

Explanation:

An XY scatter chart uses numerical X and Y values to display relationships between two variables. Excel expects X values in one column or row and corresponding Y values alongside them.

12. Which chart type uses bubble size to represent a third variable?

1. Bubble chart
2. Line chart
3. Pie chart
4. Radar chart

Answer: A) Bubble chart

Explanation:

A bubble chart is a variation of an XY scatter chart in which the size of each bubble represents a third numerical value.

13. Which chart type is useful for showing the relationship of values to a total while emphasizing changes over an ordered category sequence?

1. Area chart
2. Pie chart
3. Scatter chart
4. Stock chart

Answer: A) Area chart

Explanation:

Area charts display values over an ordered sequence and visually emphasize the magnitude and relationship of the plotted values.

14. What does a stacked column chart emphasize?

1. The contribution of individual series to totals
2. Only the smallest value in each category
3. Only X-Y correlation
4. Only percentages without categories

Answer: A) The contribution of individual series to totals

Explanation:

A stacked column chart places multiple series on top of each other so that the total and each series' contribution can be viewed together.

15. What does a 100% stacked column chart show?

1. The percentage contribution of each series to the category total
2. Only absolute values
3. Only the largest series
4. The relationship between two numerical variables

Answer: A) The percentage contribution of each series to the category total

Explanation:

A 100% stacked column chart normalizes each category to 100%, making it useful for comparing percentage contributions across categories.

16. Which chart type is commonly used for stock market data such as open, high, low, and close values?

1. Stock chart
2. Pie chart
3. Radar chart
4. Doughnut chart

Answer: A) Stock chart

Explanation:

Excel provides stock chart subtypes designed for combinations of stock values such as open, high, low, close, and volume.

17. Which stock chart requires Open, High, Low, and Close values?

1. Open-High-Low-Close
2. High-Low-Close
3. Volume-High-Low
4. Close-Open-Volume

Answer: A) Open-High-Low-Close

Explanation:

The Open-High-Low-Close stock chart requires four value series in the appropriate order: Open, High, Low, and Close.

18. Which chart type can be used to compare several data series across multiple categories using axes that radiate from a center?

1. Radar chart
2. Column chart
3. Pie chart
4. Scatter chart

Answer: A) Radar chart

Explanation:

A radar chart displays each category on its own value axis radiating from a central point, allowing several series to be compared across the same categories.

19. Which chart is designed to display geographic data such as countries, states, or postal regions?

1. Map chart
2. Radar chart
3. Stock chart
4. Waterfall chart

Answer: A) Map chart

Explanation:

Excel Map Charts are designed to compare values or categories across geographical regions such as countries, states, counties, or postal codes.

20. Which chart is useful for displaying the distribution of numerical data and identifying potential outliers?

1. Box and Whisker chart
2. Pie chart
3. Doughnut chart
4. Radar chart

Answer: A) Box and Whisker chart

Explanation:

A Box and Whisker chart shows the distribution of data through quartiles and can highlight values outside the whiskers as potential outliers.

21. What is a data series in an Excel chart?

1. A related set of data points plotted in a chart
2. The chart's title only
3. A worksheet's password
4. A collection of chart styles

Answer: A) A related set of data points plotted in a chart

Explanation:

A data series is a set of related values that Excel plots as a group in a chart, such as monthly sales for one product.

22. What is the purpose of a chart legend?

1. To identify different data series
2. To calculate formulas
3. To change worksheet dimensions
4. To create a new workbook

Answer: A) To identify different data series

Explanation:

A legend associates the names of data series with their corresponding visual representations in the chart.

23. Which chart element displays the name or description of the chart?

1. Chart title
2. Legend
3. Plot area
4. Gridline

Answer: A) Chart title

Explanation:

The chart title provides a descriptive heading that communicates what the chart represents.

24. What is the purpose of data labels in an Excel chart?

1. To display values or other information directly on data points
2. To rename worksheets
3. To create database relationships
4. To hide the chart legend

Answer: A) To display values or other information directly on data points

Explanation:

Data labels can display information such as values, category names, series names, or percentages directly on chart data points.

25. Which chart element contains the actual graphical representation of the data points?

1. Plot area
2. Legend
3. Chart title
4. Formula bar

Answer: A) Plot area

Explanation:

The plot area is the region of the chart where the data series, axes, and related graphical elements are displayed.

26. Which chart element provides reference lines that help readers compare values against the axis scale?

1. Gridlines
2. Legend
3. Data table
4. Chart title

Answer: A) Gridlines

Explanation:

Gridlines extend across the plot area and help users visually relate data points to the values shown on the chart axes.

27. What does the horizontal axis usually represent in a standard column chart?

1. Categories
2. Data labels only
3. Chart formulas
4. Worksheet names

Answer: A) Categories

Explanation:

In a standard column chart, categories are generally displayed along the horizontal axis while numerical values are shown along the vertical axis.

28. What does the vertical value axis of a typical column chart represent?

1. Numerical values
2. Worksheet names
3. Category descriptions only
4. Legend positions

Answer: A) Numerical values

Explanation:

The vertical value axis generally provides the numerical scale against which column heights are measured.

29. Which feature allows one chart to display two different chart types?

1. Combo chart
2. Pie chart
3. Radar chart
4. Stock chart

Answer: A) Combo chart

Explanation:

A combo chart combines different chart types, such as columns and a line, within the same chart to communicate different aspects of the data.

30. Why might a secondary axis be useful in a combo chart?

1. When two series have substantially different value scales
2. When a chart has no data
3. To remove all data labels
4. To convert formulas into values

Answer: A) When two series have substantially different value scales

Explanation:

A secondary value axis allows a data series with a different numerical scale to be displayed alongside another series without forcing both to share the same scale.

31. Which Excel feature is particularly useful for creating interactive charts from summarized data?

1. PivotChart
2. WordArt
3. Text Box
4. Page Break Preview

Answer: A) PivotChart

Explanation:

A PivotChart provides an interactive way to visualize summarized data and can be filtered using PivotTable-related controls. Excel can also create a standalone PivotChart.

32. Which feature can be used to filter data displayed in a PivotChart interactively?

1. Slicer
2. Goal Seek
3. Solver
4. Scenario Manager

Answer: A) Slicer

Explanation:

Slicers provide interactive filtering controls that can be used with PivotTables and PivotCharts to focus on selected subsets of data.

33. What is the main purpose of a trendline in an Excel chart?

1. To show or model a trend in the data
2. To rename the chart
3. To add a worksheet
4. To protect the workbook

Answer: A) To show or model a trend in the data

Explanation:

A trendline helps reveal or model the general direction of a data series. Excel provides types such as linear, exponential, linear forecast, and moving average.

34. Which trendline type is commonly used when the relationship is approximately a straight line?

1. Linear
2. Exponential
3. Logarithmic only
4. Polynomial only

Answer: A) Linear

Explanation:

A linear trendline models data using a straight-line relationship and is appropriate when the overall trend is approximately linear.

35. Which trendline can be used to smooth fluctuations in a data series by averaging observations over a specified number of periods?

1. Moving Average
2. Linear
3. Exponential only
4. Logarithmic only

Answer: A) Moving Average

Explanation:

A moving-average trendline smooths fluctuations by calculating averages over a specified number of periods.

36. Which command can be used to change an existing Excel chart from one chart type to another?

1. Change Chart Type
2. Replace Worksheet
3. Convert Formula
4. Switch Workbook

Answer: A) Change Chart Type

Explanation:

After selecting a chart, the Change Chart Type command allows you to choose a different chart type while retaining the underlying chart data.

37. Which Excel command is used to change the range of data represented by a chart?

1. Select Data
2. Goal Seek
3. Data Validation
4. Define Name

Answer: A) Select Data

Explanation:

The Select Data command allows you to change the chart's data range and add, remove, or modify data series.

38. What happens when a chart's data series is rearranged?

1. The order in which the series are plotted can change
2. The worksheet is deleted
3. The chart automatically becomes a pie chart
4. All formulas are removed

Answer: A) The order in which the series are plotted can change

Explanation:

Changing the order of chart data series can change their plotting order and, depending on the chart type, their visual stacking or overlap.

39. Which chart type is generally suitable for showing percentages of a whole when there are only a few categories?

1. Pie chart
2. Scatter chart
3. Stock chart
4. Surface chart

Answer: A) Pie chart

Explanation:

A pie chart can effectively show how a small number of categories contribute to a single total, especially when the differences between shares are easy to distinguish.

40. What type of data arrangement is generally appropriate for an Excel pie chart?

1. One set of values and one corresponding set of category labels
2. Three columns of X, Y, and Z coordinates
3. Open, High, Low, and Close values only
4. Only multiple unrelated numeric series

Answer: A) One set of values and one corresponding set of category labels

Explanation:

Excel's recommended arrangement for a pie chart is one data series together with corresponding category labels.

41. How should data generally be arranged for an XY scatter chart?

1. X values in one column and corresponding Y values in the next column
2. Only category names without numerical values
3. One column containing percentages only
4. Open, High, Low, and Close values

Answer: A) X values in one column and corresponding Y values in the next column

Explanation:

For an XY scatter chart, Excel expects numerical X values and their corresponding Y values arranged in adjacent columns or rows as appropriate.

42. Which chart type is most appropriate for comparing the relationship between advertising spend and sales revenue for individual observations?

1. Scatter chart
2. Pie chart
3. Doughnut chart
4. Radar chart

Answer: A) Scatter chart

Explanation:

Advertising spend and sales revenue are two numerical variables. A scatter chart can display individual X-Y observations and help reveal their relationship.

43. Which chart type is useful for comparing several categories where each category contains multiple component values and the total is important?

1. Stacked column chart
2. Pie chart
3. Scatter chart
4. Radar chart

Answer: A) Stacked column chart

Explanation:

A stacked column chart shows the individual components within each category while also making the category total visible.

44. What is the main purpose of a chart filter?

1. To show or hide selected chart data
2. To change cell formulas into text
3. To remove worksheet protection
4. To create a new workbook

Answer: A) To show or hide selected chart data

Explanation:

Chart filters can be used to control which data series or categories are displayed without necessarily changing the underlying worksheet data.

45. Which chart feature allows the user to display a table of the chart's underlying values below the chart?

1. Data Table
2. Legend
3. Gridlines
4. Trendline

Answer: A) Data Table

Explanation:

A chart Data Table displays the source values associated with the chart directly beneath the graphical area.

46. Consider the following Excel data:

Month    Sales
Jan      120
Feb      150
Mar      190
Apr      220

Which chart is most appropriate for emphasizing the change in sales across the months?

1. Line chart
2. Pie chart
3. Doughnut chart
4. Radar chart

Answer: A) Line chart

Explanation:

The months form an ordered time sequence, and a line chart is well suited to displaying the direction and pattern of change across that sequence.

47. Consider the following Excel data:

Product    Sales
Laptop     850
Monitor    420
Keyboard   180
Mouse      130

Which chart would provide a straightforward comparison of sales among these products?

1. Clustered column chart
2. Scatter chart
3. Stock chart
4. Surface chart

Answer: A) Clustered column chart

Explanation:

The data contains independent product categories and their sales values. A clustered column chart provides a direct visual comparison among the products.

48. A chart contains monthly revenue and profit margin, but revenue is measured in thousands while profit margin is a percentage. Which approach is most appropriate?

1. Use a combo chart with a secondary axis for one of the measures
2. Use a pie chart with both measures in one series
3. Convert both measures to text before creating the chart
4. Use a stock chart automatically

Answer: A) Use a combo chart with a secondary axis for one of the measures

Explanation:

Revenue and percentage margin have different scales and units. A combo chart with a secondary axis can display them together while preserving their separate scales.

49. Consider the following Excel chart data:

Year    Sales
2023    500
2024    620
2025    760
2026    910

Which chart feature could be added to help visualize the overall direction of the sales values?

1. Trendline
2. Data Validation
3. Conditional Formatting only
4. Freeze Panes

Answer: A) Trendline

Explanation:

A trendline can be added to a suitable chart to model and visually communicate the general direction of the data.

50. An Excel worksheet contains monthly sales for three products. The user wants to compare each product's monthly trend while keeping all three series visible in one chart. Which chart setup is most suitable?

1. A line chart with three data series
2. A pie chart with three separate months
3. A single-value doughnut chart
4. A stock chart containing only the sales totals

Answer: A) A line chart with three data series

Explanation:

A line chart can plot each product as a separate data series against the monthly categories, allowing the trends of all three products to be compared across the same time sequence.