Tuesday 23 March CDAE 85 Second Quiz Here's an example of an Excel97 Spreadsheet: A B C D E F G 1Income Rent Food Utilities Chocolate Total Expenses Balance 2$550.00$250.00 $125.00 $35.00 $12.00 1. Imagine your active cell is F2 above. Which of the following would be the appropriate formula to enter into that cell? A) =ADD(A2..F2) B) =SUM(B2:E2) C) =TOTAL(A2:E2) D) =SUM(B2:F2) E) =ADD(B2:F2) 2. Imagine you are creating a web page using the method we used in Lab before spring break. You want to insert a picture that you received as an e-mail attachment in Pine. You save the attached picture file (vacation.gif) to your home directory on zoo. Next you want to get the file to your diskette so you can insert it into your local version of the web page. Which of the following procedures will work? A) Send the vacation.gif file as an ASCII file using FTP. B) Copy the vacation.gif file into your public_html directory. C) Upload the vacation.gif file using the Telnet Terminal software. D) Download the vacation.gif file as a Binary file using FTP. E) Use AIX mv command to move the vacation.gif file to A: 3. Imagine you are hired by NASA to design a digital imaging system for a space probe to the planet Neptune. The imaging system uses binary numbers to code for each pixel of the image. The NASA engineers want the imaging system to be able to distinguish 1024 unique shades of brightness in the near-infrared band of the electromagnetic spectrum. What is the minimum number of bits that can be used to code for each pixel, so that each pixel can represent any of 1024 shades of brightness? A) 10 B) 18 C) 64 D) 72 E) 128 4. Which of the following is the reason why most programmers use complied programming languages to write their applications, rather than interpreted programming languages? A) Compiled languages are easier to learn. B) Compiled languages are cheaper to buy. C) Compiled languages are faster to translate. D) Compiled languages keep the source code hidden. E) All of the above. Here is some QBASIC code: 10 SCREEN 9 20 C=50 30 FOR I=1 TO 100 40 CIRCLE(100, 200),C 50 C=C-1 60 NEXT I 5. When you run the above code the computer halts at line 40 with an "Illegal Function Call" error message. Which of the following best explains what went wrong? A) There are no A or B variables B) There is no REM statement to start the program C) The PAINT command is missing D) The circle radius gets too small E) The For-Next loop needs to be larger 6. According to the reading in the Internet Literacy text, a "Cookie" on the Web is which of the following? A) An error message found unexpectedly while surfing the web. B) An unexpected feature found in a Web browser such as Netscape Navigator, or Microsoft Internet Explorer. C) A record about you: e. g. your browsing habits, operating system and browser choice that is recorded and sent back to the web server. D) A small program or game that is included in a file that you download from the web. The cookie is the little treat equivalent to the toy in a cereal box. E) A pocket calculator from Apple Computer that is shaped like a cookie. 7. The term "bug in the program" was first used to describe which of the following? A) A moth was caught in a relay switch that caused computer failure. B) An error occurred because the code of a program was written incorrectly in the assembly programming language. C) The larva of a wood-boring beetle ate through the power cord of the first DEC PDP-8 computer causing the power to go off. D) A spider was caught in the line printer of the UNIVAC-I computer, built by Remmington-Rand Corporation in 1952, causing mis- prints. E) A flight of periodical cicadas that interrupted the radio transmission of data needed for the first ENIAC program. 8. Which of the following is the decimal equivalent of this binary number: 111101? A) 10 B) 31 C) 32 D) 40 E) 61 9. Which of the following best describes a GPL or "copylefted" license agreement? A) Users are free to modify the source code and to sell it without making the new altered source code available. B) Users just receive the binary executable file. The source code remains hidden with the company. However, you may copy and distribute the software to anyone without restriction. C) Users have no access to the source code, and they may run the software only on one machine at a time. Copying and distributing the software is strictly forbidden. D) Users get a cut-down version of the software for free to try for a trial period of a few weeks. If the user decides to use the software from then on, they must buy the full version. E) Users get the source code for free and they may alter the code. However, users agree that any changes they make must be sent back to company and that their altered source code is available for any other user. 10. OK, back to web page construction from Question 2. You are working on a web page saved as MYPAGE.HTML. You open Notepad, open the file and begin typing in more HTML code for your web page. Imagine MYPAGE.HTML and the picture (vacation.gif) are saved on your working diskette. Which of the following tags would you use to insert the vacation.gif picture into your web page? A) <PIC=VACATION.GIF> B) <IMG SRC=http:/www.uvm.edu/~yourid/vacation.gif> C) <IMG SRC=vacation.gif> D) <img src= http:/www.uvm.edu/~yourid/vacation.gif> E) <img pic=vacation.gif> 11. Following along from the previous question. Now imagine you have your web page just the way you want it on your working diskette. Which of the following do we use to transfer your HTML file from your working diskette to your public_html directory or folder on zoo? A) Telnet B) Unix C) FTP D) Pine E) Netscape Navigator 12. OK, you have your HTML file on zoo. You type your URL into the Browser and the "Forbidden" error message comes up on the screen. Which of the following best explains why you can't see your web page? A) You uploaded your html file as a binary file instead of as an ASCII file. B) You forgot to save your html file as a Browser file in Notepad. It was uploaded as a text file. C) The file permissions need to be changed so people browsing the web can see your page. D) Your HTML file is missing from your public_html directory or folder. You must have accidentally uploaded it into your home directory or folder instead. E) People browsing the web will need to enter your password in order to see the file. 13. You decide to work on the problem described in the previous question. You login to zoo and enter the terminal type and are now at your zoo prompt. Which of the following is the next step you need to do in order to check if your MYPAGE.HTML file is in your public_html directory? A) ls B) cd public_html C) pine D) ftp E) chmod 644 *.* 14. After exploring you find out that your file MYPAGE.HTML is in fact inside your public_html directory where it should be. You next decide to try to change the permissions on the files to make them visible to the outside world. Which of the following commands do you use? A) chmod 755 ~ B) pico MYPAGE.HTML C) pine MYPAGE.HTML D) chmod 644 *.* E) chmod 755 public_html 15. According to the video we have been watching at the end of lecture, the Internet was started by which of the following organizations? A) The U.S. Advanced Research Projects Administration (ARPA) B) National Aeronautics and Space Administration (NASA) C) IBM D) AT&T E) National Science Foundation (NSF) 16. Which of the following files would most likely NOT be an ASCII file? A) Readme.txt B) .signature C) circle.bas D) budget.xls E) e-mail.txt 17. Imagine you are logged in to your home directory on zoo at the operating system (AIX/Unix) prompt (zoo>). You want to check to see what files are in your home directory or folder. Which of the following commands do you use? A) ls B) sd AIX C) cd main.dir D) pine E) pico 18. Which of the following is NOT a spreadsheet? A) Quattro Pro B) Visicalc C) Lotus Freelance D) Supercalc E) Excel 19. Imagine you are using MS-Word97. You block out a section of text and now you wish to copy that section. Which of the following smart buttons do you click on to copy the blocked section?
|
|
|
|
|
|
|
|
|
|
|
|
Here is a chart. Assume the data are real and that you polled 9 people about the number of colds they get/yr. and their vitamin C consumption per day:
20. Imagine you are asked to interpret the above graph. Which
of the following is closest to the correct interpretation?
A) There is no relationship between Vitamin C consumption and the number
of colds people get each year.
B) The graph proves that Vitamin C consumption lowers the number of
colds people get per year.
C) There is a weak relationship showing that people are less likely
to get a cold if their vitamin C consumption is lowered.
D) There is a weak relationship showing that of the people polled,
those who consumed more vitamin C tend to have fewer colds.
E) The graph proves that Vitamin C consumption raises the number of
colds people get per year.