1. You want to create a chart that shows last month\'s sales by product line. Th
ID: 3653943 • Letter: 1
Question
1. You want to create a chart that shows last month's sales by product line. The chart needs to show which product line sold the greatest proportion od total sales. Which chart type would most appropriately express these data? a. Pie chart b. column chart c. Line chart d. Bubble chart 2.You need to create a chart that shows the total donations over the past five years. Which chart type would most appropriately express these data? a, Pie chart b. Line chart c. Radar chart d. Column chart 3. The legend in a Pivot Chart distinguishes which components? a. Rows b. Axis Lines c. Series d. Bars 4. You have a saved Pivot Table that summarizes employee bonuses by performance category and city. You change to Pivot Chart view and decide that you need to filter for only the excellent performance category. What will happen to the Pivot Table? a. You must return to the Pivot Table view and filter the Pivot Table to change the chart. b. The Pivot Table will also be filtered for the excellent performance category. c. All of the aggregating statistics will be unchanged in the Pivot Table but the details will disappear. d. Nothing, it is saved. 5. You are working in a Pivot Table and you need to calculate the average of all employee bonuses in each city. To do this, you would: a. Use the Formulas tool, and then select Average. b. Right-click in the first blank row in the design grid, and then select Average from the shortcut menu. c. Create a calculated detail field. d. Use the autoCalc tool. 6. To change the appearance of a Pivot Chart (chart type, chart color, chart captions), you would use the : a. Property sheet b. Show Details command c. AutoCalc tool d. Plot area tool 7. To create a calculated field in a Pivot Table, you would: a. Switch to Design view, and then create a calculated field in query view. b. Click Formulas c. Open the Property Sheet d. You cannot create a calculated field in a Pivot TableExplanation / Answer
1. a
Since the main idea of the chart is to show a product's contribution to the total sales or in other words what proportion of the sales does each product is, a pie chart would be most appropriate. Though the same data can be shown in other representations as well, in each case, the proportion of sales will have to be calculated for every product by the user which is not the case with pie charts.
2. b
A line chart would be sufficient for this as it provides a means to calculate the exact amount of donation each year from the points. It would have been different if it were the case of huge data like 30 or 50 years. But for the calculation for 5 years can be obtained by simply adding all the values.
3. c
4. a
A pivot table is just a visual representation of the requirements of present task. It only allows the user to filter the data according requirement but does not alter the contents of the table . Hence, to view other information from the table, You must return to the Pivot Table view and filter the Pivot Table to change the chart.
5. b
The calculated average must be stored in some cell for displaying it to the user. Hence, right-click in the first blank row in the design grid, and then select Average from the shortcut menu.
6. d
To change the appearance of a Pivot Chart, you would use the plot area tool. It is a standard tool and is used for various appearance modifications to the pivot table.
7. a
To create a calculated field in a Pivot Table, switch to Design view, and then create a calculated field in query view.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.