Microsoft Excel

Use of Statistics and Data Analysis in Microsoft Excel, use of Excel Built-in Statistical Functions, Analysis ToolPak, and creating Sheets for different statistical Analyses and Tests.

MS Excel Visualization MCQs 13

by

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 Tables Query Quiz with Answers

1. Consider the Gauge chart below. What would happen to this Combo chart if both chart elements were converted to a Doughnut?

Gauge Chart in MS Excel

 
 
 
 

2. When creating a Map chart, the countries (or states or regions) need to be in alphabetical order.

 
 

3. Why are some parts of the world shaded in grey in the Map chart below?

map chart ms excel quiz

 
 
 

4. Before creating a hierarchy chart, the data must be arranged correctly. The first column must contain the main category.

 
 

5. 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.

 
 

6. In Excel, what is hierarchical data?

 
 
 

7. How can we adjust the vertical axis in the chart below to appear on the extreme left of the chart?

Population chart ms excel quiz

 
 
 
 

8. Outliers in scatter or bubble charts should always be removed, and no notes need to be made to supplement your chart.

 
 

9. What is the most likely explanation for the Map chart appearing the way below?

Map Chart in MS excel Quiz

 
 
 

10. The key difference between the Change Colours and Themes functionalities in Excel is that Themes includes suggestions for fonts as well.

 
 

11. A waterfall chart is ideal for showing the cumulative impact of a series of positive and negative components.

 
 

12. To create a Population chart (population pyramid chart in demography) in Excel, we need to begin with a:

 
 
 
 

13. 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.

MS Excel Visualization Quiz Q3

 
 

14. What is the likely cause of the equal-sized bubbles in this 2-D bubble chart?

bubble chart ms excel quiz 1

 
 
 

15. What is the following chart type?

Funnel Chart MS Excel Quiz

 
 
 
 

16. Before you create a hierarchy chart, you need to organise your data by size.

 
 

17. How can we add a picture that is incorporated in the chart, the way it has been below?

Chart with Picture MS Excel Quiz

 
 
 

18. What type of chart is the following?

Treemap chart in MS Excel Quiz 4

 
 
 
 

19. 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.

bubble chart ms excel quiz 2 size

 
 

20. 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.

 
 

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?
MS Excel Visualization MCQs with Answers: Population chart ms excel quiz

Python Data Visualization Quiz

Excel Tables Query Quiz 12

by

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.

MS Excel Tables Query Quiz with Answers
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

Power Query MCQs 11

by

Test your knowledge of Power Query with these multiple-choice questions! Challenge yourself with these Power Query MCQs and see how well you know data transformations, M language, and query editing. Perfect for Excel users, data analysts, and BI professionals looking to sharpen their data transformation skills. See how well you know Power Query and boost your data skills today! Let us start with the Power Query MCQs now.

Online Power Query MCQs Test with Answers
Please go to Power Query MCQs 11 to view the test

Online Power Query MCQs with Answers

  • Which sources does Power Query allow us to Get Data from?
  • What would happen if you tried to create a query from data in the current workbook that is not part of a table or a named range?
  • In Australia, the first two digits represent the area code for a phone number, such as 0223789456. Consider a field that contains phone numbers in this format. What would be the appropriate option under Split Column to extract the area code?
  • If you are utilising Power Query primarily as a ‘working space’ without viewing the data in your spreadsheet within Close & Load to, you should choose the option:
  • After creating a new Table via Power Query, what would happen when the original data is edited or changed?
  • When getting data from another workbook, it is essential to transform the data within that workbook first.
  • What are some differences between Power Query and standard Excel?
  • Imdad was working in Power Query and loaded the data into a new worksheet. He notices that he has made an error and needs to undo one of his steps. What should he do?
  • When getting data from a database, unlike getting data from a spreadsheet, you have to transform the data at the source first.
  • There are currently three columns in Power Query: Street Address, City, and State, with data such as “42 Wallaby Way” (Street Address), “Sydney” (City), and “NSW” (State). What could we do to create a new column that displayed the full address as a single string, such as “42 Wallaby Way, Sydney, NSW”?
  • If you created a table in Excel after getting data from a database, changing the data in the new table will update the original database if you click Refresh.
  • An American company has 50 offices, one in each state, which all use their own Excel spreadsheet for their human resources data, but the parent company wants to maintain a separate spreadsheet that gets the data from all these files. What would be an efficient solution to this problem?
  • When getting data from a folder, the preview panel only shows a preview of the first file. Suppose there is an Australian company with an office in each of the 8 states and territories, where the parent office is in the state of New South Wales. If the 8 files are named as below, which file will appear in the preview pane, and why? Western Australia South Australia Northern Territory Tasmania Victoria Australian Capital Territory New South Wales Queensland
  • Suppose that we have created a new table by getting data from a folder that contains data from each of 5 branches of a company, each with its file. What should we do if we open two new branches – that maintains the existing structure and also gives unique information for each branch in its file?
  • Which aspect of getting data from a folder is similar to the result of an Append Query?
  • When using an Append Query, the two tables must:
  • Suppose we created 2 queries, one for Sydney and one for Other Instructors. We did not load these into the worksheet; and we only created a connection. Due to this setup, when choosing to append these queries, the result cannot be loaded into the worksheet – we can only create a connection.
  • When getting data from a PDF that contains a table in each of the 5 pages, what will we see in the preview panel?
  • When getting data from a PDF that contains a table in each of 5 pages and selecting multiple items, this will create as many queries as the number of items you have selected.
  • When getting data from a PDF that contains multiple pages, what would be a query that would be usually run, right at the end?

Online Data Science Deep Learning Quiz