ANSWER KEY
Questions 1-35 were worth 2 points each.
36-55 1 point each.  56 and 57 were worth
5 points each.  Total 100 points.
 1. E
 2. C
 3. E
 4. E
 5. B
 6. B
 7. A
 8. E
 9. C
10. B
11. E
12. B
13. B
14. D
15. B
16. B
17. A
18. B
19. C
20. A
21. B
22. B
23. A
24. C
25. E
26. D
27. B
28. D
29. E
30. B
31. C
32. C
33. C
34. C
35. D
36. C
37. A
38. A
39. C
40. B
41. D
42. E
43. B
44. E
45. D
46. A
47. E
48. D
49. D
50. C
51. C
52. C
53. D
54. B
55. A

Short answer questions were 5 points each
There were many ways to answer each of these correctly.
Here are some of the most popular. 

56.     = B3*C3 + (B3*D3*1.5)
57.     = E3-F3-G3   *or*  =E3-($C$12*E3)-($C$13*E3)

CS-1010 Introduction to Computers and Software                                
Midterm Exam, Spring 1999                             v. 1
Jim Allert                                                                    
                                                                              
Select the SINGLE BEST ANSWER to each question.
Record your answers on the answer sheet provided.
QUESTIONS 1-35 are worth 2 points each.  36-55 are worth 1 point.
56 and 57 are worth 5 points each (total 10 points).

QUESTIONS 1-7 and 36-60 are based on the accompanying spreadsheet.

  1. The formula in cell B9 could be 
      
     a. =SUM(B1:B8) 
     b. =TOTAL(B3:B7) 
     c. =TOTAL(B3-B7) 
     d. =AVERAGE(B) 
     e. =SUM(B3:B7) 

  2. This worksheet was printed in which orientation? 
      
     a. oblong 
     b. justified 
     c. landscape 
     d. aligned 
     e. portrait 

  3. Under which menu heading will you find tools to help you 
     change the number of decimal places in cell B3 from 0 to 2? 
      
     a. Data 
     b. Window 
     c. Help 
     d. View 
     e. Format 

  4. To make column A wider you select it and then choose 
     AutoFitSelection from under which menu? 
      
     a. Data 
     b. Window 
     c. Help 
     d. View 
     e. Format 

  5. The formula below is entered in F3. 
     =$C$12 * E3 
     If this formula is copied and pasted into cell F4 
      
     a.  it does not change 
     b.  only references without '$' in front of them will change 
     c.  all references will change 
     d.  only references with '$' in front of them will change 
     e.  it will not work correctly 


                                                      v. 1

  6. $C$12 is called a(n) 
      
     a. relative reference 
     b. absolute reference 
     c. function 
     d. label 
     e. worksheet identifier 

  7. To highlight non-contiguous ranges (such as A3 through A7  
     and C3 through C7) the fastest was, use 
      
     a. the control key (Ctrl) 
     b. the Format menu 
     c. the 'Contiguous ranges' menu selection 
     d. the backslash key '\' 
     e. two different commands 

  8. The Print Preview option can be used to set each of these EXCEPT 
      
     a.  page characteristics 
     b.  margins 
     c.  headers and footers 
     d.  print options 
     e.  'Save As' options 

  9. To print cell formulas you check the 'Formulas' box under 
     the 'View tab' submenu.  Both of these can be found under 
     which menu heading? 
      
     a. View 
     b. Format 
     c. Tools 
     d. Data 
     e. Help 

 10. From the film: Ivan Southerland demonstrated the power of
     graphical computing by using his sketchpad program to draw
     an object resembling
      
     a. a fish
     b. a mushroom
     c. his portrait
     d. an automobile
     e. the solar system

 11. From the film: The GUI was first invented by this company 
      
     a. Apple
     b. IBM
     c. Microsoft
     d. Remmington Rand
     e. Xerox


                                                      v. 1

 12. From the film: The quadrapelegic boy used computers
     to do which of the following?
      
     a. drive a car
     b. read a book
     c. paint a picture
     d. feed himself
     e. call for help

 13. The XEROX 'user illusion' that started true interactive 
     computing 
      
     a. was actually a non-working prototype 
     b. used the office mataphor 
     c. did not integrate touch and vision well 
     d. did not rely on a mouse 
     e. all of the above 

 14. Which of the following represents the username in 
     the Internet address, jda@anyschool.edu? 
      
     a. @ 
     b. anyschool 
     c. edu 
     d. jda 
     e. none of the above 

 15. Under what circumstances can you specify 'jdoe' 
     as the recipient, rather than 'jdoe@my.company.com' 
      
     a. if you want to send email to all jdoe's on internet. 
     b. if jdoe is another user on the same LAN. 
     c. if you are in the same domain as jdoe. 
     d. only if you are 'jdoe' 
     e. You never are required to specify more than 'jdoe' 

 16. If you often send messages to the same group of people 
     at UMD you should do the following: 
      
     a. subscribe to a mailing list 
     b. set up a distribution list 
     c. set up a news group 
     d. type and send the message repeatedly until everyone gets a copy 
     e. send it to one person on the list and ask them 
     to send it to the next, etc. until everyone gets it. 

 17. When participating in a mailing list, where would you 
     send an 'unsubscribe' message? 
      
     a. to the Listserv address 
     b. to the list address 
     c. to the Postmaster of your local LAN 
     d. to the list membership 
     e. It is not possible to 'unsubscribe' to these lists. 


                                                      v. 1

 18. Which of the following is a TRUE statement 
      regarding search engines? 
      
     a. Different search engines can return 
        different results for the same query. 
     b. The same search engine can return different 
        results for the same query (eg. one month apart) 
     c. All search engines return the same lists. 
     d. Search engines usually find nothing at all. 
     e. Search engines results will always pertain 
     to the subject you wanted to explore. 

 19. Which of the following is a FALSE statement about search engines? 
      
     a. Different search engines are likely 
        to give different results for the same query. 
     b. The Netscape Net Search button provides shortcuts 
        to several search engines. 
     c. All the documents that match a query are 
        always displayed on one screen. 
     d. You can access a search engine directly by 
        entering its URL in the location text box. 
     e. Yahoo!, Excite, Lycos and InfoSeek are 
        examples of search engines. 

 20. Which of the following operations should you 
     use between the keywords "American" and 
     "Revolution" to implement the most restrictive search? 
      
     a. AND 
     b. OR 
     c. NOT 
     d. - (the minus sign)
     e. all of these produce the most restrictive search. 

 21. Which of the following will return the largest 
     number of documents regardless of the search 
     engine used? 
      
     a. "Minnesota" AND "Vikings" 
     b. "Minnesota" OR "Vikings" 
     c. "Minnesota" NOT "Vikings" 
     d. "Minnesota Vikings" 
     e. "Minnesota" -"Vikings" 

 22. Which part of the URL 
     http://www.microsoft.com/ie/iedl.htm 
     identifies the internet address of the web site? 
      
     a. http:// 
     b. www.microsoft.com 
     c. /ie/
     d. iedl.htm 
     e. none of the above 


                                                      v. 1

 23. Which part of the URL 
     http://www.microsoft.com/ie/iedl.htm 
     identifies the internet program that 
     loads web pages. 
      
     a. http:// 
     b. www.microsoft.com 
     c. /ie/
     d. iedl.htm 
     e. none of the above 

 24. Which part of the URL 
     http://www.microsoft.com/ie/iedl.htm 
     identifies the path from the site 
     name to the web document? 
      
     a. http:// 
     b. www.microsoft.com 
     c. /ie/ 
     d. iedl.htm 
     e. none of the above 

 25. Which part of the URL 
     http://www.microsoft.com/ie/iedl.htm 
     identifies the size of the document 
     that is being accessed? 
      
     a. http:// 
     b. www.microsoft.com 
     c. /ie/
     d. iedl.htm 
     e. none of the above 

 26. Which part of the URL 
     http://www.microsoft.com/ie/iedl.htm 
     identifies the web page document name. 
      
     a. http:// 
     b. www.microsoft.com 
     c. /ie/
     d. iedl.htm 
     e. none of the above 

 27. To transfer the format from a selected cell to all 
     cells in a range, use 
      
     a. the autoformat selection 
     b. the format painter button 
     c. copy and paste 
     d. merge 
     e. the format duplication menu 


                                                      v. 1

 28. The default chart type is 
     a. a pie chart 
     b. a horizontal bar chart 
     c. an XY (scatter) plot 
     d. a clustered column chart 
     e. a simple line chart 

 29. OLE stands for 
     a. Old Ledger Extension 
     b. Optimum List Exchange 
     c. Optional List Extension 
     d. Optional Link Exchange 
     e. Object Linking and Embedding 

 30. This indicates that a chart has been selected 
     a. the chart selection menu 
     b. the appearance of sizing handles 
     c. the Chart Wizard 
     d. the position of the cursor 
     e. none of the above 

 31. The letters across the top of a worksheet are the ... 
     a. control panel 
     b. row grid 
     c. column grid 
     d. cell coordinates 
     e. entry bar 

 32. Changing entries on a worksheet, viewing the outcome, and 
     comparing it to the original worksheet to determine the 
     effect is called 
      
     a. exiting 
     b. manual recalculation 
     c. 'what-if' analysis 
     d. creating a template 
     e. data retrieval 

 33. These features change the look of a worksheet to make 
     it more understandable and presentable. 
     a. Scrolling 
     b. Editing 
     c. Formatting 
     d. Windowing 
     e. Recalculating 

 34. Selecting contiguous cells in a worksheet is known as 
     a. setting defaults 
     b. entering a label 
     c. defining a range 
     d. designating titles 
     e. autorecalculation 

 35. Apple's landmark television commercial featured
     which of the following?

     a. a loud sports announcer
     b. a small army of landrovers
     c. a cliff
     d. a female athlete
     e. a typical IBM family at home