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