MS Excel Visualization MCQs 13

Test your Excel skills with this 20-question MCQ quiz on advanced data visualization! The MS Excel Visualization MCQs quiz covers key chart types like bubble charts, scatter plots, waterfall charts, hierarchy charts, population pyramids, and gauge charts—essential for effective data storytelling. Perfect for analysts, students, and professionals looking to master Excel’s powerful visualization tools. Take the MS Excel Visualization MCQs quiz now and see how well you know Excel charts!

Online MS Excel Visualization MCQs with Answers

• A bubble chart is like a scatter chart, with a third variable, and solves the problem of displaying three variables in a 2-dimensional chart.
• What is the likely cause of the equal-sized bubbles in this 2-D bubble chart?
• Outliers in scatter or bubble charts should always be removed, and no notes need to be made to supplement your chart.
• If we were to add a third set of data, which included the same three variables used to plot the graph below, where the bubble size is the company size, Excel will usually add the new data set in a new colour.
• In Excel, what is hierarchical data?
• Before creating a hierarchy chart, the data must be arranged correctly. The first column must contain the main category.
• Before you create a hierarchy chart, you need to organise your data by size.
• If we re-created the chart below but did not include the main category (in the inner-most ring) and highlighted the main-sub-category as our first category instead, each country would be coloured differently.
• What type of chart is the following?
• The key difference between the Change Colours and Themes functionalities in Excel is that Themes includes suggestions for fonts as well.
• A waterfall chart is ideal for showing the cumulative impact of a series of positive and negative components.
• If a waterfall chart is composed of data from different categories, the order of the categories will impact the shape of the waterfall in the chart.
• What is the following chart type?
• How can we add a picture that is incorporated in the chart, the way it has been below?
• When creating a Map chart, the countries (or states or regions) need to be in alphabetical order.
• Why are some parts of the world shaded in grey in the Map chart below?
• What is the most likely explanation for the Map chart appearing the way below?
• To create a Population chart (population pyramid chart in demography) in Excel, we need to begin with a:
• Consider the Gauge chart below. What would happen to this Combo chart if both chart elements were converted to a Doughnut?
• How can we adjust the vertical axis in the chart below to appear on the extreme left of the chart?

Python Data Visualization Quiz