Module 4 Skills Review

Module 4 Skills Review

Module 4 Skills Review

1. Plan a chart.
2. Start Excel, open the Data File EX 4-2.xlsx from the location where you store your Data Files, then save it as EX 4-Software Usage Polling Results.

• Create a chart.
• In the worksheet, select the range containing all the data and headings.
• Click the Quick Analysis tool.
• Create a Clustered Column chart, then add the chart title Software Usage, by Business above the chart.
• If necessary, click the Switch Row/Column button so the business type (Accounting, Advertising, etc.) appears as the x-axis.
• Save your work.
• Move and resize a chart.
• Make sure the chart is still selected, and close any open panes if necessary.
• Move the chart beneath the worksheet data.
• Widen the chart so it extends to the right edge of column H.
• Use the Quick Layout button in the Chart Tools Design tab to move the legend to the right of the charted data. (Hint: Use Layout 1.)
• Resize the chart so its bottom edge is at the top of row 25.
• Save your work.
• Change the chart design.
• Change the value in cell B3 to 8. Observe the change in the chart.
• Select the chart.
• Use the Quick Layout button in the Chart Layouts group on the Chart Tools Design tab to apply the Layout 10 layout to the chart, then undo the change.
• Use the Change Chart Type button on the Chart Tools Design tab to change the chart to a Clustered Bar chart.
• Change the chart to a 3-D Clustered Column chart, then change it back to a Clustered Column chart.
• Save your work.
• Change the chart layout.
• Use the Chart Elements button to turn off the primary major horizontal gridlines in the chart.
• Change the font used in the horizontal and vertical axis labels to Times New Roman.
• Turn on the primary major gridlines for both the horizontal and vertical axes.
• Change the chart title’s font to Times New Roman if necessary, with a font size of 20.
• Insert Business as the primary horizontal axis title.
• Insert Number of Users as the primary vertical axis title.
• Change the font size of the horizontal and vertical axis titles to 10 and the font to Times New Roman, if necessary.
• Change “Personnel” in the worksheet column heading to Human Resources, then AutoFit column D, and any other columns as necessary.

1. Change the font size of the legend to 14.
2. Add a solid line border in the default color and a (preset) Offset Diagonal Bottom Right shadow to the chart title.
3. Save your work.
4. Format a chart.
5. Make sure the chart is selected, then select the Chart Tools Format tab, if necessary.
6. Change the shape fill of the Excel data series to Dark Blue, Text 2.
7. Change the shape style of the Excel data series to Subtle Effect – Orange, Accent 6.
8. Save your work.
9. Annotate and draw on a chart.
10. Make sure the chart is selected, then create the text annotation Needs more users.
11. Position the text annotation so the word “Needs” is just below the word “Software” in the chart title.
12. Select the chart, then use the Chart Tools Format tab to create a 1½ pt weight dark blue arrow that points from the bottom center of the text box to the Excel users in the Human Resources category.
13. Deselect the chart.
14. Save your work.
15. Create a pie chart.
16. Select the range A1:F2, then create a 3-D Pie chart.
17. Drag the 3-D pie chart beneath the existing chart.
18. Change the chart title to Excel Users.
19. Apply the Style 7 chart style to the chart, then apply Layout 6 using the Quick Layout button.
20. Explode the Human Resources slice from the pie chart at 25%.
21. In Page Layout view, enter your name in the left section of the worksheet header.
22. Preview the worksheet and charts in Backstage view, make sure all the contents fit on one page, then submit your work to your instructor as directed. When printed, the worksheet should look like Figure 4-26. (Note that certain elements such as the title may look slightly different when printed.)