Excel Chapter 10: Exploring Business Intelligence

Questions

Multiple Choice

1. A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n):
   1. Conditional column.
   2. Power Pivot.
   3. XML file.
   4. Power Query.
   5. Key Performance Indicator.
2. To update a Power Query Editor, choose:
   1. Recalculate.
   2. Refresh.
   3. Save As.
   4. Delimit.
   5. Transform.
3. The Slicer tool creates an on-screen window that acts as a(n):
   1. Editor.
   2. Filter.
   3. Scenario.
   4. Sorter.
   5. Query.
4. A combination of instructions, filters, and sorts that establishes a connection to and displays data is a:
   1. Scenario.
   2. Report.
   3. Sorter.
   4. Query.
   5. Numerator.
5. A file format that is designed for exchanging data on the web is called:
   1. XSD.
   2. SFX.
   3. XDE.
   4. CSS.
   5. XML.
6. Available Add-ins for Excel are found in the:
   1. Quick Access toolbar.
   2. Excel Options dialog box.
   3. Home tab.
   4. Excel OneDrive Preferences.r
   5. Excel Developer tab.
7. Calculated data that appears in the Power Query but is not a field in the source data is called a:
   1. Ghost field.
   2. Cell reference.
   3. Custom column.
   4. Dynamic field.
   5. Query field.
8. To display the entire code for a Power Query, click the Advanced Editor button in the Advanced group of the:
   1. Review tab.
   2. Data tab.
   3. Formulas tab.
   4. View tab.
   5. Home tab.
9. The language that is specific to Power Query is:
   1. SQL.
   2. VBA.
   3. M language.
   4. Macro.
   5. XML.
10. A collection of tables and queries in a workbook is called a:
    1. Custom column.
    2. Power Query.
    3. Data model.
    4. PivotTable.
    5. Key field.
11. The Create Relationship dialog box identifies a Table and a Related Table; the Related Table has a:
    1. Relationship field.
    2. Primary column.
    3. Calculated column.
    4. Foreign column.
    5. Matching column.
12. To create a slicer, click the Insert Slicer button in the Filter group on the:
    1. Review tab.
    2. PivotTable Analyze tab.
    3. View tab.
    4. Power Query Tools tab.
    5. Formulas tab..
13. A conditional column uses a(n) _____ to display new data in a query.
    1. IF statement
    2. Merge command
    3. OR statement
    4. Append command
    5. Join
14. Which depicts how a value compares to a measure?
    1. Timeline
    2. Custom calculation
    3. Relationship
    4. Slicer
    5. Key Performance Indicator
15. To save a custom grouping or subset of items in a PivotTable, create a(n):
    1. Key field.
    2. Named set.
    3. Slicer.
    4. Custom calculation.
    5. Foreign column.