Do you know how to use Microsoft Office Excel 2010? Try this 'Tables and Pivot tables MCQ quiz' that is given below with questions and answers. In this quiz, we will test you on the basis of the basics of tables and pivot tables present in Microsoft Excel 2010. Try this quiz and see much you know or remember about Excel 2010. This might also help you revise your concepts. So, are you ready to give it a shot?
Rows
Columns
Sections
Values
Pivot
Data
None of them
Both of them
No, highlighting cells disables the ability to create tables.
Yes, it is that simple, but the highlighted cells must have numerical data.
No, you go to the home tab and then click on the table button.
No, creating tables in Excel is horribly complicated.
Yes, it is that simple, but the highlighted cells should not have blank cells.
No, you may change filters up to three times.
Yes
No, you may change filters as many times as you please without limits
No, tables cannot be filtered.
Default Pivot Table Layout
Classic Pivot Table Layout
Master Pivot Table Layout
Operation Geronimo Layout
Yes
No, only rows may have headings.
No
Can't say
The boxes that are checked indicate that the table should filter out that data.
The boxes that are checked indicate that the table will filter in that data.
The boxes that are unchecked indicate that the table will filter out that data.
The boxes that are unchecked indicate that the table will not filter in that data unless values are present.
True
False, pivot tables do not contain enough information for graphs or charts
False, only regular tables may be used to create graphs or charts
False
Column Labels
Values
Report Filter
Formulas
Clicking on the Insert Tab and inserting a Pivot Table
Select data that needs to be analyzed.
Deciding on which fields to use to analyze the data.
None of the above