Tables And Pivot Tables MCQ Quiz Questions And Answers

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS (Computer Science) |
Computer Science
Review Board Member
Godwin is a proficient Database Administrator currently employed at MTN Nigeria. He holds as MS in Computer Science from the University of Bedfordshire, where he specialized in Agile Methodologies and Database Administration. He also earned a Bachelor's degree in Computer Science from the University of Port Harcourt. With expertise in SQL Server Integration Services (SSIS) and SQL Server Management Studio, Godwin's knowledge and experience enhance the authority of our quizzes, ensuring accuracy and relevance in the realm of computer science.
, MS (Computer Science)
Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 13,149
Questions: 10 | Attempts: 9,859

SettingsSettingsSettings
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?


Questions and Answers
  • 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. Columns
    Explanation
    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. Pivot
    Explanation
    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 limits
    Explanation
    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 Layout
    Explanation
    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. Yes
    Explanation
    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. True
    Explanation
    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. Formulas
    Explanation
    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:

Godwin Iheuwa |MS (Computer Science) |
Computer Science
Godwin is a proficient Database Administrator currently employed at MTN Nigeria. He holds as MS in Computer Science from the University of Bedfordshire, where he specialized in Agile Methodologies and Database Administration. He also earned a Bachelor's degree in Computer Science from the University of Port Harcourt. With expertise in SQL Server Integration Services (SSIS) and SQL Server Management Studio, Godwin's knowledge and experience enhance the authority of our quizzes, ensuring accuracy and relevance in the realm of computer science.

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, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Godwin Iheuwa
  • May 06, 2011
    Quiz Created by
    Enzanblaze
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.