Tables And Pivot Tables MCQ Quiz Questions And Answers

10 Questions | Attempts: 8360
Share

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 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. 
    Tables created through Excel's table feature allow users to filter ____ by different values.
    • A. 

      Rows

    • B. 

      Columns

    • C. 

      Sections

    • D. 

      Values

  • 2. 
    _____ tables allow filtering through different values.
    • A. 

      Pivot

    • B. 

      Data

    • C. 

      None of them

    • D. 

      Both of them

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

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

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

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

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

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

  • 9. 
    Which of these is NOT included in the PivotTable Field List pane? 
    • A. 

      Column Labels

    • B. 

      Values

    • C. 

      Report Filter

    • D. 

      Formulas

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

Back to Top Back to top