Microsoft Office Tutorials and References
In Depth Information
In the Lab
Make It Right continued
d. Use the WordArt button on the Insert tab on the Ribbon to add the chart title, Quarterly Sales.
Choose the Fill – Accent 6, Warm Matte Bevel (column 2, row 6). Move the chart title above
the chart. Change the font size of the chart title to 28.
e. Click the Design tab on the Ribbon and then click the Move Chart button to move the chart
to the Company Totals sheet. Drag the chart to the range A10:F25. Make any necessary
adjustments so that the chart appears as shown in Figure 6–92 on the previous page.
3. Select cell B4, the supposed sum of cell B4 on the 2008 and 2009 sheets. Note that the SUM
function is not referencing cell B4 on the 2008 sheet. Reenter the SUM function and select the
appropriate range to sum. Do the same for cell B5. Copy the range B4:B5 to the range C4:E5.
4. Change the document properties as speciﬁ ed by your instructor. Change the three worksheet
headers to include your name, course number, and other information requested by your instructor.
5. Save the workbook, and submit the revised workbook as requested by your instructor.
Create a workbook using the guidelines, concepts, and skills presented in this chapter. Labs
are listed in order of increasing difﬁ culty.
Lab 1: Using a Template to Create a Multiple-Sheet Workbook
Problem: Rings and Things is a company that specializes in hand jewelry for women. The company
has four stores in Biloxi, Hartford, Peoria, and Seattle and a corporate ofﬁ ce in Indianapolis. All of the
stores sell their products via direct mail, telesales, and walk-ins. Every year, the corporate ofﬁ cers in
Indianapolis use a template to create a year-end sales analysis workbook. The workbook contains four
sheets, one for each of the three stores and one sheet to consolidate data and determine the company
totals. The Consolidated sheet appears as shown in Figure 6–93.