Tables And Pivot Tables MCQ Quiz Questions And Answers
(526).jpg "Tables And Pivot Tables MCQ Quiz Questions And Answers - Quiz")
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 how 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?
- 1.
The first step in creating a Pivot Table is:
- A.
Clicking on the Insert Tab and inserting a Pivot Table
- B.
Select data that needs to be analyzed.
- C.
Deciding on which fields to use to analyze the data.
- D.
None of the above
Correct Answer
B. Select data that needs to be analyzed.Explanation
Before you can create a Pivot Table, you must first identify and select the data range you want to analyze. Once the data is selected, you can proceed with inserting a Pivot Table from the Insert tab and determining which fields to use for analysis.Rate this question:
-
- 2.
Tables created through Excel's table feature allow users to filter ____ by different values.
- A.
Rows
- B.
Columns
- C.
Sections
- D.
Values
Correct Answer
B. ColumnsExplanation
Tables created through Excel's table feature allow users to filter columns by different values. This means that users can easily select specific columns and apply filters to display only the data that meets certain criteria. This feature is particularly useful when working with large datasets, as it enables users to quickly analyze and manipulate data based on specific column values. By filtering columns, users can focus on the relevant information and make more informed decisions.Rate this question:
-
- 3.
_____ tables allow filtering through different values.
- A.
Pivot
- B.
Data
- C.
None of them
- D.
Both of them
Correct Answer
A. PivotExplanation
Pivot tables allow filtering through different values. Pivot tables are a data summarization tool used in spreadsheet programs like Microsoft Excel. They allow users to manipulate and analyze large amounts of data by organizing it into a more manageable format. One of the key features of pivot tables is the ability to filter data based on different values, such as specific dates, categories, or numerical ranges. This allows users to focus on specific subsets of data and gain insights more easily.Rate this question:
-
- 4.
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.
- A.
No, highlighting cells disables the ability to create tables.
- B.
Yes, it is that simple, but the highlighted cells must have numerical data.
- C.
No, you go to the home tab and then click on the table button.
- D.
No, creating tables in Excel is horribly complicated.
- E.
Yes, it is that simple, but the highlighted cells should not have blank cells.
Correct Answer
E. Yes, it is that simple, but the highlighted cells should not have blank cells.Explanation
The correct answer is "Yes, it is that simple, but the highlighted cells should not have blank cells." This answer explains that creating tables in Excel is indeed easy, but the highlighted cells should not contain any blank cells. This means that all the cells that are being selected to create a table should have data in them, and not be empty.Rate this question:
-
- 5.
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?
- A.
No, you may change filters up to three times.
- B.
Yes
- C.
No, you may change filters as many times as you please without limits
- D.
No, tables cannot be filtered.
Correct Answer
C. No, you may change filters as many times as you please without limitsExplanation
The statement provided in the question is incorrect. In most table filtering options, you can change filters as many times as you want without any limits. This means that you can apply different filters, remove them, and apply new ones multiple times to manipulate the data in the table according to your requirements. So, the correct answer is that you can change filters as many times as you please without any limitations.Rate this question:
-
- 6.
Which pivot table layout allows dragging fields to the grid in a spreadsheet?
- A.
Default Pivot Table Layout
- B.
Classic Pivot Table Layout
- C.
Master Pivot Table Layout
- D.
Operation Geronimo Layout
Correct Answer
B. Classic Pivot Table LayoutExplanation
The Classic Pivot Table Layout allows dragging fields to the grid in a spreadsheet. This layout is a traditional and widely used format for creating pivot tables. It provides a user-friendly interface that allows users to easily manipulate and organize data by dragging and dropping fields into the desired areas of the grid. The Classic Pivot Table Layout is a popular choice for creating dynamic and interactive reports and analysis in spreadsheet applications.Rate this question:
-
- 7.
For a table to work properly, the top row should have column headings. Yes or no?
- A.
Yes
- B.
No, only rows may have headings.
- C.
No
- D.
Can't say
Correct Answer
A. YesExplanation
In order for a table to work properly, the top row should have column headings. Column headings help to identify and label the data in each column, making it easier for users to understand and interpret the information in the table. Without column headings, it would be difficult to differentiate between different columns and make sense of the data presented in the table. Therefore, it is necessary for the top row of a table to contain column headings.Rate this question:
-
- 8.
Check all that are true.
- A.
The boxes that are checked indicate that the table should filter out that data.
- B.
The boxes that are checked indicate that the table will filter in that data.
- C.
The boxes that are unchecked indicate that the table will filter out that data.
- D.
The boxes that are unchecked indicate that the table will not filter in that data unless values are present.
Correct Answer(s)
B. The boxes that are checked indicate that the table will filter in that data.
C. The boxes that are unchecked indicate that the table will filter out that data.Explanation
The explanation for the given correct answer is that when a box is checked, it means that the table will include or filter in the data that corresponds to that box. On the other hand, when a box is unchecked, it means that the table will exclude or filter out the data that corresponds to that box. This implies that the checked boxes indicate the data that will be included, while the unchecked boxes indicate the data that will be excluded from the table's filtering process.Rate this question:
-
- 9.
Pivot tables that have been created can easily be turned into graphs or charts by simply highlighting the whole pivot table and choosing a graph or chart that you want to create. Is this true?
- A.
True
- B.
False, pivot tables do not contain enough information for graphs or charts
- C.
False, only regular tables may be used to create graphs or charts
- D.
False
Correct Answer
A. TrueExplanation
Pivot tables can indeed be easily turned into graphs or charts by highlighting the entire pivot table and selecting the desired graph or chart format. This is a true statement because pivot tables are designed to summarize and analyze data in a way that makes it easy to visualize patterns and trends. By converting a pivot table into a graph or chart, users can further enhance their understanding of the data and communicate it more effectively.Rate this question:
-
- 10.
Which of these is NOT included in the PivotTable Field List pane?
- A.
Column Labels
- B.
Values
- C.
Report Filter
- D.
Formulas
Correct Answer
D. FormulasExplanation
The PivotTable Field List pane in Microsoft Excel is a tool used to organize and manipulate data in a PivotTable. It allows users to drag and drop fields into different areas of the PivotTable to create a customized view. The options included in the PivotTable Field List pane are Column Labels, Values, and Report Filter. However, Formulas are not included in this pane. Formulas are used to perform calculations within the PivotTable, but they are not listed as a separate category in the Field List pane.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Apr 05, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
May 06, 2011Quiz Created by
Enzanblaze