Final Exam – FALL 2000Name_____________________________Part 1Short answersDescribe each of the HTML tags below also specify if the tag requires an end tag?Part 2CSCE 220 – Computerized Information SystemsFinal Exam – FALL 2000Name_____________________________Instructions:- This exam is one hour 50 minutes long and is worth 200 points.- It is closed book and closed notes. Half page notes allowed.- Clearly check your answers and write as neatly as you can.Part 1Short answersWrite the best answer for each question.1. Write the HTML code to link the text “PLU” to PLU’s home page. 2. Write the HTML code to include the image “laugh.gif” on your home page. 3. What should be the first and last tags in an HTML source file? 4-11 Identify eight of the following popular acronyms or abbreviations. You may leave two blanks. Note: If you answer more than eight, only the first eight will be graded. (8 pt./2 each)http FTPURL LANHTML TCP/IPRAM MISGUI CPUDescribe each of the HTML tags below also specify if the tag requires an end tag?12. <B>13. <H1> 14. <LI>15. <A HREF>16. <IMG SRC>17. The Internet uses a series of protocols to transmit data from one computer to another. What is the name of those protocols?a. Hypermediab. HyperText Transfer Protocolc. Transmission Control Protocol/Internet Protocold. None of the above18. The software program, Internet Explorer is an example of aa. Serverb. Web browserc. Gopherd. HTTP19. The first page of the Web document is calleda. The home pageb. Internetc. Gopherd. The URL20. A browser like Internet Explorer reads hypertext documents which are written ina. HyperText Transfer Protocolb. Graphic languagec. Textd. HyperText Markup Language21. Links (references) which are listed in blue and underlined represent a. A well designed word documentb. New links to be exploredc. A nice font colord. Previously visited sites22. URL stands fora. A home pageb. Uniform Resource Locatorc. Both of the aboved. HTTP23. Which of the following is a proper URL?a. www.msn.comb. http://www.c. Netscape’s home paged. http://thomas.loc.gov24. Which of the following represent a way to connect to the Internet:a. Internet providerb. Local Area Network (LAN)c. Dialing in from homed. All of the above25. What is the most efficient way of returning to a Web site you would like to visit in another Internet session?a. Write the URL on a post-it note and put it on your computerb. Use the Go menuc. Add it to your Favoritesd. Type it in the Location boxPart 21. Which of the following may be included in a formula?(a) Cell references(b) Functions(c) Numeric constants(d) All of the above2. Which part of the formula =B9/4+(C6*D7) is considered a constant?(a) B9(b) 4(c) C6(d) D73. How can you tell which cell in a worksheet is the active cell?(a) It is blinking(b) It is displayed in reverse video(c) It is surrounded by a heavy border(d) All of the above4. Assume that cell C4 contains a formula. Where would you see the formula displayed?(a) In cell C4(b) In the formula bar(c) In the Name box(d) In the status bar5. Where is the address of the active cell displayed?(a) In the Name box to the left of the formula bar(b) In the status bar at the bottom of the window(c) In the title bar at the top of the window(d) All of the above6. Which of the following options is changed through the Page Setup command?(a) Margins(b) Orientation (portrait or landscape)(c) Headers and footers(d) All of the above7. Which of the following is true regarding a printed worksheet?(a) It may be printed with or without the row and column headings(b) It may be printed with or without the gridlines(c) It may be printed in landscape or portrait orientation(d) All of the above8. What happens if you double click the border between columns C and D?(a) Column C is hidden(b) Column D is hidden(c) The width of column C is changed to accommodate the widest entry in that column(d) The width of column D is changed to accommodate the widest entry in that column9. How many commands can the Excel Undo button reverse?(a) 1(b) 4(c) 8(d) 1610. In the formula =C10–D10*(B3+B4)+2/B7, which expression would Excel evaluate first?(a) C10-D10(b) B3+B4(c) 2/B7(d) It is not possible to determine without knowing the contents of the referenced cells11. If cells A1, A2, and A3 contain the values 1, 2, and 5, respectively, what value will be displayed in acell containing the formula =(A3-A1)/A2^2+1*A2?(a) 1 c) 0.0625(b) 3 d) 412. Which of the following will compute the average of cells B1 through B4? (a) (B1+B2+B3+B4)/4(b) =AVG(B1:B4)(c) AVERAGE(B1:B4)(d) None of the above13. Cell E3 contains the function =AVERAGE(A3:D3). What will be the contents of cell E4 if the entryin cell E3 is copied to cell E4?(a) =AVERAGE(A3:D3)(b) =AVERAGE(A4:D4)(c) =AVERAGE($A$3:$D$3)(d) =AVERAGE($A$4:$D$4)14. Which of the following is considered an absolute cell reference?(a) C6(b) #B#13(c) $C8(d) $C$815. In the formula =$B$4*C4, which cell address will change when the cell is copied?(a) $B$4(b) C4(c) Both $B$4 and C4(d) Neither $B$4 nor C416. Which of the following command(s) are needed to copy the contents of a cell from one locationto another?(a) The Duplicate command(b) The Copy command(c) The Paste command(d) Both the Copy and Paste commands17. Which of the following is displayed in a cell if the number in the cell is longer than the cellwidth?(a) A series of number signs (########)(b) The value is displayed, but the display is truncated starting from the right-most digits(c) The value is displayed, but the display is truncated starting from the left-most digits(d) The answer depends on whether the cell to the right is empty18. How would the number .05 be displayed if Percent format with 2 decimal places is specified?(a) .05%(b) 5.0%(c) 5.00%(d) 50.00%19. Cell A4 contains the formula =(A1+A2). What will be the contents of cell B4 if the cellentry in cell A4 is moved to cell B4?(a) =(A1+A2)(b) =(B1+B2)(c) It is not possible to determine without knowing the values in cells A1 and A2(d) It is not possible to determine without knowing the values in cells B1 and B220. A formula containing the entry =$B$3 is copied to a cell one column over and two rows down.How will the entry appear in its new location?(a) =$B$3(b) =B3(c) =$C$5(d) =$D$421. Suppose you are creating a worksheet and delete row 3, then format cell A6 as