Pivot Charts
10 Questions
| Total Attempts: 697
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
Questions: 22 | Attempts: 8140 | Last updated: Mar 22, 2022
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...
Questions: 10 | Attempts: 4588 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
Are you a data analyst? Or are you practicing to become one? In both cases, you must try this 'Data Analyst Excel Test' quiz that is given below. A Data Analyst is skilled enough to translate numbers into comprehensible...
Questions: 10 | Attempts: 3848 | Last updated: May 25, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top