Name: 
 

Computer Applications Study Guide



True/False
Indicate whether the sentence or statement is true or false.
 

1. 

Microsoft Windows is started by turning on the computer.
 

2. 

The mouse pointer becomes a watch to show that the computer is busy.
 

3. 

To move a window, click the title bar and drag the window to another location.
 

4. 

A pull-down menu appears beneath the title bar and consists of a row of menu titles.
 

5. 

In the Help program, you can choose to see the table of contents, search using the index, or use the Find command.
 

6. 

Windows 95 replaces the previous version of Windows and DOS with one operating system.
 

7. 

When Microsoft Windows 95 starts, the desktop appears.
 

8. 

Sliding describes the action of holding a mouse button while moving the mouse on a flat surface.
 

9. 

The taskbar indicates the position of the mouse.
 

10. 

Scroll bars appear when all items in the window are visible.
 

11. 

To maximize a window, click the restore button.
 

12. 

A menu item followed by a right-pointing arrow indicates that a dialog box will appear.
 

13. 

Each item in the menu bar and pull-down menus has an underlined letter called a mnemonic.
 

14. 

The Help system is available from the Start menu.
 

15. 

A folder is a place where files and other folders are stored on disk.
 

16. 

The word processor is one of the applications in Office 97.
 

17. 

You can open a new document in an Office application from the Start menu.
 

18. 

You can close an Office document by clicking the Close button on the title bar.
 

19. 

The Save command can be used to save the file in a new location.
 

20. 

The Office Assistant is a help feature found only in Word and Excel.
 

21. 

An integrated software package is a computer program that combines common applications into one program.
 

22. 

Office applications are started from the File menu.
 

23. 

In all Office applications, you open, save, and close files in the same way.
 

24. 

A filename can contain a maximum of 8 characters.
 

25. 

The Save As command saves a file on disk using the current name.
 

26. 

You can close an Office document from the File menu or by clicking the Close button.
 

27. 

The bottom of the Open menu shows the filenames of the four most recently opened documents.
 

28. 

The Office Assistant is available in all Office 97 programs.
 

29. 

Quitting an Office application takes you back to the Windows 95 desktop.
 

30. 

The toolbar uses Overtype to remind you of each button’s function.
 

31. 

You can have two documents open at the same time.
 

32. 

Pressing Ctrl+Home will move the cursor to the beginning of a document.
 

33. 

You can use the Save As command to name a file the first time you save it.
 

34. 

If you click the Print button on the toolbar in Normal view, the Print dialog box will appear.
 

35. 

Each time Word is started, a Normal view screen appears.
 

36. 

Parts of the Normal view screen include the insertion point, status bar, and ruler.
 

37. 

When keying text, press the Enter key at the end of each line.
 

38. 

Highlighting blocks of text speeds editing operations.
 

39. 

Overtype is used to correct errors automatically.
 

40. 

Pressing the Backspace key deletes the character to the left of the insertion point.
 

41. 

You should save your file once every hour.
 

42. 

When a document is saved to a disk, it is stored there permanently and remains there until it is removed.
 

43. 

The Full Screen button in Print Preview allows you to see your document at 150%.
 

44. 

An entire document, one page, or a range of pages can be printed at any time.
 

45. 

Columns appear only in Page Layout view and Print Preview.
 

46. 

The Select Objects tool allows you to select and manipulate objects.
 

47. 

Selection boxes are small squares that appear around a selected object.
 

48. 

After you insert WordArt, it becomes an object you can change using the other tools on the drawing toolbar.
 

49. 

When you draw, you create objects in layers.
 

50. 

The Rotate Right tool rotates graphics to the right in 90 degree increments.
 

51. 

Resizing clip art using the handles maintains proportion.
 

52. 

Clip art is inserted through the Picture dialog box.
 

53. 

Word contains templates you can use to create documents.
 

54. 

The Header and Footer toolbar allows you to access the Print command.
 

55. 

Justified text is aligned at both the left and right margins.
 

56. 

Dot leaders can be used with decimal tabs only.
 

57. 

Numbers arranged in descending order go from the smallest to the largest.
 

58. 

The Date and Time command can be useful in memos and letters.
 

59. 

You can format bulleted and numbered lists by clicking the Bulleted or Numbering buttons on the toolbar.
 

60. 

Columns appear only in Page Layout view and Print Preview.
 

61. 

A cell is where a row and column intersect in a table.
 

62. 

The Columns dialog box allows you to change the amount of spacing between columns.
 

63. 

The Glue command makes several objects work together as one.
 

64. 

You cannot wrap text around a WordArt object
 

65. 

A template asks you questions and creates a document based on your answers.
 

66. 

To delete a row in a table, highlight the row and choose Delete Row from the Table menu.
 

67. 

Having more than one document open at a time is useful when spell checking.
 

68. 

The Window menu allows you to switch between open documents.
 

69. 

The Format Painter button allows you to copy text from one document to another.
 

70. 

A pane is a part of a split window that contains its own scroll bars and ruler.
 

71. 

The Keep with Next option keeps a paragraph on the same page as the paragraph following it.
 

72. 

You can use Word Count to count only one paragraph.
 

73. 

The Office Assistant gives you information about the possible errors that the Spelling and Grammar checker finds.
 

74. 

The Thesaurus finds synonyms and antonyms for words
 

75. 

The Find command will find and replace a word.
 

76. 

You can use only numbers for footnotes.
 

77. 

The Window menu is used to switch between documents.
 

78. 

Word Count counts the pages, words, characters, paragraphs, and lines in your document
 

79. 

In Word, you can check grammar and spelling at the same time.
 

80. 

Use the Match Case option when searching for words using wildcards in Find and Replace.
 

81. 

Footnotes and endnotes are used to document quotations, figures, or summaries or to record other text that you do not want to be included in the body of a document.
 

82. 

The primary advantage of the worksheet is to summarize text documents.
 

83. 

A cell is the intersection of a row and column.
 

84. 

The active cell reference will appear in the toolbar.
 

85. 

The Go To command saves a file and exits Excel.
 

86. 

To select a group of cells, click each cell individually until all cells in the range have been selected.
 

87. 

Saving a worksheet file differs significantly from saving a Word file.
 

88. 

The Clear command in the Edit menu can be used to remove the contents of a cell.
 

89. 

The best way to make minor changes to existing data in a cell is to key new data and press the Enter key.
 

90. 

The default format for data in a cell is Text.
 

91. 

You can place a border around the entire cell or only on certain sides of the cell.
 

92. 

Columns in a worksheet are identified by numbers.
 

93. 

The Home key moves the highlight to the first cell in the current row.
 

94. 

A cell in a worksheet must be highlighted before data can be entered.
 

95. 

The Save As dialog box appears every time you save a worksheet.
 

96. 

A highlighted worksheet cell may be edited by clicking in the formula bar.
 

97. 

If you copy data into cells already containing data, the existing data will be replaced by the copied data.
 

98. 

The Fill commands are available only if you plan to copy to cells adjacent to the original cell.
 

99. 

The Paste command can be used for both copying and moving data.
 

100. 

Deleting a row or column will erase the data contained in the row or column.
 

101. 

The Insert Column command is in the Format menu.
 

102. 

When using the Delete Row command, the row above the highlight will be deleted.
 

103. 

The Freeze Panes command will freeze rows above and columns to the right of the highlight.
 

104. 

A message will appear if you attempt to edit a cell in a worksheet that has been protected.
 

105. 

Cell comments can be seen in the worksheet at all times.
 

106. 

You can preview a worksheet before printing by clicking the Print Preview button on the toolbar or by choosing the Print Preview command in the File menu.
 

107. 

The Fill command can be used only to copy data to cells adjacent to the original cell.
 

108. 

The Paste command is chosen after the Cut command to move data in a worksheet.
 

109. 

The Freeze Panes command can be used to keep titles visible as you scroll in a worksheet.
 

110. 

The Comments command is located in the Tools menu.
 

111. 

You can instruct Excel to print the gridlines in a worksheet by checking a box in the Print Preview dialog box.
 

112. 

An operator is a number or cell reference used in formulas.
 

113. 

In a complex formula, subtraction will be performed before multiplication.
 

114. 

Operations within parentheses will be performed before operations outside parentheses in a formula.
 

115. 

An absolute cell reference will change if the formula is copied or moved.
 

116. 

The formula =B$4=C$9 contains mixed cell references.
 

117. 

The AutoSum button creates the function formula =SUM in the highlighted cell.
 

118. 

The View menu is used to display formulas rather than values in the worksheet.
 

119. 

Manual calculation is performed by pressing the F2 key.
 

120. 

Statistical function formulas are used to analyze loans and investments.
 

121. 

Function formulas do not have operators.
 

122. 

Addition will be performed before multiplication in a worksheet formula.
 

123. 

Excel will not let you enter a formula with an incorrect structure.
 

124. 

A relative cell reference in a worksheet uses dollar signs ($) to identify the cell.
 

125. 

When the Formulas box is chosen in the Options command of the Tools menu, the worksheet will display formulas, rather than their resulting values.     
 

126. 

A function formula may be used to determine the square root of a value in a cell.
 

127. 

Charts are a graphical representation of worksheet data.
 

128. 

Column charts are the best way to represent data groups that are part of a whole.
 

129. 

Line charts are good for representing trends over a period of time.
 

130. 

A scatter chart produces a “cloud” of data points not connected by lines.
 

131. 

A column chart represents values in the worksheet by varying heights of rectangles.
 

132. 

A pie chart may be created in either two or three dimensions.
 

133. 

The Chart Wizard may only be used to create two-dimensional charts.
 

134. 

The charts of a worksheet file are erased when the worksheet file is closed.
 

135. 

A chart may be printed from the chart sheet.
 

136. 

When the worksheet data changes, charts created from the worksheet also change.
 

137. 

Charts may be created only on a chart sheet.
 

138. 

The Chart Wizard will determine which type of chart is most appropriate for the data contained in a worksheet.
 

139. 

An Excel chart must be saved in a file that is separate from the worksheet in which the chart was created.
 

140. 

If you do not name a chart sheet, Excel assigns a default name: the word Chart, followed by a number.
 

141. 

It is not possible to preview a worksheet chart that is to be printed.
 

142. 

A computerized DBMS is more efficient than paper filing.
 

143. 

Opening a database automatically displays the data in the table.
 

144. 

Access has a standard document view that remains on the screen as long as a database is open.
 

145. 

A database file is a collection of database objects.
 

146. 

A record appears as a column in Datasheet view.
 

147. 

Fields are identified by field names.
 

148. 

The New Database command creates a database file.
 

149. 

The Number type is the best data type for storing telephone numbers
 

150. 

You do not have to save after entering records.
 

151. 

The File menu contains the Exit command.
 

152. 

The form database object allows you to ask the database questions.
 

153. 

The Number data type is specially designed for storing dollar amounts.
 

154. 

The Tab key moves the insertion point to the next field in Datasheet view.
 

155. 

The Windows desktop appears after you exit Access.
 

156. 

The navigation buttons are used to move around the datasheet.
 

157. 

If you click a cell with the mouse, the insertion point appears in the cell.
 

158. 

The Undo button will reverse all the changes you have made in a record.
 

159. 

You can delete records and fields in Datasheet view.
 

160. 

The field selectors highlight an entire row in a datasheet.
 

161. 

Holding down the Alt key allows you to select more than one field.
 

162. 

In Access, you can use the Cut, Copy, and Paste commands.
 

163. 

Changing the height of one row changes the height of all datasheet rows.
 

164. 

When creating a form you must specify which table to use as a basis for the form.
 

165. 

The Field Size field property specifies the number of characters allowed in a field.
 

166. 

In Datasheet view, an arrow indicates the current record.
 

167. 

Clicking a record selector highlights an entire column in a datasheet.
 

168. 

When you use the Cut command, a message appears to alert you that you are deleting a record.
 

169. 

You can add a new record between any existing records in a form.
 

170. 

Available field properties change depending on the data type chosen.
 

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

171. 

A graphical interface is interfacing with the computer through
a.
writing with a stylus
c.
speech
b.
keying or typing commands
d.
pictures and text
 

172. 

You can find the names of all the programs you are running on the
a.
in my computer
c.
taskbar
b.
start menu
d.
in the recycle bin
 

173. 

The -?- will restore the window back to the size it was before the maximize button was clicked
a.
maximize button
c.
minimize button
b.
restore button
d.
title bar
 

174. 

When the computer is busy, the mouse pointer turns into a
a.
I beam
c.
arrowhead
b.
hourglass
d.
an arrowhead pointing to the right
 

175. 

In Excel, to move one column to the left, press
a.
Up arrow
c.
Ctrl + End
b.
Ctrl + Home
d.
Left arrow
 

176. 

In Excel, to move right one column, press
a.
Up arrow
c.
Right arrow
b.
Ctrl + Home
d.
Home
 

177. 

In Excel, to move up one row, press
a.
Ctrl + Page Up
c.
Ctrl + End
b.
Up arrow
d.
Ctrl + Home
 

178. 

In Excel, to move Down one row, press
a.
Right arrow
c.
Ctrl + End
b.
Ctrl + Page Down
d.
Down arrow
 

179. 

In Excel, To move to the first cell of a row, press
a.
Ctrl + End
c.
Home
b.
Ctrl + Page Up
d.
Down arrow
 

180. 

In Excel, to move to cell A1, press
a.
Home
c.
Ctrl + Page Down
b.
Ctrl + Home
d.
Ctrl + End
 

181. 

In Excel, to move to the last cell containing data, press
a.
Ctrl + End
c.
Ctrl + Page Up
b.
Up arrow
d.
Home
 

182. 

In Excel, to move up one window, press
a.
Home
c.
Page Up
b.
Right arrow
d.
Ctrl + End
 

183. 

In Excel, to move down one window, press
a.
Ctrl + End
c.
Ctrl + Page Down
b.
Down arrow
d.
Page Down
 

184. 

In Excel, to move to the previous worksheet in a workbook, press
a.
Page Up
c.
Ctrl + Page Down
b.
Ctrl + Page Up
d.
Ctrl + End
 

185. 

In Excel, to move to the next worksheet in a workbook, press
a.
Home
c.
Ctrl + Page Up
b.
Ctrl + End
d.
Ctrl + Page Down
 

186. 

In Excel, to format numeric and text data as keyed, use the following cell format:
a.
Currency
c.
General
b.
Special
d.
Custom
 

187. 

In Excel, to format numeric data with a fixed amount of places to the right of the decimal point, use the following cell format
a.
Fraction
c.
Accounting
b.
Time
d.
Number
 

188. 

In Excel, to format numeric data preceded by a dollar sign, however, the dollar signs and decimal points do not necessarily line up vertically within a column, use the following cell format
a.
General
c.
Currency
b.
Number
d.
Time
 

189. 

In Excel, to format numeric data in a currency format that lines up the dollar signs and decimal points, use the following cell format
a.
Accounting
c.
Fraction
b.
Scientific
d.
Number
 

190. 

In Excel, to format text and numeric data as dates, use the following cell format
a.
Time
c.
Numerical
b.
Date
d.
Fraction
 

191. 

In Excel, to display text and numeric data as dates, use the following cell format
a.
Date
c.
Custom
b.
Time
d.
Accounting
 

192. 

In Excel, to display text and numeric data as times, use the following cell format
a.
Number
c.
Time
b.
Date
d.
Custom
 

193. 

In Excel, to display and numeric data followed by a percent sign,  use the following cell format
a.
Fraction
c.
Special
b.
Number
d.
Percentage
 

194. 

In Excel, to display the value of .5 as 1/2,  use the following cell format
a.
Number
c.
Percentage
b.
Fraction
d.
Custom
 

195. 

In Excel, to display numeric data in exponential notation, use the following cell format
a.
Percentage
c.
General
b.
Number
d.
Scientific
 

196. 

In Excel, to display and numeric data that will not be used for calculations, use the following cell format
a.
Text
c.
General
b.
Numerical
d.
Custom
 

197. 

In Excel, to display text in numerical format such as ZIP codes, use the following cell format
a.
Special
c.
Custom
b.
General
d.
Percentage
 



 
Check Your Work     Reset Help