University of Massachusetts Boston
College of ManagementMSIS 110: Introduction to Computers
Spring 2003 - Exam 2 (Sample)Name: ______
Answer all questions. If any cheating is discovered, severe sanctions will result. Indicate your responses in this sheet. No credit if responses are written elsewhere.
PART / # of Ques. / # CORRECTT/F / 10
MCQ / 21
Short Ans. / 19
TOTAL / 50
Score / /100
1. ______16. ______31. ______46. ______
2. ______17. ______32. ______47. ______
3. ______18. ______33. ______48. ______
4. ______19. ______34. ______49. ______
5. ______20. ______35. ______50. ______
6. ______21. ______36. ______
7. ______22. ______37. ______
8. ______23. ______38. ______
9. ______24. ______39. ______
10. ______25. ______40. ______
11. ______26. ______41. ______
12. ______27. ______42. ______
13. ______28. ______43. ______
14. ______29. ______44. ______
15. ______30. ______45. ______
True/False
Indicate whether the sentence or statement is true or false.
____ 1. An operating system provides networking capability.
____ 2. Multitasking and time-sharing are two terms for the same thing.
____ 3. The database approach to data management helps to reduce program-data dependence.
____ 4. Although usually undesirable, data redundancy can be planned so that user reports or queries can be created more quickly.
____ 5. Usually data marts are larger than data warehouses.
____ 6. Wal-Mart has one of the largest data warehouses in the world.
____ 7. E-commerce presents a major opportunity for the effective use of data mining.
____ 8. The value of data ultimately lies in the decisions it enables.
____ 9. The use of competitive intelligence is illegal and unethical.
____ 10. Knowledge management is the process of capturing a company's collective expertise.
Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
____ 11. The set of computer programs designed to coordinate the activities and functions of the hardware are:
a. / Microsoft Office Suite.b. / application software.
c. / general software.
d. / systems software.
____ 12. ____ software enables users to improve their personal effectiveness, increasing the amount and quality of work they can do.
a. / Spreadsheetb. / Database
c. / Personal productivity
d. / Workgroup
____ 13. ____ refers to the idea that application programs can be developed by a programmer without a through understanding of computer system hardware.
a. / Command processingb. / Hardware independence
c. / Software independence
d. / Memory management
____ 14. Trina Gracy wants her Web Server to seamlessly allow additional users to concurrently access her Web site. She wants her system to have:
a. / virtual memory.b. / paging.
c. / multitasking.
d. / scalability.
____ 15. The biggest shortfall for Linux is:
a. / its lack of power.b. / the scarcity of application programs.
c. / its credibility among IS managers.
d. / the lack of a networking component in its kernel.
____ 16. Windows 2000 is designed with ____ applications in mind.
a. / Internetb. / spreadsheet
c. / personal productivity
d. / COBOL
____ 17. Operating systems such as OS/390 are found on ____ computers.
a. / personalb. / mini
c. / mainframe
d. / super
____ 18. Which of the following is NOT an example of a utility program?
a. / Virus scanning softwareb. / Software to write CDs
c. / Screen saver
d. / Spreadsheet
____ 19. The smallest piece of data used by computers is called a:
a. / byte.b. / character.
c. / bit.
d. / megabyte.
____ 20. In the data hierarchy, a byte typically represents a:
a. / record.b. / bit.
c. / field.
d. / character.
____ 21. A collection of related data fields is called a:
a. / byte.b. / record.
c. / character.
d. / bit.
____ 22. The active cell can be identified in all of the following ways except ______.
a. / a block arrow displays in the center of the cellb. / the active cell reference displays in the Name box
c. / a heavy border surrounds the cell
d. / the column heading and row heading are highlighted
____ 23. The easiest way to select a nonadjacent cell (make it active) is to ______.
a. / type the cell reference in the status barb. / use the function keys located at the top of the typewriter keys on the keyboard
c. / type the cell reference in the formula bar
d. / use the mouse to move the block plus sign to the cell and then click
____ 24. To complete an entry into a cell, click the ______.
a. / Enter box / c. / Cancel boxb. / Function box / d. / Name box
____ 25. Numbers can contain all of the following characters except ______.
a. / + - ( ) / c. / 0 % E eb. / , / . $ / d. / & @ ! ~
____ 26. A character with a point size of 10 is about ______of an inch in height.
a. / 10/18 / c. / 10/72b. / 10/36 / d. / 10/144
____ 27. To display the AutoFormat dialog box shown in the accompanying figure and format a range automatically, use the AutoFormat command on the ______.
a. / File menu / c. / Format menub. / View menu / d. / Data menu
____ 28. The ______preceding a formula is an important part of the formula: it alerts Excel that a formula or function is being entered and not text.
a. / number sign (#) / c. / percent sign (%)b. / dollar sign ($) / d. / equal sign (=)
____ 29. To copy formats to a range of cells, ______.
a. / drag through the range to which the format should be pasted, click the Format Painter button, and then select a cell with the desired formatb. / drag through the range to which the format should be pasted, select a cell with the desired format, and then click the Format Painter button
c. / click the Format Painter button, drag through the range to which the format should be pasted, and then select a cell with the desired format
d. / select a cell with the desired format, click the Format Painter button, and then drag through the range to which the format should be pasted
____ 30. Valid format symbols that can be entered with a number include all of the following except the ______.
a. / asterisk (*) / c. / dollar sign ($)b. / comma (,) / d. / percent sign (%)
____ 31. To freeze the worksheet titles and column titles, use the Freeze Panes command on the ______.
a. / Format menu / c. / Data menub. / Tools menu / d. / Window menu
Completion
Complete each sentence or statement.
32. A computer system that enables a sales representative to run an Internet browser and access a database at the same time uses a processing activity called ______.
33. The primary function of a programming ______is to provide instructions to the computer system so it can perform a processing activity.
34. A first generation programming language uses ______languages for program development.
35. A high-level program written by a programmer is called the ______code.
36. A software ______is a defect in a computer program that keeps it from performing in the manner intended.
37. ______is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.
38. A new blank ______called Book1, such as that illustrated in the accompanying figure, is like a notebook and is created when Excel starts.
39. Inside a workbook, such as that shown in the accompanying figure, are ______, each of which has a name that displays on a sheet tab at the bottom of the workbook.
40. One of the reasons Excel is such a valuable tool is that a(n) ______can be assigned to a cell and Excel will calculate the result.
41. ______can be used in a formula to override the order of operations.
42. Cell references that Excel adjusts when a formula is copied are called ______.
43. Excel includes prewritten formulas called ______that take a value or values, perform an operation, and return a result to the cell.
44. Excel has a function called the ______that displays the highest value in a range.
45. The ______is a format that displays a dollar sign to the left of a number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place).
46. The ______on the Formatting toolbar is used to display a value determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
47. ______is a technique that can be used to conceal data from others.
48. Write an IF function for cell J8 that assigns the text “OK” if the value in cell L9 is three times greater than the value in cell M6; otherwise, have the IF function assign the text “Not OK” to cell J8.
49. Write cell X49 as a relative reference.
50. Write cell X49 as a mixed reference with row varying.
6