Microsoft Excel

The post is about MS Excel Tables Pivot Table Quiz Questions. It contains 20 multiple-choice questions covering the basics of MS Excel Tables, filtering and sorting, and Pivot Tables. Let us start with the MS Excel Tables Pivot Table Quiz Questions now.

Online MS Excel Pivot Table Quiz with Answers

1. After creating a pivot table and selecting it, what pane appears to the right of the pivot table?

 The PivotTable Properties pane

 Additional pivot table examples

 The PivotTable Metadata pane

 The PivotTable Fields pane

2. Which of the following features in Excel provides suggested combinations of data for creating Pivot Tables based on the selected data?

 Filters

 Recommended Pivot Tables

 Timelines

 Slicers

3. Before creating a pivot table, how should you format your data?

 As a table

 Conditional formatting

 Cell size

 Sort & filter

4. A Slicer is essentially a Filter, but is more intuitive and makes interacting with the data simpler.

 TRUE

 FALSE

5. What must you do first before adding another slicer to a pivot table?

 Remove all existing slicers from the pivot table

 Select a cell in the pivot table

 Add additional fields to the pivot table

 Remove all current filters from the pivot table

6. What is automatically added after formatting data as a table?

 Filter drop-downs at the top of columns

 Column headers at the top of columns

 Data bars presented at the top

 Alternate light/dark rows at the bottom

7. The values in the Total Row apply to the whole Table, once the data is filtered, the Total Row will not adjust.

 TRUE

 FALSE

8. When naming a Table, the same restrictions apply just as when naming a Named Range.

 TRUE

 FALSE

9. Removing a Table by clicking on Convert to a Range is not recommended because this will impact all the formulas negatively.

 TRUE

 FALSE

10. How can you add more filters to the pivot table?

 Drag a field to the Filters area of the PivotTable Fields pane

 First add filters to the original table data

 Use a function to add more filters to the pivot table

 Use a formula to add more filters to the pivot table

11. When we add an extra row/column to a Table, it automatically extends.

 FALSE

 TRUE

12. Which of the following does a Table automatically update when creating a new record?

 Updating the Excel file name

 Updating the named ranges

 Updating the relevant formulas

 Updating the data validation

 Updating the conditional formatting

13. What would be the fastest way to observe only the invoices which were over $10,000?

 Click the filter button at the top of the column and select ‘Number Filters’

 Sort the data in ascending order

 Sort the data in descending order

 Click the filter button at the top of the column and check each number over 10,000

14. What should you remove before making a Pivot Table?

 Row labels, columns, data fields

 Blank rows, columns, and cells

 Date fields, value fields, and cells

 Value fields and row labels

15. What do Timelines provide in pivot tables?

 Let you filter specifically on date-related data

 Preview views of different filters

 Set the pivot table to an earlier view

 Provide details of all actions performed during a given period

16. What are slicers?

 On-screen graphical filter objects

 Header filters

 Standard filters

 Split pivot tables

17. When we add an extra row or column to a Named Range, and the Named Range is not part of a Table, it automatically extends.

 FALSE

 TRUE

18. If you want to create a Table, you need to click somewhere in the data before creating it.

 FALSE

 TRUE

19. Suppose that Zara wanted to change the name of a Table, what could she do?

 Click the Table Design tab that appears when clicked anywhere in the table and go to Table Name in the ribbon

 Click anywhere in the table and without going to the Design tab, find Table Name in the ribbon

 Right-click anywhere in the table and go to Table and find Table Name

20. What is one way to remove a slicer or timeline?

 Press CTRL+Z

 Create a new one

 Remove all filters from the pivot table

 Right-click it and select cut

 Loading …

MS Excel Tables Pivot Table Quiz

• What must you do first before adding another slicer to a pivot table?
• What are slicers?
• Which of the following features in Excel provides suggested combinations of data for creating Pivot Tables based on the selected data?
• What should you remove before making a Pivot Table?
• What is automatically added after formatting data as a table?
• After creating a pivot table and selecting it, what pane appears to the right of the pivot table?
• What do Timelines provide in pivot tables?
• What is one way to remove a slicer or timeline?
• Before creating a pivot table, how should you format your data?
• How can you add more filters to the pivot table?
• If you want to create a Table, you need to click somewhere in the data before creating it.
• When naming a Table, the same restrictions apply just as when naming a Named Range.
• Suppose that Zara wanted to change the name of a Table, what could she do?
• When we add an extra row or column to a Named Range, and the Named Range is not part of a Table, it automatically extends.
• When we add an extra row/column to a Table, it automatically extends.
• Which of the following does a Table automatically update when creating a new record?
• A Slicer is essentially a Filter, but is more intuitive and makes interacting with the data simpler.
• What would be the fastest way to observe only the invoices that were over $10,000?
• Removing a Table by clicking on Convert to a Range is not recommended because this will impact all the formulas negatively.
• The values in the Total Row apply to the whole Table, once the data is filtered, the Total Row will not adjust.

R Language and Data Analysis

The post is about MS Excel Quiz Questions. It contains 20 multiple-choice questions covering the basics of MS Excel, filtering and sorting in MS Excel, Cell Reference, If condition, Hlookup, vlookup, xlookup, and text formatting. Let us start with the MS Excel Quiz Questions now.

Please go to MS Excel Quiz Questions 4 to view the test

MS Excel Quiz Questions with Answers

• What happens when one uses the median calculation but selects an even number of values in a range?
• How is a cell reference made as absolute in a formula?
• Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?
• What is one of the easiest common errors or inconsistencies to fix when importing data?
• What is the first thing you should do when checking spelling errors in Excel?
• What feature can you use to fix text that appears in mixed case?
• How to remove all empty rows at the same time in an imported spreadsheet?
• What does VLOOKUP stand for?
• After enabling Filtering, where can one see and access the filter controls?
• The IF function applies to one or two conditions, but what if one needs to apply multiple conditions?
• The difference between HLOOKUP, VLOOKUP, and XLOOKUP is how they look for data. How does each look for data?
• Which of the following formulas contains a mixed reference?
• What is the purpose of the IFS function in Excel?
• In this HLOOKUP function, =HLOOKUP (B3, A2:B12,1), what does the number 1 indicate?
• If you have multiple filters set, how can you clear all of them at once?
• There are two methods to locate and remove duplicated rows in Excel, what is the easiest way?
• Which statement best describes the purpose of filtering the data?
• When you use nested functions, what is required for each of the functions?
• After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers.
• What should you do if you have data in MS Excel that is in all upper-case letters and want to change it so the first letter of each word is capitalized?

Exploring Data Distribution in R Language

Online MCQs about Computer