1. A worksheet’s row-and-column structure can be used to organize and store a ____.
a. table
2. As a database in Excel, each row of a worksheet can store a record, and each column can store a(n) ____.
c. field
3. A field, or column, that contains formulas or functions is called a calculated ____.
a. column
4. Even though Excel is not a true ____ management system, it can be used as a ____ tool.
d. database
5. To open an existing workbook, you can start Excel and open the workbook at the same time by ____ the workbook file name in Windows Explorer.
b. double-clicking
6. To treat the range of cells over which a single cell is centered, what method would you use?
d. merge and center
7. Another way to format a range as a table is to ____.
d. all of the above
8. Excel automatically creates an empty row in the table so that you are ready to enter the first ____ in the table.
c. record
9. No visible changes appear on the worksheet when the table contains no records. As records are entered into the table, the assigned formats apply, even as more ____ are added to the table.
a. rows
10. Excel has built-in data ____ features to ensure that the data entered into a cell or range of cells is within limits.
c. validation
11. To change an active list back to a normal range of cells, right-click the range, point to Table on the shortcut menu, and then click ____ on the Table submenu.
c. Convert to Range
12. A data validation rule that is cautionary, is also considered to be a ____.
b. Warning
13. The output of inaccurate information that results from the input of invalid data is known as ____.
a. GIGO
14. Excel ignores data validation if data is ____ the Office Clipboard.
d. pasted from
15. You can change the ____ for each element listed in the Table Element list.
d. formatting
16. Pressing the ____ key adds the next row below the table to the table.
a. TAB
17. ____ causes adjacent rows to have different formatting so that each record in the table is distinguished from surrounding rows.
a. Row banding
18. What is another way to enter a record into a table?
b. Press ALT+J, T
19. After clicking the Retry or Cancel button in the error message dialog box, Excel requires you to ____.
c. reenter all values up to and including the value in error
20. The HLOOKUP function is used when the table direction is ____.
c. horizontal
21. Why is the VLOOKUP function used more often than other lookup functions?
b. because most tables are vertical
22. The general form of the VLOOKUP function is ____.
c.=VLOOKUP(lookup_value, table_array, col_index_num)
23. A table_array contains table ____.
b. arguments
24. If columns contain sensitive information, such as salary information, you can ____ the columns.
c. hide
25. Do not enter more than one ____ per worksheet.
b. table
26. Conditional formatting allows you to create ____ that change the formatting of a cell or range of cells based on the value of a cell.
a. rules
27. Which of the following is a type of conditional formatting?
d. all of the above
28. The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.
d. Rules Manager
29. The field or fields selected for sorting records are called ____ keys.
d. sort
30. Displaying ____ is a tool for summarizing data in a table.
a. automatic subtotals
31. The ____ expand or collapse rows in the worksheet.
b. row level symbols
32. A table also is called a record.
b. False
33. Excel is a true database management system.
b. False
34. Excel does not allow you to create forms and reports.
b. False
35. A query can include filters, the use of which results in the table displaying only those records that meet certain criteria.
a. True
36. Data calibration features ensure that the data you enter into a cell or range of cells is within limits
b. False
37. Data validation rules can be mandatory or informational.
a. True
38. Data validation allows whole numbers in a specific range.
a. True
39. You can change the formatting for each element listed in the Table Element.
a. True
40. When creating a table, maintain at least two blank rows between a table and other worksheet entries.
b. False
41. Each column of a table should have different data.
b. False
42. Column headings (field names) can be up to 200 characters in length.
b. False
43. Banded columns provide alternating colors every other column.
a. True
44. The contents of an active table can be printed.
a. True
b. False
45. Data that is ordered from earliest to most recent is in ascending order.
a. True
46. The order of priority for sorting is: numbers, alphabetic characters, special characters
b. False
47. Data can be sorted by using the Sort button on the Data tab on the Ribbon.
a. True
48. Options on the Sort & Filter menu change depending on the data in the column.
a. True
49. Another way to sort the data in ascending sequence is to first select the field in the table, and then, on the Data tab on the Ribbon, click Sort A to Z button.
a. True
50. Excel allows sorting on a maximum of 256 fields in a single sort operation.
a. True
51. If you make a mistake in a sort operation, you can return the records to their original order by clicking the Undo button on the Quick Access Toolbar.
a. True
52. The most common subtotal used with the Subtotals command is the SUM function, which causes Excel to display a sum each time the control field changes.
a. True
53. The Zoom Out button on the status bar to reduce the magnification of the worksheet so that the table is more readable.
a. True
54. Many business applications require data from several worksheets to be summarized on one worksheet.
a. True
55. The process of summarizing data included on multiple worksheets on one worksheet is called linking.
a. True
56. One efficient way to create the workbook is first to create a template, save the template, and then copy the template to a workbook as many times as necessary.
a. True
57. For workbooks to be successful and survive their expected life cycle in a business environment, they must be well documented and easy to understand.
a. True
58. Templates help speed and simplify work because Excel users often work with very different problems.
a. "False"
59. Excel allows you to print page numbers and the sheet name of each sheet.
a. True
60. Templates cannot contain macros or formulas.
b. False
61. Data placeholders are helpful to users of templates.
a. True
62. You can display tomorrow's date in a cell by adding -1 to the NOW function.
b. False
63. The DATE function is most useful in formulas where year, month, and day are formulas, not constants.
a. True
64. The format assigned to the system date in a cell is temporary until it is assigned a permanent format.
a. True
65. "1,1,1," is an example of a linear series.
b. False
66. The number of digits is one of the arguments in the ROUND function.
a. True
67. When the Excel Template file type is chosen in the Save as type box, Excel automatically changes the contents of the Save in box to the Templates folder created when Office 2007 was installed.
a. True
68. A brace is a rectangular area of variable size in which you can add text.
b. False
69. When Excel is first installed on a computer, it places commonly used shapes in the Recently Used Shapes area in the Shapes gallery.
a. True
70. The process of summarizing data included on multiple worksheets on one worksheet is called ____.
a. consolidation
71. A workbook that contains patterns for creating other workbooks is called a(n) ____.
b. template
72. The function =NOW()+14 does what?
a. displays a date two weeks in the future
73. The ____ function is most useful in formulas where year, month, and day are formulas, not constants.
b. DATE
74. The result of an arithmetic operation, such as multiplication or division, is ____ to the factor with the least number of decimal places.
a. accurate
75. The form of the ROUND function is ____.
d. =ROUND (number, number of digits)
76. To change from Enter mode or Edit mode to Point mode, start by ____.
d. typing the EQUAL SIGN (=)
77. Saving a template is just like saving a workbook, except that the file type ____ is selected in the Save as type box in the Save As dialog box.
a. Template
78. A function that sums all the values in all the cells in column A is ____.
d. =sum(a:a)
79. A(n) ____ always appears in the same position in a cell (regardless of the number of significant digits).
b. fixed dollar sign
80. A format code is a series of ____ that defines how a cell entry assigned a format will appear.
c. format symbols
81. A section in a format code can be ____.
c. zeros
82. A style is a group of format specifications that ____.
b. are assigned to a style name
83. If two different styles are assigned to a range of cells, Excel ____.
a. adds the second style to the first
84. The Normal format style is ____.
b. initially assigned to all cells in a workbook
85. How many worksheets are in a new workbook if you do not set a default?
c. 3
86. What is the maximum number of worksheets that a workbook can have?
a. depends on computer's memory
87. Entering a number once and having it be entered in the same cell on all worksheets is called ____.
d. drilling an entry
88. Excel inserts a dotted line above a row to indicate ____.
b. a horizontal page break
89. How can a page break be moved?
c. drag it on the Page Break preview
90. If you create a worksheet for someone who does not have Excel, save the worksheet as a(n) ____ file.
a. PDF
91. A single character, word, or phrase is referred to as a(n) ____.
d. string
92. To search only a specified range of a worksheet, select the range before invoking the ____.
a. Find command
93. Match case means that the search ____ and the cell contents must match the word exactly the way it is typed.
a. is case sensitive
94. Match entire cell contents means that ____ and must be unique in the cell.
a. the string cannot be part of another word or phrase
95. What happens if Excel does not find the information in the search?
b. A dialog box indicates the string cannot be found.
96. What happens if Excel replaces a text string?
d. All of the above
97. A link is a reference to a cell or range of cells ____.
c. in another workbook
98. The form for indicating a 3-D reference from your is ____.
c. location, workbook name, sheet name, cell reference
99. One way to arrange workbooks in an Excel window is to ____ them.
b. cascade
100. A recommended approach for consolidating data from other workbooks is to ____
a. first bind the workbooks together using a workspace file
101. A workspace file ____.
d. does not contain the actual workbook
102. You can open all of the associated workbooks by opening the ____.
c. workspace
103. Excel will update links automatically if ____.
a. the linked workbooks are open