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. True 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