Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab
Create a Web page using the guidelines, concepts, and skills presented in this Web feature.
Labs are listed in order of increasing diffi culty.
1 Creating a Web Page I
Problem: You are a spreadsheet specialist for Aunt Leona’s Pizza, a national chain of pizzerias. Your
manager has asked you to create a Web page from the company’s annual sales workbook.
Instructions Part 1: Start Excel and open the Lab WF-1 Aunt Leonas Pizza Annual Sales workbook
from the Data Files for Students. Perform the following tasks:
1. Add the Web Page Preview command to the Quick Access Toolbar.
2. Review the worksheet and chart so you have an idea of what the workbook contains. Preview the
workbook as a Web page. Close the browser.
3. Save the workbook as a single fi le Web page in a new folder titled Web Feature Exercises using
the fi le name, Lab WF-1 Aunt Leonas Pizza Annual Sales Web Page. Make sure you select Entire
Workbook in the Save area before you click the Save button. Reset the Quick Access Toolbar and
then quit Excel.
4. Start your browser. With the Web page located on the USB fl ash drive, type e:\web feature exercises\
lab wf-1 aunt leonas pizza annual sales web page.mht in the Address box (your USB
fl ash drive may have a different name and letter). When the browser displays the Web page, click
the tabs at the bottom of the window to view the sheets. Close the browser. Submit the assignment
as requested by your instructor.
In the Lab
2 Creating a Web Page II
Problem: You work part-time as a spreadsheet analyst for What-a-Racket Tennis Club. You have been
asked to create a Web page from the workbook that the company uses to project membership dues and
payroll expenses.
Instructions Part 1: Start Excel and open the Lab WF-2 What-a-Racket Tennis Club Projections
workbook from the Data Files for Students. Perform the following tasks:
1. Add the Web Page Preview command to the Quick Access Toolbar.
2. Review the 3-D Bar Chart sheet and the Projected Expenses sheet in Excel. Preview the
workbook as a Web page. Close the browser.
3. Save the workbook as a Web page (select Web Page in the Save as type box) in the Web Feature
Exercises folder using the fi le name, Lab WF-2 What-a-Racket Tennis Club Projections Web
Page. Make sure you select Entire Workbook in the Save area before you click the Save button.
Reset the Quick Access Toolbar and then quit Excel. Saving the workbook as a Web page, rather
than a single fi le Web page, will result in an additional folder being added to the Web Feature
Exercises folder.
4. Start your browser. Type e:\web feature exercises\lab wf-2 what-a-racket tennis club
projections web page.htm in the Address box (your USB fl ash drive may have a different name
and letter). When the browser displays the Web page, click the tabs at the bottom of the window
to view the sheets. Close the browser. Submit the assignment as requested by your instructor.
 
Search JabSto ::




Custom Search