Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
In the Lab continued
3. Click the Insert tab on the Ribbon. Click the Bar button in the Charts group on the Ribbon and
then select Clustered Horizontal Cylinder in the Cylinder area. When the chart is displayed on the
worksheet, click the Move Chart button on the Ribbon. When the Move Chart dialog box appears,
click New sheet and then type Bar Chart for the sheet name. Click the OK button.
4. When the chart is displayed on the new worksheet, click the wall behind the bars and then click
the Format contextual tab. Click the Shape Fill button on the Ribbon and then select Gold,
Accent 2, Lighter 80% in the gallery (column 6, row 2). Click the Layout contextual tab. Click
the Chart Title button on the Ribbon and then select Above Chart in the Chart Title gallery. If
necessary, use the scroll bar on the right side of the worksheet to scroll to the top of the chart.
Click the chart title to select it and then type Balance Due as the chart title.
5. Drag the Balance Due tab at the bottom of the worksheet to the left of the Bar Chart tab to
reorder the sheets in the workbook. Preview and print the chart.
6. Click the Balance Due sheet tab. Change the following purchases: customer John Mc Cartan to
$406.58, and customer Pam Paoli to $74.99. The company also decided to change the service
charge from 2.75% to 3.25% for all customers. After copying the adjusted formula in cell F4 to
the range F5:F10, click the Auto Fill Options button and then click Fill without Formatting to
maintain the original formatting in the range F5:F10. The total new balance in cell G11 should
7. Select both sheets by holding down the SHIFT key and then clicking the Bar Chart tab. Preview
and print the selected sheets. Submit the assignment as requested by your instructor. Save the
worksheet using the ﬁ le name, Lab 2-2 Part 2 Jackson’s Bright Ideas Monthly Balance Due Report.
8. Submit the assignment as speciﬁ ed by your instructor.
Instructions Part 3: With your instructor’s permission, e-mail the workbook created in this exercise
with the changes indicated in Part 2 as an attachment to your instructor. Close the workbook without
saving the changes.
In the Lab
Lab 3: Equity Web Queries
Problem: A friend of your family, Benson Yackley, has
learned that Excel can connect to the Web, download
real-time stock data into a worksheet, and then refresh
the data as often as needed. Because you have had
courses in Excel and the Internet, he has hired you as
a consultant to develop a stock analysis workbook. His
portfolio is shown in Table 2–10.
Table 2–10 Benson Yackley’s Stock Portfolio
Instructions Part 1: Start Excel. If necessary, connect to
the Internet. Perform a Web query to obtain multiple
stock quotes (Figure 2–91), using the stock symbols in
the second column of Table 2–10. Place the results of the
Web query in a new worksheet. Rename the worksheet
Real-Time Stock Quotes. Change the document properties, as speciﬁ ed by your instructor. Add a header
with your name, course number, and other information requested by your instructor. Save the workbook
using the ﬁ le name, Lab 2-3 Part 1 Benson Yackley Equities Online. Preview and then print the
worksheet in landscape orientation using the Fit to option.
3/6/07 3:30:24 PM
3/6/07 3:30:24 PM