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 Pivot Table Quiz 18

by

Test your Excel Pivot Table skills with this 20-question MCQ quiz! This MS Excel Pivot Table Quiz is perfect for students, statisticians, data analysts, and data scientists preparing for exams or job interviews. Master Excel Pivot Table concepts like grouping, filtering, calculations, and custom lists to boost your data analysis efficiency. Excel Pivot Table Quiz, PivotTable MCQ, data analysis test, Excel interview questions, PivotTable exam prep. Let us start MS Excel Pivot Table Quiz now.

Online MS Excel Pivot Table Quiz with Answers

1. What would moving the Europe cell to elsewhere in the PivotTable do?
MS Excel Pivot Table Quiz

 
 
 

2. If you want to filter by a field that you do not necessarily want to show in the PivotTable itself, you should move this field to which quadrant?

 
 
 
 

3. If you choose Show Report Filter Pages after having selected multiple items in a filter, what would happen?

 
 
 
 

4. Converting your data into a Table before creating a PivotTable is a good idea because:

 
 
 

5. Rather than seeing discrete values, if you want to see percentages instead, you should go to

 
 
 

6. When in PivotTable Fields, if you tick a field that contains numeric data, it will automatically populate which quadrant?

 
 
 

7. To clear a filter in a PivotTable, you could:

 
 
 
 

8. You can choose to display a sub-total as a sum and as an average, and both these items will appear separately at the bottom of the respective section in your PivotTable.

 
 

9. Which of the following buttons would we need to click to group the dates below?
MS Excel PivotTable

 
 
 
 
 

10. A PivotTable currently occupies some of Columns A and B as per the screenshot. The formula that is displayed is typed into cell D4. What would happen to the result of the formula if the filters of the PivotTable were modified?
MS Excel Pivot Table Quiz 4

 
 
 

11. To change the calculation within your PivotTable, you get more options by right-clicking one of the values, compared to customizing the calculation in the Values quadrant.

 
 

12. One way to filter which columns and which rows appear in your PivotTable is to use the drop-down menu that appears next to Row Labels and Column Labels.

 
 

13. Before you create a PivotTable, you need to ensure that you have nice clean data with

 
 
 

14. If you have full dates and you create a PivotTable, Excel will group these dates, such as grouping by month. You can remove this by choosing Ungroup.

 
 

15. When in PivotTable Fields, if you tick a field that contains non-numeric data, it will automatically populate which quadrant?

 
 
 
 

16. Choosing the option Rank Smallest to Largest will result in the PivotTable being sorted and displayed from smallest to largest values.

 
 

17. Which of these are correct statements about custom lists in Excel?

 
 
 
 

18. The main difference between Label Filters and Value Filters is that Label Filters are for filtering based on text.

 
 

19. Which of the following buttons would we need to click to group a few rows from our PivotTable?
MS Excel PivotTable Quiz

 
 
 
 
 

20. When does Excel automatically give you sub-totals for your PivotTable?

 
 
 
 

Question 1 of 20

Online MS Excel Pivot Table Quiz with Answers

  • Before you create a PivotTable, you need to ensure that you have nice clean data with
  • Converting your data into a Table before creating a PivotTable is a good idea because:
  • When in PivotTable Fields, if you tick a field that contains numeric data, it will automatically populate which quadrant?
  • When in PivotTable Fields, if you tick a field that contains non-numeric data, it will automatically populate which quadrant?
  • To change the calculation within your PivotTable, you get more options by right-clicking one of the values, compared to customizing the calculation in the Values quadrant.
  • Rather than seeing discrete values, if you want to see percentages instead, you should go to
  • Choosing the option Rank Smallest to Largest will result in the PivotTable being sorted and displayed from smallest to largest values.
  • When does Excel automatically give you sub-totals for your PivotTable?
  • You can choose to display a sub-total as a sum and as an average, and both these items will appear separately at the bottom of the respective section in your PivotTable.
  • If you have full dates and you create a PivotTable, Excel will group these dates, such as grouping by month. You can remove this by choosing Ungroup.
  • Which of the following buttons would we need to click to group the dates below?
  • Which of the following buttons would we need to click to group a few rows from our PivotTable?
  • What would moving the Europe cell to elsewhere in the PivotTable do?
  • Which of these are correct statements about custom lists in Excel?
  • One way to filter which columns and which rows appear in your PivotTable is to use the drop-down menu that appears next to Row Labels and Column Labels.
  • To clear a filter in a PivotTable, you could:
  • The main difference between Label Filters and Value Filters is that Label Filters are for filtering based on text.
  • If you want to filter by a field that you do not necessarily want to show in the PivotTable itself, you should move this field to which quadrant?
  • If you choose Show Report Filter Pages after having selected multiple items in a filter, what would happen?
  • A PivotTable currently occupies some of Columns A and B as per the screenshot. The formula that is displayed is typed into cell D4. What would happen to the result of the formula if the filters of the PivotTable were modified?
Online MS Excel Pivot Table Quiz 4

Try Macroeconomics MCQs Test

Date Time Function Excel 17

by

Test your Excel skills with this 24-question quiz on Date & Time functions! Master from “Date Time Function Excel” Quiz MS Excel formulas like TODAY(), NOW(), TEXT(), NETWORKDAYS, EDATE, and more. Perfect for beginners and advanced users to practice Excel date calculations, formatting, and business-day logic. Let us start with the Date Time Function Excel Quiz now

Please go to Date Time Function Excel 17 to view the test
Date Time Function Excel Quiz Q4

Online Date Time Function Excel Quiz

  • The MS Excel worksheet contains the following data
    What will be an appropriate formula to convert this data into Wednesday, given that the 29th of December 1982 is a Wednesday?
  • The MS Excel worksheet contains the following data:
    What will be the result of the following formula: =TEXT(F3, “DDD/M/YYYY”)?
  • The MS Excel worksheet contains the following data:
    What will be the result of the following formula: =”On “&TEXT(F3,”ddd/m/yyyy”)&” due “&VALUE(RIGHT(C3,6))
  • Currently, cell R2 is formatted as text and holds the value 12. If we convert this to a short date format using the day/month/year system, what will be the result?
  • Assume that today is the 1st of January, 2020, and we are using the day/month/year format for dates.
    What will be the result of the formula: =TODAY()+7
  • Assume that today is the 21st of January, 2020, and we are using the day/month/year format for dates.
    What will be the result of: =TODAY()-7
  • What does the NOW() function do?
  • The worksheet contains the following data:
    The following formulas are typed into the following cells:
    • P2: =DAY(N2)
    • Q2: =MONTH(N2)
    • R2: =YEAR(N2)
    What will the cells P2, Q2, and R2 hold, respectively?
  • Cell N3 currently holds the value: 1/07/2019 (see below), the date that a payment was due (1st of July, 2019).
    What would be an appropriate formula from the list below that returns the number of days overdue? (Note: you have to re-format the cell that contains the result to General)
  • The MS Excel worksheet contains the following data:
    What will be the result of the following formula: =MONTH(G3)?
  • The MS Excel worksheet contains the following data:
    What will be the result of the following formula: =MONTH(1&G3)&”/2020″?
  • The worksheet contains the following data:
    What would be an appropriate formula from the list below to generate the first day of this month, given that the year is 2020?
  • The MS Excel worksheet contains the following data:
    What would be an appropriate formula from the list below to generate the last day of this month, given that the year is 2020?
  • The MS Excel worksheet contains the following data:
    To generate the last day of this month, the following formula is used: =DATE(2020, MONTH(1&B2)+1,1)-1.
    Which option explains the roles of +1, 1, and -1 within the formula the best?
  • Of these three functions, which of these functions returns a number of days: DAYS, WORKDAY, NETWORKDAYS
  • An invoice is due 10 working days after the invoice date.
    Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2?
  • An invoice is due 10 working days after the invoice date.
    Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2, and given that the country has a 3-day weekend of Saturday, Sunday, and Monday?
  • The invoice date is the 3rd of January, 2020, i.e., 3/01/2020, which is held in cell D2. We want to work out how many working days there are between the invoice date and the end of the year, given that the country has a 3-day weekend of Saturday, Sunday, and Monday. What would be an appropriate formula from the list below?
  • The syntax for NETWORKDAYS is NETWORKDAYS(start_date, end_date, [holidays]). If there are 3 public holidays held in cells H3, H4, and H5.
    Which of the following formulas would work when trying to work out the number of working days in 2020?
  • Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
    What will the following formula return (after re-formatting the cell to ‘Date’): =EDATE(F3,1)?
  • Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
    Which of the following is an appropriate formula to calculate the end date of this month?
  • Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
    What is the result of the following formula (after re-formatting the cell to ‘Date’): =EOMONTH(EDATE(F3,1),1)?
  • Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
    What will be the result of the following formula (after re-formatting the cell to ‘Date’): =EDATE(F3,1)-1?
  • Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
    What does the following formula effectively generate =WORKDAY(EDATE(F3,1)-1,1)?

Try Python MCQ Online Test 5

Excel Power Query Questions 16

by

Think you know Excel Power Query Questions? Take this interactive MCQ quiz (about MS Excel Power Query Questions) to test your knowledge on data source in Power Query, Power Query Editor, merging queries, joins (inner, outer, anti), M language, data transformation, and more! Perfect for Excel users, Power BI analysts, and data professionals looking to master ETL (Extract, Transform, Load) techniques. Let us start with the MS Excel Power Query Questions Quiz now.

Online MS Excel Power Query Questions with Answers
Please go to Excel Power Query Questions 16 to view the test

Online Excel Power Query Questions Quiz

  • A Merge Query performs a similar functionality to some Excel functions. Which functions are they?
  • For a Merge Query to work, we do not need the column headings to match; however, we do need the values of one column in one query to relate to the values of a column in the other query.
  • Suppose that we have two queries containing two employment data sets. Each data set has the historical employee details of two subsidiary companies of the same parent organisation. What type of join is required to find out the employees who have worked in both organisations?
  • What could you do if you needed to merge three queries?
  • If you have a query that displays the output from a Right Anti Join, the last few characters of the M code in the formula bar will read JoinKind.RightAnti. What will happen if we edit the text in the formula bar to replace JoinKind.RightAnti with JoinKind.RightOuter and press Enter?
  • What is Power Query primarily used for?
  • In which Microsoft applications can Power Query be used?
  • Which Power Query feature allows combining data from multiple sources?
  • What is the M language in Power Query?
  • How do you refresh data in Power Query?
  • What does “Unpivot Columns” do in Power Query?
  • Which of the following is NOT a data source in Power Query?
  • What is a “Query Step” in Power Query?
  • How can you remove duplicates in Power Query?
  • Where does Power Query store its transformation steps?
  • What does the “Group By” feature in Power Query allow you to do?
  • Which Power Query operation would you use to split a single column into multiple columns?
  • What is the purpose of the “Parameters” feature in Power Query?
  • How can you handle errors (e.g., division by zero) in Power Query?
  • What happens when you disable “Load” for a query in Power Query Editor?

Learn about the R Programming Language