CSCI 220 - Lab Assignment #2Lab date: Friday, September 29, 2000Due Thursday October 5, 2000Learning Objectives:This lab will focus on three areas: web browsers, e-mail, and Excel. At the end of this lab assignment, the student should feel comfortable:1.exploring the World Wide Web using a browser like Netscape and a search engine such as Yahoo2.sending, receiving, and replying to electronic mail messages.3.creating and formatting a simple Excel spreadsheet. This includes:a)entering data into a spreadsheet: utilizing the AutoFill and speed entry features.b)formatting labels using font formatting and justificationc)formatting data using date, number, and currency formatsd)creating formulas using relative cell addressese)adjusting columns using the AutoAdjust featuref) printing a formatted spreadsheet g)printing a spreadsheet showing data and formulas.Web Browser 11 points*E-mail your answers to these questions to your grader: for example: [email protected], with the subject Lab 2 and a carbon copy (cc:) to your instructor [email protected] or [email protected] Netscape to explore the following URLs: http://www.usps.gov http://www.plu.edu http://www.ci.tacoma.wa.us And answer the next questions:1. How much will you pay if you want to send 15 postcards to Canada? (Use Rate Calculator)2. Using News & Information services, give calendar of Events on September 29, 2000. (What events? Where? Do you have to pay if you would like to attend?)3. How can you get an overnight camping permit for the Wonderland Trail on Mt. Rainier? *Use one of the Internet search engines (e.g., http://www.hotbot.com, http://www.northernlight.com, http://www.yahoo.com/) to explore the net! Write down the name of the search engine that you used, the addresses (URLs) of the two most interesting sites you found. Write one or two sentences describing each of these sites.*This work must be completed by the end of the lab.E-Mail 8 points*Send another message to your grader, with the subject: My Future (Lab2), and a carbon copy (cc:) to yourinstructor, that includes the following information: A paragraph about where you see yourself 5 years from now.Reply to the message your grader has sent you. In your reply, write a paragraph about the first time you used a computer.*This work (except for the reply in part 2) must be completed by the end of the lab.CS220 - Lab Assignment # 2Due October 5, 2000Excel 21 pointsIn this Lab, we will be creating a checkbook register using Excel. In another lab you add additional features to it and analyze your spending habits. You will have a working register you can use for your personal or businessfinances.Save your work frequently and make a backup copy of all your work on another diskette! Late assignments due to deleted, damaged or lost files/disks will not be accepted.1. Use Excel to create the attached spreadsheet. Your final spreadsheet should look exactly like it (except include your name where indicated).2. When creating the spreadsheet:a) use the Bookman Old Style font, size 18 for the title of your spreadsheet b) use the Arial font, size 12 for the rest of your spreadsheetc) the title of the spreadsheet is bold italics and centered over the columnsd) each column heading is bold, underlined and centerede) the check numbers and dates are right justifiedf) the dates are formatted using the mm/dd/yy formatg) the items and descriptions are left justifiedh) the withdrawal, deposit and balance columns are formatted for currency (dollar sign, two decimal places)i) use formulas with relative cell references in column G and rows 48-50. 3. You can save yourself typing time by:a) using the AutoFill feature whenever possibleb) use format painter or highlight cells you want formatted the samec) use the fill handle to copy formulas4. Print this spreadsheet. Make sure your columns are adjusted so all the information is visible. UsePage Setup under the File menu to include column and row headings and fit to 1 page.5. Print this spreadsheet showing all formulas used. To do this, follow the instructions below:a) From the menu bar select Tools: Options: View.b) In the Windows Option area, click on the box next to Formulas and then click on the OK button.c) The entire worksheet will display unformatted data and formulas.d) Make sure all the data and formulas are visible. You may need to adjust each column. If you end up with more than one sheet, that's o.k.e) Print the worksheet. f) To revert back, unselect the Formulas option.What to turn in:For both the part turned in during lab and the part turned in on the due date:1. Netscape & E-mail: Nothing to turn in. Just make sure your grader replies to your e-mail messages. These messages (except for your reply) must be sent by the end of your lab period.2. Excel: One printout of the Excel spreadsheet showing the formatting and data.One printout of the Excel spreadsheet showing the data and