Module D

27 Questions | Total Attempts: 151

SettingsSettingsSettings
Please wait...
Module Quizzes & Trivia

Final study


Questions and Answers
  • 1. 
    _____ is an Excel function which allows you to view the entire list while having certain information called to your attention.  
    • A. 

      Basic Filter

    • B. 

      Custom Filter

    • C. 

      Conditional formatting

    • D. 

      Goal Seek

  • 2. 
    Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?  
    • A. 

      Goal Seeking

    • B. 

      Pivot table

    • C. 

      Forms

    • D. 

      Groups

  • 3. 
    To highlight information that meets some criterion that you set, you could use _____ formatting.  
    • A. 

      Auto

    • B. 

      Restrictive

    • C. 

      Conditional

    • D. 

      Limited

  • 4. 
    Which of the following is an action which needs to be performed before using the Goal Seek tool?  
    • A. 

      Creation of a worksheet that includes an objective based on some unknown value in a cell.

    • B. 

      Creation of dimensions of information by specifying how information is to be summarized by dimension.

    • C. 

      Definitions of the dimensions of a list by dragging and dropping information labels or column headings into the row and column areas of a pivot table.

    • D. 

      Entering specific criteria by which a sublist can be created containing only desired information.

  • 5. 
    In the skeletal structure of a pivot table, the _____ area is where you will drop a field of information to create pages or layers.  
    • A. 

      PivotTable Field List

    • B. 

      Report Filter

    • C. 

      Column Labels

    • D. 

      Row Labels

  • 6. 
    What is the difference between a Filter and a pivot table?  
    • A. 

      A Filter requires that rows are sorted by a column or group before they are analyzed; a pivot table does not.

    • B. 

      A Filter can analyze dissimilar information; a pivot table cannot.

    • C. 

      A pivot table provides summary results on groups of information; a Filter shows only rows in some group.

    • D. 

      A pivot table provides more detailed information than a Filter.

  • 7. 
    In a list made using spreadsheet software, which of the following would be a label?  
    • A. 

      An entry made in the third row of the first column.

    • B. 

      An entry made in the third row of the third column.

    • C. 

      An entry made in the first row of the third column.

    • D. 

      An entry made in the last row of the first column.

  • 8. 
    Which spreadsheet term defines a collection of information arranged in columns and rows?  
    • A. 

      Catalog

    • B. 

      Inventory

    • C. 

      List

    • D. 

      Directory

  • 9. 
    A _____ is a description of a list by column.  
    • A. 

      List definition table

    • B. 

      Pivot table

    • C. 

      Feature key

    • D. 

      Column definition

  • 10. 
    When creating a ____, you create dimensions of information by specifying how information is to be summarized by dimension.  
    • A. 

      List definition table

    • B. 

      Pivot table

    • C. 

      Worksheet

    • D. 

      Sublist

  • 11. 
    When you drop information into the "Values" area in the lower-right corner of the skeletal structure of a pivot table, the default aggregation of summarization is ____.  
    • A. 

      Summation

    • B. 

      Division

    • C. 

      Count

    • D. 

      Average

  • 12. 
    Which of the following is true of lists?  
    • A. 

      A list can only contain numerical information (except for labels).

    • B. 

      A list does not usually contain a label for the first column.

    • C. 

      A list does not require a blank line above it if it starts from the first row.

    • D. 

      A list must not have a blank row unless it contains verbal information.

  • 13. 
    _____ is an Excel function that works backward from an objective to compute an unknown value.  
    • A. 

      Pivot table

    • B. 

      Basic Filter

    • C. 

      Custom Filter

    • D. 

      Goal Seek

  • 14. 
    Should a spreadsheet list contain any blank rows?  
    • A. 

      Yes, between groups of records.

    • B. 

      Yes, blank rows should contain borders.

    • C. 

      No, blank rows should only surround the list.

    • D. 

      No, blank rows should be isolated to the definitions.

  • 15. 
    _____ highlights the information in a cell that meets some criteria you specify.  
    • A. 

      Basic Filter

    • B. 

      Custom Filter

    • C. 

      Goal Seek

    • D. 

      Conditional formatting

  • 16. 
    Which of the following is a characteristic that a list must possess?  
    • A. 

      Each row must have only one type of information.

    • B. 

      The first column in the list must contain the labels or column headings.

    • C. 

      The list must not contain any blank columns.

    • D. 

      The list must be bordered on all four sides by blank rows and blank columns.

  • 17. 
    What is the intersection of a row and column in a spreadsheet called?  
    • A. 

      Group

    • B. 

      Block

    • C. 

      Cell

    • D. 

      Object

  • 18. 
    Which of the following elements of the skeletal structure of a pivot table provides a three-dimensional aspect to the pivot table?  
    • A. 

      PivotTable Field List

    • B. 

      "Report Filter" area

    • C. 

      "Row Labels" area

    • D. 

      "Column Labels" area

  • 19. 
    Which spreadsheet feature allows you to hide rows in a list?  
    • A. 

      Conditional formatting

    • B. 

      AutoFilter

    • C. 

      Pivot table

    • D. 

      Data analysis

  • 20. 
    In the skeletal structure of a pivot table, the _____ is the list of fields in the original table that you can work with.  
    • A. 

      Filter Field Area

    • B. 

      Column and Row Field List

    • C. 

      PivotTable Field List

    • D. 

      PivotTable Labels Area

  • 21. 
    _____ allows you to hide all the rows in a list except those that match criteria, besides "is equal to", you specify.  
    • A. 

      Goal Seek

    • B. 

      Basic Filter

    • C. 

      Custom Filter

    • D. 

      Conditional formatting

  • 22. 
    The _____ function allows you to use criteria such as greater than, less than, and so on, to create a sublist of required elements.  
    • A. 

      Basic Filter

    • B. 

      Custom Filter

    • C. 

      Goal Seek

    • D. 

      Conditional formatting

  • 23. 
    Which of the following enables you to group and summarize information?  
    • A. 

      Pivot table

    • B. 

      Conditional formatting

    • C. 

      Basic Filter

    • D. 

      Custom Filter

  • 24. 
    Which of the following spreadsheet features allows you to show only rows from a list that meets a specific condition?  
    • A. 

      Filter

    • B. 

      AutoMatch

    • C. 

      Goal Seek

    • D. 

      Group

  • 25. 
    Which of the following represents the steps for selecting the Goal Seek tool?  
    • A. 

      On the menu bar, click on Value Field Settings, click on Count, and select Goal Seek.

    • B. 

      On the menu bar, click on Insert, and select Goal Seek.

    • C. 

      On the menu bar, click on Data, then click on What-if Analysis, and select Goal Seek.

    • D. 

      On the menu bar, click on Home, click on Conditional Formatting, and select Goal Seek.