Rferro.com



CIS 112 Final Exam Spring 2011

Instructions: Upon receipt of this exam, you must save and rename it by replacing the words Your Name with your actual name. Enter your name into the header of this document, as indicated above, so that it will appear on the top of each page (Insert Tab > Header > Edit Header). There are a total of 100 possible points that you can earn on this final exam, which will account for 10% of your final grade. Each problem is worth one point each, unless otherwise indicated. If you do not follow the appropriate selection methods indicated below you will lose up to ½ point per problem for each correct solution. Upon completion of this exam, you must submit it to me via email at rferrobcc@ no later than midnight on Tuesday, May 17. The email subject should be CIS 112 Final Exam Your Name.

Multiple Choice and True / False: Using the Text Highlight tool (Home Tab > Font Group), highlight the option that you feel to be the best solution. You should use the yellow highlight color to select both the letter and word(s) to indicate your selection.

Matching : Next to each number, type the appropriate letter and highlight it (using the color yellow) to indicate your selection.

MS Word 2007

1. If a document contains multiple illustrations, each figure should have a(n) ____.

a. caption c. bookmark

b. index d. topic

2. To see how a document looked before any changes were made, click the Display for Review button arrow and then click ____.

|a. |Original Showing Markup |c. |Original |

|b. |Pre-Markup |d. |Source |

3. You can do all of the following with the Track Changes Options box EXCEPT ____.

|a. |change how deletions are marked |

|b. |change the way that table changes are indicated |

|c. |change how balloons are printed |

|d. |change the name of the person editing the document |

4. When you insert a formatted header, you are working with a(n) ____.

|a. |AutoComplete |c. |AutoText |

|b. |building block |d. |control field |

5. Word generates a table of figures from the ____ in the document.

|a. |indices |c. |topics |

|b. |bookmarks |d. |captions |

6. Bookmark names can contain all of the following EXCEPT ____.

|a. |letters |c. |numbers |

|b. |apostrophes |d. |underscores |

7. Bookmark names must begin with a ____.

|a. |space |c. |letter |

|b. |number |d. |either a or b |

8. In addition to bookmarks in online documents, you can insert ____.

|a. |keys |c. |file buttons |

|b. |portals |d. |hyperlinks |

TRUE/FALSE

9. By creating a cross-reference to a caption, the text that mentions the figure will be updated whenever the caption to the figure is updated. _________________________

10. As you prepare to insert a comment like the one in the accompanying figure, if you do not select text on which you wish to comment, Word automatically selects the text to the right or left of the insertion point for the comment.

11. When you compare two documents, if no tracked changes are found then the two documents are identical.

12. Using Word, you can combine the tracked changes from multiple reviewers’ documents into a single document, two documents at a time, until all documents are combined.

13. In order to accept the changes in a document, you have to review and accept them one at a time.

14. When you delete a subdocument, like the one in the accompanying figure, from the master document, the subdocument file is removed from the disk.

MATCHING

15. (5 points) Identify the letter of the choice that best matches the phrase or definition.

|a. |collaborate |f. |caption |

|b. |comment |g. |field |

|c. |reference |h. |cross-reference |

|d. |markup |i. |switch |

|e. |revision marks |j. |gutter margin |

I. Text that appears outside of an illustration.

II. To work on a document with others.

III. A note inserted in a document.

IV. Extra space that allows a document to be bound easily.

V. A slash followed by a letter inserted after field text.

VI. Another term for tracked changes.

VII. A link to a heading or footnote, for example.

VIII. Revisions made with the Track Changes feature enabled.

IX. A placeholder for data that might change in a document.

X. Type of document that is organized so a reader can easily locate material in it.

MULTIPLE CHOICE

16. What is the default file extension of a Word 2007 document?

|a. |.dotx |c. |.docs |

|b. |.docx |d. |.docm |

17. What is the default file extension of a Word 2007 template?

|a. |.dotz |c. |.docs |

|b. |.docx |d. |.docm |

18. What is the default file extension of a Word 2007 macro-enabled template?

|a. |.dotx |c. |.docx |

|b. |.dotm |d. |all of the above |

19. If you need to show white space, position the mouse pointer above the top of the page below the Ribbon and then ____ when the mouse pointer changes to a Show White Space button.

|a. |click |c. |triple-click |

|b. |double-click |d. |right-click |

20. If you were creating an online survey, what would be the most appropriate way to set up your survey so that you can easily enter multiple content controls on a single line?

|a. |keyline |c. |dialog box |

|b. |table |d. |border |

21. The ____ content control allows the user to enter and format text.

|a. |Rich Text |c. |Combo Box |

|b. |Plain Text |d. |Format Text |

22. The ____ content control allows the user to enter, but not format, text.

|a. |Rich Text |c. |Combo Box |

|b. |Plain Text |d. |Unformatted Text |

23. The ____ content control allows the user to type text or select one item from a list of choices.

|a. |Building Block Gallery |c. |Combo Box |

|b. |Drop-Down List |d. |Rich Text |

24. The ____ content control allows the user to select one item from a list of choices but not to type text.

|a. |Building Block Gallery |c. |Combo Box |

|b. |Drop-Down List |d. |Rich Text |

25. The ____ content control allows a user to interact with a calendar.

|a. |Calendar |c. |Date |

|b. |Combo Box |d. |Time |

TRUE/FALSE

26. Creating a document based on a template can improve your productivity because Word has defined much of the document’s appearance for you.

27. If you create and save an online form as a template, users will open a new document window that is based on that template.

28. By creating a Word document instead of a Word template for a form, the original template for the form remains intact when the user clicks the Save button.

29. When you want to present a set of choices to a user, use a text box content control.

30. If you enter a password, only a user who knows the password will be able to unprotect the document.

MULTIPLE CHOICE

31. If you ____, you should reset the Quick Access Toolbar before you quit Excel.

|a. |create macros for others |c. |assign a digital signature |

|b. |share a computer with others |d. |add a password |

[pic]

Figure 9-2

32. Macro names like those entered in the dialog box shown in Figure 9-2, ____.

|a. |cannot contain spaces and other punctuation |

|b. |can contain numbers, letters, and underscores |

|c. |can be up to 255 characters long |

|d. |all of the above |

33. You can assign a command to a button on the ____.

|a. |Mini toolbar |c. |status bar |

|b. |Quick Access Toolbar |d. |all of the above |

34. Word has ____ prenamed automatic macros.

|a. |three |c. |seven |

|b. |five |d. |eleven |

TRUE/FALSE

35. Macros are a known carrier of viruses and other malware.

36. The macro recorder shown in the accompanying figure records all actions you perform to a document while the macro recorder is running.

37. It is not possible to assign a shortcut key to a macro like the one created in the dialog box in the accompanying figure.

38. If you do not enter a name for a macro, Word assigns a default name.

39. When recording a macro, the mouse pointer appears with a tape icon to remind you that you are recording.

40. To delete a macro, click the View Macros button on the Developer tab, select the macro name in the list, click the Delete button, and then click the Yes button.

41. Click the Pause Recording button to suspend the macro recorder.

42. Word’s prenamed macros are called mechanical macros.

MS Excel 2007

TRUE/FALSE

43. Macros are an easy place for computer virus programmers to hide computer viruses.

44. You should enable macros only if you trust the author who created the workbook with the macro.

45. When buttons are dimmed even when Excel is in Ready mode, then the worksheet is protected.

46. When a worksheet is protected, users cannot change data in unlocked cells.

47. In Excel, a password, can contain any combination of letters, numerals, spaces, and symbols.

48. Passwords are not case sensitive.

49. If you make a mistake while recording a macro, you must start recording all over again.

MULTIPLE CHOICE

50. When you first create the macro, you must ____.

|a. |click the Start button |c. |record it |

|b. |save it |d. |name it |

51. Comments can be placed in between lines of code or at the end of a line of code as long as the comment begins with a(n) ____.

|a. |semi-colon (;) |c. |comma (,) |

|b. |apostrophe (') |d. |exclamation mark (!) |

52. What is the purpose of a message box?

|a. |to accept text from the VBA developer |c. |to accept input from a user |

|b. |to display messages to a user |d. |to record macros |

53. With a Spin Button control, the ____.

|a. |up arrow decreases the value and the down arrow increases|c. |left arrow increases the value and the down arrow |

| |the value | |decreases the value |

|b. |up arrow increases the value and the down arrow decreases|d. |none of the above |

| |the value | | |

54. A ____ returns a value to the program.

|a. |function |c. |name |

|b. |number |d. |step |

55. A ____ is a limitation on the possible values that a cell can contain.

|a. |constraint |c. |dependent |

|b. |limitation |d. |precedent |

TRUE / FALSE

56. When saving different types of scenarios in a worksheet, you should use a naming convention for the scenarios that will help you remember which scenario contains which set of changing cells.

57. Although the Scenario PivotTable worksheet is a worksheet like other worksheets, it cannot be manipulated.

58. The Scenario Summary worksheet makes it easier to compare the results of the scenarios.

59. Excel can generate a Scenario PivotTable worksheet to help analyze and compare the results of multiple scenarios.

60. A Scenario PivotTable worksheet gives you the ability to summarize the scenario data and then rotate the table’s row and column titles to obtain different views of the summarized data.

61. Imported data that maintains a refreshable link to its external source is called external data.

62. When you use external data, your worksheet will update whenever a change is made to the original file and the data in the worksheet is refreshed.

63. By using PivotTables, PivotCharts, and trendlines, an inexperienced user with little knowledge of formulas, functions, and ranges can complete powerful what-if analyses of a set of data.

64. Excel creates and associates a PivotTable with every PivotChart.

65. After importing data into a worksheet, the data might have to be transposed, meaning that the rows and columns need to be switched.

66. You typically analyze a trend in data over a period of time.

MULTIPLE CHOICE

67. The information in PivotTables is ____ directly to worksheet cells.

|a. |linked |c. |exported |

|b. |not linked |d. |imported |

68. In a PivotTable, ____ fields can be rotated around the data fields by dragging the buttons to different areas at the bottom of the PivotTable Field List pane.

|a. |empty |c. |row and column |

|b. |cell |d. |original data |

69. PivotTables can show the ____ among the data in a list or a database.

|a. |relationships |c. |trendline |

|b. |individual value |d. |change history |

70. A ____ cannot exist in Excel without an associated PivotTable.

|a. |summary |c. |data table |

|b. |history list |d. |PivotChart |

71. ____ fields in a PivotTable correspond to category (x-axis) fields in a PivotChart.

|a. |Row |c. |Closed |

|b. |Empty |d. |Column |

72. Clicking the ____ button on the Options tab on the Ribbon updates the corresponding PivotTable and PivotChart.

|a. |Refresh |c. |Pivot Update |

|b. |Update |d. |Update Pivot |

MATCHING

73. (5 points) Identify the letter of the choice that best matches the phrase or definition.

|a. |PivotChart |f. |fixed width file |

|b. |merging |g. |comparing |

|c. |XML |h. |PivotTable |

|d. |query |i. |delimited file |

|e. |refresh |j. |trendline |

I. Allows users to bring together copies of workbooks that others have worked on independently.

II. Viewing and scrolling worksheets side by side to visually search the worksheets for differences.

III. An interactive view of worksheet data that allows users to summarize the data and then rotate the table’s row and column titles to show different views of the summarized data.

IV. An interactive chart that provides the user with ways to analyze data visually by varying the fields and categories to present different graphical views.

V. A visual way to show how some particular data is changing over time.

VI. A file that contains data fields separated by a selected character, such as a comma.

VII. A file that contains data fields of equal length with spaces between the fields.

VIII. Updating the data whenever the original text file changes.

IX. A way to qualify the data to import by specifying a matching condition or asking a question of a database.

X. Encapsulates data and a description of the data in a single text file.

MS Access 2007

74. A subreport is a report that is contained in another report.

75. You must use the wizard when you create a report.

76. The contents of the Report Header section print once at the beginning of the report.

77. The contents of the Page Header section print once at the top of each page and often contain the column headings.

78. The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.

MULTIPLE CHOICE

79. To change the caption for a field in a table, open the table in Design view and change the _____ property.

|a. |Name |c. |Field |

|b. |Format |d. |Caption |

80. To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

|a. |Query |c. |Select Query |

|b. |Design View |d. |Query Design |

81. To add fields to a report, click the _____ button on the Design tab to add a field list.

|a. |Field List |c. |Add Existing Fields |

|b. |Report Fields |d. |Show Tables/Queries |

82. To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in _____.

|a. |parentheses ( ) |c. |curly braces { } |

|b. |percent symbols % % |d. |square brackets [ ] |

83. To calculate the total of a field, such as Amount Paid, use the _____ aggregate function.

|a. |COUNT |c. |ADD |

|b. |TOTAL |d. |SUM |

84. To display the Expression Builder dialog box, click the _____ button on the Design tab.

|a. |Add Expression |c. |Calculation |

|b. |Build |d. |Functions & Formulas |

85. To change the background color of a form, click the _____ button on the Design tab to display a color palette.

|a. |Background |c. |Color |

|b. |Format |d. |Fill/Back Color |

86. To change the appearance of a control so that it appears sunken, change the _____ property for the control.

|a. |Format |c. |Special Effect |

|b. |Style |d. |Font |

87. To change the appearance of a control so that text in the control displays as semi-bold, change the _____ property for the control.

|a. |Font |c. |Font Weight |

|b. |Format |d. |Special Effect |

88. If you use the property sheet to change the font color, click the _____ property.

|a. |Color |c. |Fore Color |

|b. |Font |d. |Foreground |

ESSAY

89. When you design forms, you should follow some general guidelines for form design. What are these six guidelines?

90. What is the purpose of the format painter?

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

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

Google Online Preview   Download