Microsoft Excel

Are you an MS Excel pro or just getting started with dashboard creation? This 35-question MS Excel Dashboard MCQs Quiz will test your knowledge on MS Excel Dashboards. The MS Excel Dashboard MCQs Test covers the topics:

✅ Dashboard Design Principles (layout, colors, interactivity)
✅ PivotTables & Pivot Charts (dynamic data representation)
✅ Slicers & Filters (making dashboards interactive)
✅ Charts & Visualizations (best chart types for trends, KPIs)
✅ Conditional Formatting & Excel Tables (keeping data updated)
✅ Macros & Hyperlinks (automating dashboard actions)

Who Should Take This MS Excel Dashboard MCQs Quiz?
✔ Data Analysts looking to refine dashboard skills
✔ Excel Users who want to build professional reports
✔ Students & Professionals preparing for interviews
✔ Anyone who loves Excel challenges!

Online MS Excel Dashboard MCQs with Answers

• What are some good dashboard design principles?
• What are some usual considerations regarding the size of a dashboard?
• If your cells in Excel are white with a thin grey outline, one quick way to create a dashboard with a white background is to turn off the gridlines.
• Coloured shapes are more useful placeholders of information in dashboards than colouring the background of cells, as shapes are not restricted to the column width and row height proportions.
• When using an Align tool, such as Align Right, how does Excel determine the alignment of the elements we have highlighted?
• You can place a chart into a dashboard by going to our PivotChart Design tab and selecting Move Chart.
• It is important to edit or format your chart before you move into your dashboard.
• One difference between Pivot Charts and normal charts is that you cannot edit a Pivot Chart to be linked to a different data set.
• You can link a regular chart to a PivotTable.
• If you want to cut/copy, and paste multiple elements, a useful tool is
• Dragging the fill handle down to create multiple charts from one that you have already created is possible if you are using
• One way to add interactivity to your dashboards is by adding
• What will copying and pasting a shape to one of the columns or bars in a chart do?
• It is not good practice to use Pivot Charts based on calculated fields to a dashboard
• To create a slicer, you need to select
• The number of slicers that Excel will allow us to create depends on the
• To make your dashboard interactive, each element of your dashboard will need to have its own slicer.
• The slicer style has to be the same style as you have chosen for your Excel worksheets to appear. For example, if your worksheet windows have grey outlines, so will your slicer.
• If you want to link your slicer to multiple dashboard elements, you should go to:
• How can we choose not to display the Column letters: “A, B, C…” and Row numbers “1, 2, 3…”?
• Suppose that you place a shape to cover an entire chart. Now, what would happen if you changed the outline and fill to No Outline and No Fill, and you activate a link/hyperlink for the shape?
• It is best practice to add a refresh button to a dashboard that contains pivots because
• Once a dashboard has been created, it is best practice to change colours using Colors rather than Themes because:
• When assigning macros to a dashboard, each macro can relate to only one element of the dashboard.
• What is an Excel Dashboard?
• Which Excel feature is most commonly used to create interactive dashboards?
• What type of chart is best for showing trends over time in a dashboard?
• Which tool in Excel allows users to filter dashboard data interactively?
• What is the purpose of using Conditional Formatting in a dashboard?
• Which Excel function is useful for summarizing data in dashboards?
• What does a KPI (Key Performance Indicator) represent in a dashboard?
• Which feature helps in creating mini-charts within a cell for dashboards?
• Why is it important to avoid clutter in an Excel dashboard?
• Which tool connects a dashboard to external data sources?
• What is the primary benefit of using Excel Tables (Ctrl + T) as a data source for dashboards?

Summarizing Data in R Base Package

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!

Please go to MS Excel Visualization MCQs 13 to view the test

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

Think you know Excel tables inside out? Put your knowledge to the test with this interactive Excel Tables Query Quiz! This quiz challenges you on key concepts like structured references, table formatting, sorting/filtering, and data manipulation. Whether you are a beginner or an Excel pro, see how well you can navigate and query tables efficiently. Let us start with the Online MS Excel Tables Query Quiz now.

Please go to Excel Tables Query Quiz 12 to view the test

Online Excel Tables Query Quiz with Answers

• Not all data lends itself to be converted to a Table, usually, it is data organised by columns to represent fields, and rows to represent records.
• If you want to access the sorting and filtering tools for tables, you could:
• Excel automatically recognises that some columns contain a certain kind of format and provides useful filters in light of this, such as text filters for text data.
• The fastest way to sort a table according to a single criterion is to use one of the drop-down menus at the top of each column heading.
• The fastest way to sort a table according to more than one criterion is to use one of the drop-down menus at the top of each column heading.
• Structured references have the following properties:
• Only structured referencing can be used within a Table.
• If a chart is constructed using data from a Table, this will automatically update when data is added/removed from the Table.
• What is the key difference when using structured references within a Table and structured references outside a Table?
• One key automation that tables combined with named ranges allow is that:
• Which of the following does a Table automatically update when creating a new record?
• When updating a Table with a new record, any created Slicers will update.
• Selecting all the data (apart from column headings) in a Table, and clicking delete on the ribbon will:
• Structured references do not allow for automation with tables as we add new records to our database.
• A course has two tables: Table 1 (on the left), which contains all the students who enrolled in the course at the beginning of the school year, and includes students who have dropped out since January. Table 2 (on the right) contains all currently enrolled students in this course who sat for an exam. What type of join do we need to figure out which students have dropped out of the course?
• Tables created through Excel’s table feature allow users to filter ———– by different values.
• Creating tables is as easy as highlighting cells that have already been filled in appropriately and then clicking on the Insert tab and then clicking on the table button.
• Once data in a table gets filtered, you cannot unfilter the table nor get the table back to the original settings. Is this statement correct?
• For a table to work properly, the top row should have column headings. Yes or no?
• What are the keyboard shortcut keys to insert a table?

Take ggplot2 Data Visualization Quiz