Microsoft Office Tutorials and References
In Depth Information
In the Lab
5. Click the Learn-N-Earn Portfolio sheet tab. Select cell B12. Type = (equal sign). Click the
Major Indices sheet tab. Select cell D4 (the last Dow Jones Industrial Average Index). Press the
ENTER key. Select cell B13. Type = (equal sign). Click the Major Indices tab. Select cell D12 (the
last NASDAQ Composite Index). Press the ENTER key. Select cell B14. Type = (equal sign). Click
the Major Indices tab. Select cell D16 (the last Russell 2000 Index). Press the ENTER key. Select
cell B15. Type = (equal sign). Click the Major Indices tab. Select cell D6 (the last Dow Jones
Transportation Average Index). Press the ENTER key. Select cell A16.
6. Change the document properties as specifi ed by your instructor. Select all three worksheets
and then change the header with your name, course number, and other information requested by
your instructor. Add a page number as the footer. Change the top margin to 1.5 inches. Select
cell A16 and then save the workbook using the fi le name, Lab 6-3 Learn-N-Earn Stock Club
Portfolio.
7. Print the three worksheets using the ‘Black and white’ option in landscape orientation. Use the
Fit to option in the Page sheet in the Page Setup dialog box to print the sheets on one page.
8. Select cell A16 and then save the workbook. Submit the assignment as specifi ed by your instructor.
 
Search JabSto ::




Custom Search