Name **** ANSWER KEY AT BOTTOM OF FILE **** ______
CS-1010 Introduction to Computers and Software
Midterm Exam, Winter 1999 v. 1
Jim Allert
Select the SINGLE BEST ANSWER to each question.
Record your answers on the answer sheet provided.
QUESTIONS 1-7 and 35-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: IBM's key to mainframe computer market
domination
a. its superior technology
b. its sales and service force
c. being first to come out with new technology
d. the lack of competition
e. all of the above
11. From the film: The 'tyranny of numbers' problem refers to
a. the shortage of programmers
b. the fact that all computers 'think' using binary code
c. the fact that transistorized computers had too many wires
d. the hopeless tangle of internet communications networks
e. Babbage's disappointment with calculation errors
v. 1
12. The patent for inventing the computer is owned by
a. Charles Babbage
b. Alan Turing
c. Eckert and Mauchley
d. IBM (but offered as 'public domain')
e. none of the above
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
ANSWER KEY
1. E
2. C
3. E
4. E
5. B
6. B
7. A
8. E
9. C
10. B
11. C
12. E
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. A <-- No question 35. Everyone got credit for it.
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 4 points each
There were many ways to answer each of these correctly.
Here are some of the most popular.
56-57. = B3*C3 + (B3*D3*1.5)
58-60. = E3-F3-G3 *or* =E3-($C$12*E3)-($C$13*E3)