Final Exam CS

__f__

1. An Access database is limited to a size of 1 gigabyte.

__f__

10. In the figure above, item 1 changes as you navigate from record to record.

__C. magazine__

100. In what type of document might a mirror margin be used?

__AUTONUMBER__

102. A(n) ________________ field automatically assigns a new number each time you add a record.

__QUERY___

103. A(n) _______________ is a database object that creates a datasheet of specified fields and records from one or more tables.

__SELECTION__

104. Filter By ________________ is the fastest way to filter records for an exact match.

__FORM___

105. Filter By _______________ filters records based on more than one selection criteria by using a special window.

___FORM___

106. On a form, ______________ View is used to enter, edit, and delete data.

_SPLIT_

107. In a(n) __________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

__BLANK_

108. Use the _________________ Form tool to create a form with no controls starting in Form Layout View.

__LANDSCAPE__

109. ________________ orientation is 11" wide by 8.5" tall.

__T__

11. In the figure above, item 3 is a combination of two controls.

_FUNCTION_

110. A(n) __________________ is a built-in formula such as Sum or Count.

___FUNCTION____

112. A _____________ is a predefined worksheet formula that enables Excel users to perform complex calculations.

__RELATIVE_

113. When copying or moving formulas in an Excel worksheet, the default type of cell reference is _________________.

__ROUND_

114. The _________________ function specifies the number of decimal places to be used for values and formulas.

___FILL HANDLE__

115. To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the _______________ to complete the sequence.

__DESTINATION___

116. When you change data in a source file, linked data also changes in the _______________ file.

_TABLE___

117. You can copy an existing table from Word and paste it into a new Access ________________.

__RECORDS__

118. If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of _______________ as the Access table.

___FIELDS_

119. If you want to import additional records to an existing database, make sure that the imported Excel data contains the same number of ________________ as the database.

__t__

12. On a form, text box controls display data from an underlying record source.

_FORMATTING_

120. After pasting a table into Word as a link, you can modify the __________________ of the pasted table so that the table is attractive and communicates the data clearly.

__BACKGROUND_

121. Every slide in a PowerPoint presentation has a(n) _________________, the area behind the text and graphics.

__ANNOTATION_

122. The Highlighter is one of the _________________ tools available while in Slide Show view.

__METADATA__

123. Document properties, also known as ________________, include specific data about the presentation, such as the author's name, subject matter, title, who saved the file last, and when the file was created.

_MASTERS_

124. Each presentation in PowerPoint has a set of __________________, which store information about the theme and slide layouts, including the position and size of text and content placeholders, text styles, background colors, effects, animations, and theme colors.

_ANNOTATIONS_

125. The Erase All Ink on Slide command is used for erasing __________________.

NOTES

126.Referring to the figure above, the page labeled "B" is showing a(n) ____ page.

_INTELLECTUAL PROPERTY_

127. _________________ is any idea or creation of the human mind.

____FAIR USE_

128. ______________ is an exception to copyright and permits the public to use copyrighted material for certain purposes without obtaining prior consent from the owner.

____PROOF READ__

129. You should ______________ your presentation for punctuation, grammar, and word-usage errors because the spellchecker recognizes only misspelled and unknown words, not misused words.

__T__

13. You can resize form sections in Form Design View.

_STACKED_

130. Every object on a slide, whether it is a text object, a shape, a chart, a picture, or any other object, is __________________ on the slide in the order it was created.

_CROPPING___

131. You can hide a portion of a picture you don't want visible by ________________ it.

_INSERT

132. You can create an individual text box by clicking the Text Box button in the Text group on the __________________ tab on the Ribbon.

_GRAPH__

133. If you don't have Excel installed, you can create a chart in PowerPoint using a charting program called Microsoft _________________.

_EMBEDDED_

134. An __________________object is one that is a part of your presentation (just like any other object you insert into PowerPoint).

__DOCX__

135. The default file extension for a file saved in Word 2010 is the ________________ format.

__NO SPACING_

136. If you want uniform spacing between lines and paragraphs, apply the _________________ style to the document.

___TEMPLATE_

137. A ________________ is a formatted document that contains placeholder text, which you replace with your own text.

__DRAFT_

138. _________________ view shows a simplified layout of a document, without margins, headers or footers, or graphics.

__SHORTCUT KEY_

139. A _________________ is a combination of keys that you press to perform a command.

__F__

14. The purpose of a report is to provide an easy-to-use data entry interface.

_CLIPBOARD__

140. You can cut and paste text using the buttons on the _________________ group on the Home tab.

_PROTECT DOCUMENT_

141. The __________________ option on the Info tab lets you mark a document as final so that it cannot be edited and encrypt a document with a password.

_CHECK FOR ISSUES__

142. The _________________ option on the Info tab lets you remove unwanted information from a document, check for content that people with disabilities might find difficult to read, and check the document for features that are unsupported by previous versions of Word.

_DOUBLE CLICK__

143. _________________ a tab stop on the ruler to open the Tabs dialog box.

___TAB INDICATOR__

144. Click the ______________ to scroll through the types of tabs and indents.

___RULERS__

145. The location of each margin (right, left, top, and bottom) is shown on the _______________ at the intersection of the white and shaded areas.

___MARGINS___

146. The ______________ tab in the Page Setup dialog box is used to add a gutter to a document.

__BROWSE BY OBJECT_

147. Use the _________________ feature to quickly move the insertion point to the next or previous page, section, line, table, graphic, or other item of the same type in a document.

_INSERT__

148. Use the Header or Footer command on the _________________ tab to insert predesigned headers and footers.

_REFERENCES__

149. The Citations & Bibliography group is found on the _________________ tab.

__T__

15. When using a wizard, you can click the Back button to review previous dialog boxes.

__MASTER__

150. The ________________ list shows all the sources available on your computer.

__D.[Ctrl][End]__

151. Last field of the last record

_C.[up arrow]___

152. Current field of the previous record

_H.[Ctrl][Home]___

153. First field of the first record

__G. [down arrow]__

154. Current field of the next record

_E. [Home]___

155. First field of the current record

__B. [Tab]__

156. Next field of the current record

__A. [left arrow]__

157. Previous field of the current record

___D.query_

158. Creates a datasheet of selected fields and records from one or more tables

__H.query grid__

159. The lower pane in Query Design View

__f__

16. Portrait orientation is 8.5" wide by 13" tall.

___G.criteria_

160. Limiting conditions used to narrow the number of records on a datasheet

___C.sorting_

161. Putting records in ascending or descending order based on a field's values

___B.wildcard_

162. Used to search for a pattern

__F.filter__

163. Creates a temporary subset of records

__A. is null__

164. Criterion that finds all records where no entry has been made in the field

___E. syntax_

165. Rules that determine how criteria is entered

__C.option button__

166. Best choice to provide choices for a field in an option group

__E.tab control__

167. Best choice to create a three-dimensional aspect to a form

__G.toggle button__

168. Best choice to display a field such as Veteran that has only two options, Yes or No

___B.label_

169. Best choice to describe information on a form

__T__

17. You can use a named range instead of a cell address in a formula.

__H.line__

170. Used to visually separate information on a form

__D.list box__

171. Used to provide a list of options for a field with no ability for the user to enter a new value

__A. command button__

172. Used to run a macro

__F. combo box__

173. Used to provide a list of options for a field plus the ability for the user to enter a new value

_H___

174. Alternate Row color

__B__

175. Italic

__G__

176. Align Text Right

__D__

177. Font Color

__F__

178. Center

__A__

179. Bold

__T__

18. You can change the font and font size of any cell or range using the Mini toolbar.

__C__

180. Underline

___B. template_

181. Predesigned workbook files that contain labels, values, formulas, and formatting.

__C. COUNT__

182. The Excel function that returns the number of cells in a range containing numeric data.

__D.$G$6__

183. Absolute cell reference.

___E.$G6_

184. Mixed cell reference.

___F.relative_

185. The type of cell reference used to preserve the relationship to the formula location.

_G. Paste Preview___

186. The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only."

__H. AVERAGE__

187. The Excel function that returns the arithmetic mean of its arguments.

___C_

188. Left indent marker

__A__

189. Tab indicator

__F__

19. The Format Painter button copies both the cell's content and formatting.

__F__

190. Tab leader

__D__

191. First Line Indent marker

__B__

192. Indent buttons

_G___

193. Right indent marker

___A_

194. Insertion point

___C_

195. Section 3 formatted in one column

__H__

196. Creates a new section on the same page

__D__

197. Forces the following text to the next page

__B__

198. Columns of text

__E__

199. Indicates active section

__T__

2. Field names appear in the top row of a datasheet.

__T__

20. You can add words to the dictionary of the spelling checker.

__G__

200. Indicates the page number field in the Footer are

__f__

21. The horizontal axis is also called the value axis.

__F__

22. A chart must be located in a specific cell or at a specific address range.

__T__

23. Any data changed in the worksheet is automatically updated in the chart.

___T_

24. Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

___f_

25. The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

__T__

26. Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.

_F___

27. Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2 x 5 =22/(2 x 5).

__t__

28. =D8+E8*0.5 is a complex formula.

__T__

29. When you integrate data from multiple Office programs, you work with both a source file and a destination file.

__T__

3. A primary key field uniquely identifies each record.

__f__

30. The Paste list arrow in the Insert group allows you to see each of the five Paste Options and to view how the pasted object will appear in the document.

__f__

31. After importing Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

__T__

32. You can integrate information into a PowerPoint presentation using the linking and embedding techniques you learned with Word, Excel, and Access.

__f__

33. You link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

__T__

34. After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

__T__

35. PowerPoint accepts information in the form of files from a variety of sources, such as Microsoft Access.

__F__

36. When you start PowerPoint, the program opens in Slide Show view.

__F__

37. Copyright protects the underlying facts or concepts, but not the expression of an idea.

__F__

38. In the figure above, slide 3 has 3 second-level bullets.

_T___

39. In the figure above, slide 4 has only 1 content placeholder.

__T__

4. No two records can have the same value in the primary key field.

__F__

40. To move text from one location to another, you have to retype the text in the new location.

__f_

41. The Selection pointer is the blinking vertical line in the document window.

__T__

42. Double-clicking a word selects the entire word.

__T__

43. As you type in Word, the insertion point automatically moves to the next line of the document when you reach the right margin.

__T__

44. You can set the Office Clipboard to open automatically any time you cut or copy text two items consecutively.

__t_

45. Word inserts an AutoCorrect entry after you press [Spacebar] or a punctuation mark.

__T__

46. You can create your own AutoCorrect entries.

__t__

47. You must apply text wrapping to a graphic in order to move it independently of text.

__f__

48. Pressing [Ctrl][Enter] inserts a soft page break.

__T__

49. The information you insert in any Header or Footer area appears on every page in a document unless you set different headers and footers for different sections.

__T__

5. Values in an AutoNumber field are automatically created by Access.

__F__

50. Footnotes are placed at the end of a document.

__b.Form__

51. This Access object provides an easy-to-use data entry screen.

_c.Table___

52. This Access object contains all of the raw data within the database.

__a.Table__

53. A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

__c.Yes/No__

54. Which data type stores only one of two values?

__a.Relational database__

55. A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

__a.Edit mode__

56. In a datasheet, which mode assumes that you are trying to change the value of a particular field?

_a.>___

57. Which of the following comparison operators means "greater than"?

__c.List box__

58. This control displays a list of possible data entries from which the user can choose.

_c.Command button___

59. This control provides an easy way to initiate a command or run a macro.

__T__

6. You can move datasheet columns by dragging the field name left or right.

__a.At the end of the entire report__

60. The Report Footer section prints ____.

__a. Page footer__

61. In the figure above, item 6 points to the ____ section.

__D. page footer__

62. Which section would most likely contain page number and date expressions?

__C. font color__

63. In the figure above, what button is identified as item 4?

__A.workbook__

64. In Excel, a worksheet is contained in a file called a ____.

_B.function___

65. A(n) ____ is a built-in formula that uses arguments to calculate information.

__C.arithmetic__

66. ____ operators perform mathematical calculations such as adding and subtracting.

__a.area chart_

67. To show how individual volume changes over time in relation to total volume, use a(n) ____.

_C. scatter___

68. Which chart type would be the best candidate to spot trends and extrapolate information based on research data?

__d.legend name__

69. Which of the following is not an option that the Data Labels can produce?

__F__

7. Once you have created and named a field, you cannot resize the width of the field in a datasheet.

__a. absolute__

70. Which type of cell reference preserves the exact cell address in a formula?

__A. excel template__

71. The file extension .xltx indicates what type of Excel file?

___B.link_

72. After you create an object in one program, you can choose to either ____ the object or embed it in another program.

__B.formatting__

73. By default, an object copied from one program to another program retains the ____ of the original object.

__A.to the left of__

74. In Excel, the Clipboard task pane opens ____ the spreadsheet window.

__D.clipboard__

75. In the accompanying figure, the pane pointed to by item 1 is known as the ____.

_A. another access database ___

76. You can import data into Access from ____.

__d.imported into__

77. In the accompanying figure, item 2 points to an Excel table ____ Access.

__c.append__

78. You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

___B.records_

79. The data shown in the accompanying figure contains seven ____.

__T__

8. To add, delete, or change fields in a query, you use Query Design View.

___A.broken_

80. ____ links can occur when you move linked files to a different location — either to a new folder on your own computer or to another computer.

__D.=(D3-D2)/D3__

81. The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

_C. query___

82. The screen shown in the accompanying figure represents a ____ in Design view.

__C.linked to__

83. Because the Excel data in the accompanying figure is ____ an Access table, it will be updated when you update the Access table.

__c.slide__

84. The numbers "00:07" that appear under each of the slides above is the ____ timing.

___C.pause_

85. The icon that shows two short vertical lines will ____ the presentation.

__B.animation categories__

86. Entrance and Exit are ____.

__C.status bar__

87. The Zoom slider is located on the ____.

_c.distribute_

88. The ____ commands found with the Align commands evenly space objects horizontally or vertically relative to each other or the slide.

__A.clearly visible__

89. As soon as you move the pointer over the Mini toolbar, the toolbar becomes ____.

__T__

9. A form contains record navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

__c.more button on the Shape Styles group to view Quick Styles__

90. She would also like to add a special effect to the arrows to improve their appearance, so she clicks the ____.

__C. chart placeholder__

91. To recreate the screen above, you would click the Insert Chart icon in the ____.

__A. attachment__

92. Although your e-mail program allows you to attach files, you can send a presentation using Outlook from within PowerPoint. Click the File tab, click Save & Send, click Send Using E-mail in the center pane, then click Send as ____.

__B.glows__

93. The WordArt text styles and effects include ____.

_b.line and paragraph spacing_

94. Which button is not on the Mini toolbar?

___a.the Zoom dialog box opens_

95. What happens when you click the Zoom level button?

__D. [Ctrl][V]_

96. What is the keyboard shortcut for pasting text?

__B.AutoCorrect__

97. Which feature would you use to correct words that you frequently misspell as you type?

__a.Double-click the split bar__

98. If a document window has been split into two panes, how can you restore the window to a single pane?

__a. a serif font__

99. What is a font with a small stroke at the ends of the characters is called?

____ONE TO MANY____101.

A(n) ____________ relationship describes when a record from one table is related to several records in another table.

__INCREASE DECIMAL __111.

As shown in the figure above, item 4 is the ________________ button.