Pivot Charts
10 Questions
| Total Attempts: 258
Settings
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
Back to top