University of Massachusetts Boston



University of Massachusetts Boston

College of Management

MSIS 110: Introduction to Computers

Spring 2003 - Exam 2 | |

Name: ______________________

Answer all questions. Only one (1) answer will be accepted per question.

Provide the best possible or the most appropriate answer.

If any cheating is discovered, severe sanctions will result.

Indicate your responses in this sheet.

No credit if responses are written else-where. Please turn this sheet in.

No makeup exam if you fail to turn this sheet in.

|PART |# of Ques. |# CORRECT |

|T/F | 22 | |

|MCQ | 21 | |

|Short Ans. | 07 | |

|TOTAL | 50 | |

|Score | /100 |

1. _______ 16. _______ 31. _________ 46. _________

2. _______ 17. _______ 32. _________ 47. _________

3. _______ 18. _______ 33. _________ 48. _________

4. _______ 19. _______ 34. _________

5. _______ 20. _______ 35. _________ 49. _________

6. _______ 21. _______ 36. _________

7. _______ 22. _______ 37. _________ 50. _________

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. Systems software helps users solve particular computing problems.

____ 2. An operating system may provide networking capability.

____ 3. Multitasking and time-sharing are two terms for the same thing.

____ 4. Mainframe computers are no longer used very much due to the popularity of the Internet.

____ 5. Utility software has been developed to replace many operating systems.

____ 6. It is always better to develop software in-house than to purchase it.

____ 7. A goal of a DBMS is to minimize data redundancy.

____ 8. Although usually undesirable, data redundancy can be planned so that user reports or queries can be created more quickly.

____ 9. Usually data marts are smaller than data warehouses.

____ 10. The value of data ultimately lies in the decisions it enables.

____ 11. A new workbook opens with three worksheets, but additional worksheets can be added up to a maximum of 255.

____ 12. A number above the worksheet grid, also called the row heading, identifies each column.

____ 13. A letter on the left side of the worksheet grid, also called the column heading, identifies each row.

____ 14. To identify a cell, specify the row number first, followed by the column letter.

____ 15. Keyboard indicators, such as CAPS (Caps Lock), NUM (Num Lock), and SCRL (Scroll) show which keys are engaged.

____ 16. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as these cells contain no data.

____ 17. Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers.

____ 18. Numbers are left-aligned, which means the cell entry is positioned at the far left in the cell.

____ 19. The font type, size, or style can be changed at any time while a worksheet is active.

____ 20. Left alignment, center alignment, and right alignment are used so rarely that Excel relegates the Align Left, Center, and Align Right buttons to the Standard toolbar.

____ 21. Deleting cells is the same as clearing cells.

____ 22. If cell A7 contains the formula =A4+A5 and row 5 is deleted, then Excel assigns the formula =A4+#REF! to cell A6 (originally cell A7) and displays the error message #REF! in cell A6.

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

____ 23. Software that repairs bad diskette sectors is an example of a(n):

|a. |application software. |

|b. |utility program. |

|c. |operating system. |

|d. |DOS command. |

____ 24. Microsoft Office and Corel's WordPerfect Office are examples of:

|a. |workgroup software. |

|b. |operating systems. |

|c. |software suites. |

|d. |enterprise software. |

____ 25. If a software user wishes changes to a master document to be reflected in other client applications, ____ should be used.

|a. |Copying |

|b. |Embedding |

|c. |Linking |

|d. |object oriented encapsulation |

____ 26. If a project manager entered a correct piece of information into a computer program and the resulting output contained an error, the software may have a(n):

|a. |embedded object. |

|b. |software bug. |

|c. |object link. |

|d. |upgrade issue. |

____ 27. Tom's address is stored in two separate files. This is an example of:

|a. |data integrity. |

|b. |data redundancy . |

|c. |program-data dependence. |

|d. |the traditional approach to data management. |

____ 28. The payroll program at Ken's Builders, Inc. generates and maintains its own data files. These files, which are not compatible with any other software, exhibit:

|a. |data integrity. |

|b. |data redundancy. |

|c. |data security. |

|d. |program-data dependence. |

____ 29. Data redundancy can lead to problems with:

|a. |key fields. |

|b. |data integrity. |

|c. |data model range. |

|d. |data domain. |

[pic]

____ 30. In Figure 5.2, the area enclosed by bracket '2' represents:

|a. |key fields. |

|b. |records. |

|c. |attributes. |

|d. |entities. |

____ 31. If Employee # is a unique number, then in figure 5.2, the area of the table represented by bracket '1' is a:

|a. |secondary key. |

|b. |primary key. |

|c. |planned redundancy. |

|d. |tuple. |

____ 32. A more efficient and effective means of organizing data was developed with:

|a. |the database approach to data management. |

|b. |the traditional approach to data management. |

|c. |network databases. |

|d. |the hierarchical approach to data management. |

____ 33. Which of the following is NOT a disadvantage of the database approach to data management?

|a. |High costs of operating DBMS in mainframe environments |

|b. |Increased cost of specialized staff |

|c. |Standardization of data access |

|d. |Increased vulnerability |

____ 34. The __________ close Excel.

|a. |Close button and Control-menu icon on the menu bar |

|b. |Minimize button and Restore icon on the menu bar |

|c. |Close button and Control-menu icon on the title bar |

|d. |Minimize button and Restore icon on the title bar |

____ 35. Excel provides the Undo command on the __________ and the Undo button on the Standard toolbar that can be used to erase the most recent worksheet entries.

|a. |Edit menu |c. |Tools menu |

|b. |Insert menu |d. |Windows menu |

____ 36. To select the nonadjacent range F11, H11, and I11, select cell F11, and then, while holding down the __________ key, drag through the range H11:I11.

|a. |SHIFT |c. |CTRL |

|b. |ALT |d. |HOME |

____ 37. The __________ function sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range.

|a. |MIN |c. |MAX |

|b. |AVERAGE |d. |COUNT |

____ 38. The __________ on the Format menu lets formatting be applied that appears only when the value in a cell meets specified conditions.

|a. |AutoFormat command |c. |Conditional Formatting command |

|b. |Cells command |d. |Style command |

____ 39. To toggle between the values version and the formulas version of a worksheet, press __________.

|a. |ALT+ACCENT MARK (´) |

|b. |ALT+ SINGLE QUOTATION MARK (') |

|c. |CTRL+ACCENT MARK (`) |

|d. |CTRL+SINGLE QUOTATION MARK (') |

____ 40. If cells containing 710 and 730 are copied using the fill handle, the next three values of the extended series will be __________.

|a. |750, 770, 790 |c. |680, 660, 580 |

|b. |740, 720, 700 |d. |775, 770, 765 |

____ 41. A formula using __________ instructs Excel to keep the cell reference B17 constant (absolute) as it pastes the formula to a new location.

|a. |B17 |c. |B$17 |

|b. |$B17 |d. |$B$17 |

[pic]

____ 42. Different parts of a worksheet can be viewed through __________, as shown in the accompanying figure.

|a. |zoom boxes |c. |window panes |

|b. |chart sheets |d. |toolbar docks |

____ 43. Goal seeking assumes the value of __________ referenced directly or indirectly can be changed.

|a. |no cells |c. |two or more cells |

|b. |only one cell |d. |any number of cells |

Completion

Complete each sentence or statement.

44. Two marketing managers are running applications simultaneously on the same workstation. They are using a processing activity called ____________________.

45. Microsoft's _____________________________ is a built-in scripting facility that enables software developers to enhance and customize Office Suite applications.

46. ____________________ is an object-oriented programming language developed by Sun Microsystems.

A high-level program written by a programmer is called the ___________________.

Write an IF function for cell A8 that assigns the text Pass if the value in cell B9 is more than 60; otherwise, have the IF function assign the text Fail to cell A8. Proper notation is required.

Write cell A4 as a absolute reference.

Write cell A4 as a mixed reference with column varying.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download