Excel Advanced 2013

8 Questions | Total Attempts: 69

SettingsSettingsSettings
Please wait...
Excel Advanced 2013

CLICK HERE to access the videos for this course.


Questions and Answers
  • 1. 
    From the following list of choices, select the name of the choice that is a possible type of tablerelationship that can be created between two tables within the “Create Relationships” window.
    • A. 

      (A) Many to many

    • B. 

      (B) One to many

    • C. 

      (C) None to many

    • D. 

      (D) None to none

  • 2. 
    From the following list of choices, select the choice that BEST describes the function of the “Values”quadrant within a PivotTable in Excel 2010:2007.
    • A. 

      (A) Fields that you add to this quadrant will be used as the column labels within the PivotTable.

    • B. 

      (B) Fields that you add to this quadrant will be used as the row labels within the PivotTable.

    • C. 

      (C) Fields that you add to this quadrant will be used as the name of the PivotTable.

    • D. 

      (D) Fields that you add to this quadrant will be the intersecting calculated fields within thePivotTable.

  • 3. 
    From the following list of choices, select the name of the button group within the “PivotTable Tools”contextual tab in the Ribbon that contains the “Field Settings” button in Excel 2010:2007.
    • A. 

      (A) PivotTable

    • B. 

      (B) Actions

    • C. 

      (C) Tools

    • D. 

      (D) Active Field

  • 4. 
    From the following list of choices, select the choice that BEST describes the purpose of the PowerView tool within Excel 2013.
    • A. 

      (A) Power View allows you to view multiple workbooks within a single view.

    • B. 

      (B) Power View is used to create a 3D view that allows you to view multiple worksheets within aworkbook at the same time.

    • C. 

      (C) Power View is a data visualization and reporting tool.

    • D. 

      (D) Power View is a tool used to manage the data within the data model in a visual environment.

  • 5. 
    From the following list of choices, select the name of the choice that is NOT a type of datavisualization that you can create in Power View.
    • A. 

      (A) Map

    • B. 

      (B) Card

    • C. 

      (C) Matrix

    • D. 

      (D) Coordinate

  • 6. 
    From the following list of choices, select the name of the type of object that you CANNOT filter usinga slicer.
    • A. 

      (A) Tables

    • B. 

      (B) PivotTables

    • C. 

      (C) PivotCharts

    • D. 

      (D) Named Ranges

  • 7. 
    From the following list, select the step that should be performed BEFORE applying worksheetprotection in Excel.
    • A. 

      (A) You should select the cells in the worksheet that you do not wish to protect.

    • B. 

      (B) You should lock the cells that you do not want to allow users to change.

    • C. 

      (C) You should unlock cells that you want users to be able to change later.

    • D. 

      (D) You should select the cells in the worksheet that you wish to protect.

  • 8. 
    From the following list, select the choice that BEST describes the purpose of creating macros withinExcel.
    • A. 

      (A) Macros are small programs that allow you to automate repetitive tasks within Excel.

    • B. 

      (B) Macros are “add-in” components that will reprogram functions within Excel.

    • C. 

      (C) Macros create data portals to allow you to import data from SQL Server into Excel.

    • D. 

      (D) Macros are used to apply user restrictions and security on workbooks in Excel.