Pivot Charts

10 Questions | Total Attempts: 258

Settings
Please wait...
Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    You have created a PivotChart showwing sales by quarter by sales rep.  Before presenting it ti management, you notice the name of a rep who has since been fired.  How do you delete this rep from the chart without deleting the data?
    • A. 

      Make the emloyee's data points and axis titles invisible.

    • B. 

      Click the arrow next to the Sales Rep field and remove the employees name

    • C. 

      You can't delete the rep from the chart without first deleting the data.

    • D. 

      Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart

  • 2. 
    When we create the pivot table and then if we have to make pivot chart in which group of options Tab pivotchart option is located ?
    • A. 

      Action

    • B. 

      Data

    • C. 

      Active field

    • D. 

      Tools

  • 3. 
    In which Tabs of Ribbon Pivot Chart Formatting options are located ?
    • A. 

      Design, layout, Format, Analyze

    • B. 

      Data, Design, Layout, Format

    • C. 

      View, Developer, Design, layout.

  • 4. 
    Filter can not be applicable on pivot Chart.
    • A. 

      True

    • B. 

      False

  • 5. 
    Pivot chart shows the filter on Chart according to the value .
    • A. 

      True

    • B. 

      False

  • 6. 
    Pivotchart can change as you want.
    • A. 

      True

    • B. 

      False

  • 7. 
    pivotchart can move to another sheet.
    • A. 

      True

    • B. 

      False

  • 8. 
    Pivot chart can be in 3-D format.
    • A. 

      True

    • B. 

      False

  • 9. 
    By which Tab of pivot chart tool pivot filter can be removed form pivot chart ?
    • A. 

      Design

    • B. 

      Layout

    • C. 

      Format

    • D. 

      Analyze

  • 10. 
    Which of the following command tabs is unique to an Excel PivotChart?
    • A. 

      PivotChart Tools Design tab

    • B. 

      PivotChart Tools Layout tab

    • C. 

      PivotChart Tools Format tab

    • D. 

      PivotChart Tools Analyze tab