An Excel workbook file name can contain up to _____ characters and cannot include

2. A __________, which is the intersection of a column and row, is the basic unit of a worksheet into which data is entered.
a.  cell
b.   window
c.   range
d.   split box

3. The active cell can be identified in all of the following ways except __________.
a.  a heavy border surrounding the cell
b.   the active cell reference displayed in the Name box
c.   the lit up column heading and row heading
d.   a block plus sign displaying in the center of the cell

4. The mouse pointer turns into the __________ whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.
a.  block plus sign
b.   I-beam
c.   block arrow
d.   two-headed arrow

5. Below and to the right of a worksheet are __________ that can be used to move the window around to view different parts of the active worksheet.
a.  scroll bars
b.   scroll arrows
c.   scroll boxes
d.   all of the above

6. An alternative to sliding one toolbar over another is to use the __________ on a toolbar to display the buttons that are hidden.
a.  More Buttons button
b.   Name Box button
c.   ScreenTip button
d.   Question Mark button

7. The status bar displays __________.
a.  names representing a lists of commands that can be used to retrieve, store, print, and manipulate data
b.   buttons that can be used to perform frequent tasks more quickly than using the menu bar
c.   arrows and boxes that can be used to move the window around to view different parts of the worksheet
d.   a brief description of the selected command in a menu, the function of a button, or the activity in progress

8. An alternative method to using the mouse to select a cell is to use the __________ located just to the right of the typewriter keys on the keyboard.
a.  alphabetic keys
b.   function keys
c.   arrow keys
d.   special keys

9. Excel positions text __________ the cell.
a.  left-aligned, which means the text is positioned at the far left in
b.   right-aligned, which means the text is positioned at the far right in
c.   centered, which means the text is positioned in the middle of
d.   justified, which means the text is spread across the width of

10. If a wrong letter is typed and the error is noticed before clicking the Enter box, use the __________ to erase all the characters back to and including the one that is wrong.
a.  ENTER key
b.   BACKSPACE key
c.   ESC key
d.   DELETE key

11. Excel's AutoCorrect feature makes all the following corrections except __________.
a.  corrects two initial capital letters by changing the second letter to lowercase
b.   adds a final s or es to nouns that should be plural
c.   capitalizes the first letter in the names of the days
d.   replaces commonly misspelled words with their correct spelling

12. Excel's __________ provides a convenient means to add the numbers in a range of cells.
a.  MAX function
b.   AVERAGE function
c.   COUNT function
d.   SUM function

13. A range can be entered by typing the beginning cell reference, a __________, and the ending cell reference.
a.  colon (:)
b.   hyphen (-)
c.   slash (/)
d.   tilde (~)

14. Font size is measured in points; a single point is about __________ of one inch in height.
a.  1/12
b.   1/18
c.   1/36
d.   1/72

15. In the AutoFormat dialog box shown in the accompanying figure, the __________ terminates current activity without making any changes.
a.  Close button or Cancel button
b.   Question Mark button
c.   OK button
d.   Options button

16. In the AutoFormat dialog box shown in the accompanying figure, the __________ can be used to obtain Help on any box or button located in the dialog box.
a.  Close button or Cancel button
b.   Question Mark button
c.   OK button
d.   Options button

17. In the AutoFormat dialog box shown in the accompanying figure, the __________ allows additional formats to be assigned as part of the selected customized format.
a.  Close button or Cancel button
b.   Question Mark button
c.   OK button
d.   Options button

18. To select any cell, click the __________ located on the left side of the formula bar and enter the cell reference of the desired cell.
a.  AutoSum area
b.   Name box
c.   AutoCalculate area
d.   Scroll box

19. The small __________ at the corners and sides along the selection rectangle indicate a chart is selected.
a.  sizing handles
b.   sheet tabs
c.   block arrows
d.   table formats

20. The __________ identifies each bar in a chart.
a.  title
b.   x-axis
c.   legend
d.   y-axis

21. When a file is saved, Excel automatically appends the extension __________ to the entered file name, which stands for Excel workbook.
a.  .exc
b.   .wbk
c.   .exw
d.   .xls

22. The __________, on the left of the Save As dialog box, displays a list of shortcuts (pointers) to the most recently used files in a folder titled Recent.
a.  Favorites button
b.   History button
c.   Desktop button
d.   Web Folders button

23. A total, an average, or other information about numbers in a range easily can be obtained by using the __________ on the status bar.
a.  AutoSum area
b.   Name box
c.   AutoCalculate area
d.   scroll box

24. The __________ not only deletes the contents from a range, but also copies the range to the Office Clipboard.
a.  Undo button or Undo command
b.   Cut button or Cut command
c.   Delete button or Delete command
d.   all of the above

25. An unsaved workbook can be cleared by clicking the workbook's Close button or by clicking Close on the __________ menu.
a.  File
b.   Edit
c.   Tools
d.   Data

26. Web support allows Excel to save workbooks or parts of a workbook in HTML format so they can be viewed and manipulated using a browser.
a. true
b.  false

27. Inside an Excel workbook are sheets, called booksheets.
a. true
b.  false

28. A new Excel workbook opens with three worksheets, but, if necessary, additional worksheets can be added to a maximum of 255.
a. true
b.  false

29. A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.
a. true
b.  false

30. The menu bar, Standard toolbar, and Formatting toolbar display at the bottom of the screen just above the status bar.
a. true
b.  false

31. When a menu name on the menu bar is clicked, a short menu displays listing the most recently used commands.
a. true
b.  false

32. If the arrows at the bottom of a short menu are clicked, a full menu displays that lists all the commands associated with a menu.
a. true
b.  false

33. A hidden command displays in a faint type, which indicates it is not available for the current selection.
a. true
b.  false

34. A dimmed command does not display on the short menu.
a. true
b.  false

35. As data is typed, the data displays in the Name box, and Excel displays the active cell reference in the formula bar.
a. true
b.  false

36. Mode indicators, such as NUM (Num Lock), CAPS (Caps Lock), and SCRL (Scroll) show which keys are engaged.
a. true
b.  false

37. When the mode indicator reads Ready, Excel is ready to accept the next command or data entry.
a. true
b.  false

38. When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.
a. true
b.  false

39. Keyboard indicators, such as Enter and Ready, display on the status bar and specify the current mode.
a. true
b.  false

40. In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered text.
a. true
b.  false

41. The insertion point is a blinking vertical line that indicates where the next character typed will display.
a. true
b.  false

42. Clicking the Enter box completes an entry, and clicking the Cancel box cancels the entry.
a. true
b.  false

43. When the text entered is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the left as long as these adjacent cells contain data.
a. true
b.  false

44. When an arrow key is pressed to complete an entry in a cell, the adjacent cell in the direction of the arrow (up, down, left, or right) becomes the active cell.
a. true
b.  false

45. Numbers can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.
a. true
b.  false

46. Numbers entered into a worksheet are right-aligned, which means Excel displays the cell entry to the far right in the cell.
a. true
b.  false

47. When proposing a range of cells to sum, Excel first looks for a range of cells with numbers below the active cell and then to the right.
a. true
b.  false

48. The range of cells receiving a copy is called the copy area.
a. true
b.  false

49. The cell being copied is called the paste area.
a. true
b.  false

50. If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the AutoSum button is clicked.
a. true
b.  false

51. A worksheet is formatted to emphasize entries and make the worksheet easier to read and understand.
a. true
b.  false

52. The font type indicates how characters are formatted, such as regular, underlined, or italicized.
a. true
b.  false

53. A character with a point size of 10 is about 10/72 of one inch in height.
a. true
b.  false

54. Font style defines the appearance and shape of letters, numbers, and special characters.
a. true
b.  false

55. When Excel begins, the preset font type for the entire workbook is Arial with a size and style of 10-point regular.
a. true
b.  false

56. You bold an entry in a cell to camouflage it or make it blend into the rest of the worksheet.
a. true
b.  false

57. When the Merge and Center button is clicked to center a worksheet title across the range A1:F1, Excel not only centers the title but also merges cells A1 through F1 into one cell, cell A1.
a. true
b.  false

58. Most formats assigned to a cell will display on the Standard toolbar when the cell is selected.
a. true
b.  false

59. Excel derives the scale along the vertical axis (also called the y-axis or value axis) of a Column chart on the basis of the values in the worksheet.
a. true
b.  false

60. Excel automatically selects the entries in the topmost row of a selected range as the titles for the horizontal axis (x-axis or category axis) of a Column chart and draws a column for each cell in the range containing numbers.
a. true
b.  false

61. When Excel is installed on a computer, the default chart type, or the type of chart Excel draws if the Finish button is clicked in the first Chart Wizard dialog box, is the 3-D (three-dimensional) Pie chart.
a. true
b.  false

62. If the computer is turned off or if power is lost while building a workbook, the computer stores the workbook in memory.
a. true
b.  false

63. In the list box that displays when the Tools button is clicked in the Save As dialog box, the General Options command allows a backup copy of the workbook to be saved, a password to be created to limit access to the workbook, and other functions to be carried out.
a. true
b.  false

64. Saving a backup workbook means that each time the workbook is saved, Excel copies the current version of the workbook on disk to a file with the same name, but with the words, Backup of, appended to the front of the file name.
a. true
b.  false

65. Case sensitive means that Excel cannot differentiate between uppercase and lowercase letters.
a. true
b.  false

66. If a print area is not selected, Excel automatically selects a print area on the basis of used cells.
a. true
b.  false

67. The Close button and Control-menu icon on the title bar close the workbook, and the Close button and Control-menu icon on the menu bar close Excel.
a. true
b.  false

68. If the entry in a cell is long and the errors are minor, Edit mode may be a better choice than selecting the cell and retyping the entire entry.
a. true
b.  false

69. To delete a character in a cell, move the insertion point to the right of the character to be deleted and then press the DELETE key, or place the insertion point to the left of the character to be deleted and then press the BACKSPACE key.
a. true
b.  false

70. In Insert mode, Excel overtypes the character to the right of the insertion point.
a. true
b.  false

71. In Overtype mode, as a character is typed, Excel inserts that character and moves all characters to the right of the typed character one position to the right.
a. true
b.  false

72. Excel provides the Undo command on the Edit menu and the Undo button on the Standard toolbar to repeat previous actions.
a. true
b.  false

73. The Redo button on the Standard toolbar and the Redo command on the Edit menu can be used to erase the most recent cell entry.
a. true
b.  false

74. Always press the SPACEBAR to clear a cell.
a. true
b.  false

75. With the Office Assistant active, a question, word, or phrase can be typed in a text box and the Office Assistant provides immediate help on the subject.
a. true
b.  false

76. To start Excel, Windows must be running.
a. true
b.  false

77. Excel considers a date to be text and, therefore, displays it left-aligned in the cell.
a. true
b.  false

78. If a formula is entered in cell F3 to multiply the values in cells D3 and E3, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F3.
a. true
b.  false

79. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after the arithmetic operators.
a. true
b.  false

80. When more than one operator is involved in a formula, Excel follows a different basic order of operations from that used in algebra.
a. true
b.  false

81. Regardless of the length and complexity of a formula, using Point mode to enter formulas often is slower and less accurate than using the keyboard.
a. true
b.  false

82. When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and perform calculations using the appropriate values.
a. true
b.  false

83. A function takes a value or values, performs an operation, and returns a result to the cell.
a. true
b.  false

84. When Point mode is used to enter a function, the arrow keys can be used to complete the entry.
a. true
b.  false

85. The MIN function is used to determine the highest number in a range.
a. true
b.  false

86. Excel has more than 400 functions that perform just about every type of calculation that can be imagined.
a. true
b.  false

87. One of the least common mistakes made with Excel is to include a wrong cell reference in a formula.
a. true
b.  false

88. The Trace Dependents command on the Auditing submenu highlights the cells with formulas in the worksheet that reference the active cell.
a. true
b.  false

89. If the Range Finder is used to change cells referenced in a formula, press the ENTER key to complete the edit.
a. true
b.  false

90. If the Trace Precedents command on the Auditing submenu is clicked, Excel displays cells with formulas in the worksheet that reference the active cell.
a. true
b.  false

91. When developing presentation-quality worksheets, different fonts seldom are used in the same worksheet.
a. true
b.  false

92. The font type, size, or style can be changed at any time while the worksheet is active.
a. true
b.  false

93. Borders can be removed by selecting the range and clicking the No Border button on the Borders palette.
a. true
b.  false

94. A background color can be removed by selecting the range, clicking the Font color button, and then clicking Automatic.
a. true
b.  false

95. Left alignment, center alignment, and right alignment are used so often that Excel has Left Align, Center, and Right Align buttons on the Formatting toolbar.
a. true
b.  false

96. When the Currency Style button is used, Excel assigns a floating dollar sign that displays immediately to the left of the first digit.
a. true
b.  false

97. The Cells command on the Format menu or the Format Cells command on the shortcut menu must be used to assign a fixed dollar sign.
a. true
b.  false

98. The Increase Decimal button on the Formatting toolbar removes a decimal place from the selected cell each time it is clicked.
a. true
b.  false

99. The Decrease Decimal button on the Formatting toolbar is used to display additional decimal places in a cell.
a. true
b.  false

100. A floating dollar sign always displays to the left side of a cell, and the fixed dollar sign always displays immediately to the left of the first digit.
a. true
b.  false

101. When a cell is rounded to suit a particular format, while all the decimal places may not display, Excel does maintain all the decimal places for computational purposes.
a. true
b.  false

102. When conditional formatting is used, if the condition is false, Excel applies the formatting.
a. true
b.  false

103. The Add button in the Conditional Formatting dialog box allows up to two additional conditions to be added.
a. true
b.  false

104. 12.75 points is equal to about one-sixth of an inch.
a. true
b.  false

105. When the format assigned to a cell causes the entry to exceed the width of a column, Excel automatically changes the column width to best fit.
a. true
b.  false

106. When a worksheet is printed, hidden columns print.
a. true
b.  false

107. To set a row height to best fit, double-click the top boundary of the row heading.
a. true
b.  false

108. If specialized terms often are used that are not in the spell checker's standard dictionary, the Spelling dialog box can be used to add them to a custom dictionary.
a. true
b.  false

109. If a range of cells is selected before starting the spell checker, Excel checks only the spelling of the words outside the selected range.
a. true
b.  false

110. To check the spelling of all the sheets in a workbook, right-click a sheet tab, and then click Select All Sheets on the sheet tab shortcut menu.
a. true
b.  false

111. Portrait orientation means the printout is printed across the length of the page.
a. true
b.  false

112. Excel sets the orientation for a new workbook to portrait.
a. true
b.  false

113. When the mouse pointer is a magnifying glass, the previewed page in the Preview window can be clicked to carry out the function of the Zoom button.
a. true
b.  false

114. The Print dialog box displays when the Print button on the Standard toolbar is used.
a. true
b.  false

115. The formulas version of a worksheet shows the results of the formulas that have been entered.
a. true
b.  false

116. Because the values version of a worksheet displays and prints the formulas, rather than the results, it makes it easier to see if any mistakes were made in formulas.
a. true
b.  false

117. When a change is made from the values to the formulas version, Excel increases the width of the columns so the formulas and text do not overflow into adjacent cells on the right.
a. true
b.  false

118. To get external data from a World Wide Web site, it is necessary to have access to the Internet.
a. true
b.  false

119. Data returned by stock-related Web queries is real-time in the sense that it is no more than 20 minutes old during the business day.
a. true
b.  false

120. Excel displays the data returned from a Web query in an organized, formatted worksheet, which has a worksheet title, column titles, and a row of data for each stock symbol entered.
a. true
b.  false

121. If, when making a Web query, the External Data toolbar does not display, right-click any toolbar and then click External Data.
a. true
b.  false

122. Sheet names can contain up to 31 characters (including spaces) in length.
a. true
b.  false

123. Longer sheet names mean more sheet tabs will display.
a. true
b.  false

124. The leftmost and rightmost scroll buttons can be used to move one sheet to the left or right.
a. true
b.  false

125. A new feature of Office 2000 is the capability of e-mailing a worksheet or workbook directly from within Excel.
a. true
b.  false

126. To start a new line in a cell, press __________ after each line, except for the last line, which is completed by clicking the Enter box or pressing the ENTER key.
a.  ALT+ENTER
b.   CTRL+ENTER
c.   SHIFT+ENTER
d.   TAB+ENTER

127. The __________ preceding a formula is an important part of the formula, because it alerts Excel that a formula or function is being entered and not text.
a.  at sign (@)
b.   dollar sign ($)
c.   percent sign (%)
d.   equal sign (=)

128. Moving from left to right in a formula, the order of operations is as follows: first negation (-), then all __________.
a.  exponentiations (^), then all percentages (%), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (-)
b.   percentages (%), then all exponentiations (^), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (-)
c.   exponentiations (^), then all percentages (%), then all additions (+) and subtractions (-), and finally, all multiplications (*) and divisions (/)
d.   percentages (%), then all exponentiations (^), then all additions (+) and subtractions (-), and finally, all multiplications (*) and divisions (/)

129. To select the nonadjacent range F11, H11, and I11, select cell F11, and then, while holding down the __________ key, drag through the range H11:I11.
a.  SHIFT
b.   ALT
c.   CTRL
d.   HOME

130. With Excel, functions can be entered using the __________.
a.  keyboard or mouse
b.   Edit Formula box and Functions box
c.   Paste Functions button on the Standard toolbar
d.   all of the above

131. Excel has a function called the __________ that displays the highest value in a range.
a.  MIN function
b.   MAX function
c.   NOW function
d.   SUM function

132. The __________ on the Auditing submenu highlights the cells in the worksheet that are referred to by the formula in the active cell.
a.  Trace Precedents command
b.   Trace Dependents command
c.   Trace Error command
d.   Remove All Arrows command

133. When verifying a formula using the Auditing commands, to change the active cell to the one at the other end of the blue line, __________.
a.  click the active cell
b.   double-click the active cell
c.   click the blue line
d.   double-click the blue line

134. Customized numeric formats can be assigned using the __________ on the Format menu.
a.  Cells command
b.   AutoFormat command
c.   Sheet command
d.   Style command

135. To display negative percents in a column in bold with a red background so they stand out, the __________ on the Format menu can be used.
a.  Sheet command
b.   AutoFormat command
c.   Conditional Formatting command
d.   Style command

136. The __________ in the Conditional Formatting dialog box can be used to remove one or more active conditions.
a.  Add button
b.   Delete button
c.   Cancel button
d.   Format button

137. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of __________.
a.  12.43 points and the rows have a default height of 8.43 characters
b.   12.43 characters and the rows have a default height of 8.43 points
c.   8.43 points and the rows have a default height of 12.75 characters
d.   8.43 characters and the rows have a default height of 12.75 points

138. To set a column width to best fit, __________ boundary of the column heading above row 1.
a.  click the left
b.   double-click the left
c.   click the right
d.   double-click the right

139. To display a hidden column, position the mouse pointer to the __________.
a.  left of the column heading where the hidden column is located and then drag to the right
b.   right of the column heading where the hidden column is located and then drag to the left
c.   left of the column heading where the hidden column is located and then drag to the left
d.   right of the column heading where the hidden column is located and then drag to the right

140. If a workbook already has been saved, to save a workbook using a new name or on a different drive, __________.
a.  click Save on the File menu
b.   press SHIFT+F12
c.   click Save As on the File menu
d.   press CTRL+S

141. Rather than click the Next and Previous buttons to move from page to page on a multiple page worksheet in the Preview window, the __________ keys can be pressed.
a.  HOME and END
b.   LEFT ARROW and RIGHT ARROW
c.   PAGE UP and PAGE DOWN
d.   all of the above

142. The __________ button in the Preview window magnifies or reduces the displayed worksheet.
a.  Setup
b.   Zoom
c.   Margins
d.   Print

143. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print all the sheets with content in the workbook.
a.  All option button
b.   Selection option button
c.   Active sheet(s) option button
d.   Entire workbook option button

144. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the selected range.
a.  All option button
b.   Selection option button
c.   Active sheet(s) option button
d.   Entire workbook option button

145. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the active sheet displaying on the screen or the selected sheets.
a.  All option button
b.   Selection option button
c.   Active sheet(s) option button
d.   Entire workbook option button

146. To toggle between the values version and the formulas version of a worksheet, press __________.
a.  CTRL+LEFT SINGLE QUOTATION MARK (`)
b.   CTRL+RIGHT SINGLE QUOTATION MARK (´)
c.   ALT+LEFT SINGLE QUOTATION MARK (`)
d.   ALT+RIGHT SINGLE QUOTATION MARK (´)

147. Each of the following Web queries is available when Excel first is installed except __________.
a.  Microsoft Investor Currency Rates
b.   Microsoft Investor Commodity Prices
c.   Microsoft Investor Major Indices
d.   Microsoft Investor Stock Quotes

148. To change the stock symbols Excel uses when refreshing the data in a Web query, click the __________ on the External Data toolbar.
a.  Data Range Properties button
b.   Query Parameters button
c.   Refresh Status button
d.   Edit Query button

149. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then __________.
a.  press the ESC key
b.   click the Name Box
c.   press the INSERT key
d.   click a cell in the worksheet

150. If a copy of a worksheet is sent in HTML format, the recipient would __________ able to open it in Excel.
a.  be able to read the worksheet and would be
b.   be able to read the worksheet but would not be
c.   not be able to read the worksheet but would be
d.   not be able to read the worksheet and would not be

Excel 2000 – Answers to Study Questions for Exam 1

1. b (07Excl-1-6)  __________, a primary part of Excel, pictorially represent(s) data.
2. a (07Excl-1-10)  A __________, which is the intersection of a column and row, is the basic unit of a worksheet into which data is entered.
3. d (07Excl-1-10)  The active cell can be identified in all of the following ways except __________.
4. c (07Excl-1-10)  The mouse pointer turns into the __________ whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.
5. d (07Excl-1-11)  Below and to the right of a worksheet are __________ that can be used to move the window around to view different parts of the active worksheet.
6. a (07Excl-1-14)  An alternative to sliding one toolbar over another is to use the __________ on a toolbar to display the buttons that are hidden.
7. d (07Excl-1-14)  The status bar displays __________.
8. c (07Excl-1-15)  An alternative method to using the mouse to select a cell is to use the __________ located just to the right of the typewriter keys on the keyboard.
9. a (07Excl-1-17)  Excel positions text __________ the cell.
10. b (07Excl-1-17)  If a wrong letter is typed and the error is noticed before clicking the Enter box, use the __________ to erase all the characters back to and including the one that is wrong.
11. b (07Excl-1-18)  Excel's AutoCorrect feature makes all the following corrections except __________.
12. d (07Excl-1-22)  Excel's __________ provides a convenient means to add the numbers in a range of cells.
13. a (07Excl-1-23)  A range can be entered by typing the beginning cell reference, a __________, and the ending cell reference.
14. d (07Excl-1-28)  Font size is measured in points; a single point is about __________ of one inch in height.
15. a (07Excl-1-33)  In the AutoFormat dialog box shown in the accompanying figure, the __________ terminates current activity without making any changes.
16. b (07Excl-1-33)  In the AutoFormat dialog box shown in the accompanying figure, the __________ can be used to obtain Help on any box or button located in the dialog box.
17. d (07Excl-1-33)  In the AutoFormat dialog box shown in the accompanying figure, the __________ allows additional formats to be assigned as part of the selected customized format.
18. b (07Excl-1-34)  To select any cell, click the __________ located on the left side of the formula bar and enter the cell reference of the desired cell.
19. a (07Excl-1-38)  The small __________ at the corners and sides along the selection rectangle indicate a chart is selected.
20. c (07Excl-1-41)  The __________ identifies each bar in a chart.
21. d (07Excl-1-43)  When a file is saved, Excel automatically appends the extension __________ to the entered file name, which stands for Excel workbook.
22. b (07Excl-1-44)  The __________, on the left of the Save As dialog box, displays a list of shortcuts (pointers) to the most recently used files in a folder titled Recent.
23. c (07Excl-1-49)  A total, an average, or other information about numbers in a range easily can be obtained by using the __________ on the status bar.
24. b (07Excl-1-53)  The __________ not only deletes the contents from a range, but also copies the range to the Office Clipboard.
25. a (07Excl-1-54)  An unsaved workbook can be cleared by clicking the workbook's Close button or by clicking Close on the __________ menu.
26. a - true (07Excl-1-6)  Web support allows Excel to save workbooks or parts of a workbook in HTML format so they can be viewed and manipulated using a browser.
27. b - false (07Excl-1-9)  Inside an Excel workbook are sheets, called booksheets.
28. a - true (07Excl-1-9)  A new Excel workbook opens with three worksheets, but, if necessary, additional worksheets can be added to a maximum of 255.
29. a - true (07Excl-1-10)  A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.
30. b - false (07Excl-1-11)  The menu bar, Standard toolbar, and Formatting toolbar display at the bottom of the screen just above the status bar.
31. a - true (07Excl-1-12)  When a menu name on the menu bar is clicked, a short menu displays listing the most recently used commands.
32. a - true (07Excl-1-12)  If the arrows at the bottom of a short menu are clicked, a full menu displays that lists all the commands associated with a menu.
33. b - false (07Excl-1-12)  A hidden command displays in a faint type, which indicates it is not available for the current selection.
34. b - false (07Excl-1-12)  A dimmed command does not display on the short menu.
35. b - false (07Excl-1-14)  As data is typed, the data displays in the Name box, and Excel displays the active cell reference in the formula bar.
36. b - false (07Excl-1-14)  Mode indicators, such as NUM (Num Lock), CAPS (Caps Lock), and SCRL (Scroll) show which keys are engaged.
37. a - true (07Excl-1-14)  When the mode indicator reads Ready, Excel is ready to accept the next command or data entry.
38. a - true (07Excl-1-14)  When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.
39. b - false (07Excl-1-14)  Keyboard indicators, such as Enter and Ready, display on the status bar and specify the current mode.
40. a - true (07Excl-1-15)  In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered text.
41. a - true (07Excl-1-16)  The insertion point is a blinking vertical line that indicates where the next character typed will display.
42. a - true (07Excl-1-17)  Clicking the Enter box completes an entry, and clicking the Cancel box cancels the entry.
43. b - false (07Excl-1-17)  When the text entered is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the left as long as these adjacent cells contain data.
44. a - true (07Excl-1-19)  When an arrow key is pressed to complete an entry in a cell, the adjacent cell in the direction of the arrow (up, down, left, or right) becomes the active cell.
45. a - true (07Excl-1-20)  Numbers can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.
46. a - true (07Excl-1-21)  Numbers entered into a worksheet are right-aligned, which means Excel displays the cell entry to the far right in the cell.
47. b - false (07Excl-1-23)  When proposing a range of cells to sum, Excel first looks for a range of cells with numbers below the active cell and then to the right.
48. b - false (07Excl-1-24)  The range of cells receiving a copy is called the copy area.
49. b - false (07Excl-1-24)  The cell being copied is called the paste area.
50. a - true (07Excl-1-27)  If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the AutoSum button is clicked.
51. a - true (07Excl-1-27)  A worksheet is formatted to emphasize entries and make the worksheet easier to read and understand.
52. b - false (07Excl-1-28)  The font type indicates how characters are formatted, such as regular, underlined, or italicized.
53. a - true (07Excl-1-28)  A character with a point size of 10 is about 10/72 of one inch in height.
54. b - false (07Excl-1-28)  Font style defines the appearance and shape of letters, numbers, and special characters.
55. a - true (07Excl-1-28)  When Excel begins, the preset font type for the entire workbook is Arial with a size and style of 10-point regular.
56. b - false (07Excl-1-28)  You bold an entry in a cell to camouflage it or make it blend into the rest of the worksheet.
57. a - true (07Excl-1-34)  When the Merge and Center button is clicked to center a worksheet title across the range A1:F1, Excel not only centers the title but also merges cells A1 through F1 into one cell, cell A1.
58. b - false (07Excl-1-34)  Most formats assigned to a cell will display on the Standard toolbar when the cell is selected.
59. a - true (07Excl-1-37)  Excel derives the scale along the vertical axis (also called the y-axis or value axis) of a Column chart on the basis of the values in the worksheet.
60. a - true (07Excl-1-41)  Excel automatically selects the entries in the topmost row of a selected range as the titles for the horizontal axis (x-axis or category axis) of a Column chart and draws a column for each cell in the range containing numbers.
61. b - false (07Excl-1-41)  When Excel is installed on a computer, the default chart type, or the type of chart Excel draws if the Finish button is clicked in the first Chart Wizard dialog box, is the 3-D (three-dimensional) Pie chart.
62. b - false (07Excl-1-41)  If the computer is turned off or if power is lost while building a workbook, the computer stores the workbook in memory.
63. a - true (07Excl-1-44)  In the list box that displays when the Tools button is clicked in the Save As dialog box, the General Options command allows a backup copy of the workbook to be saved, a password to be created to limit access to the workbook, and other functions to be carried out.
64. a - true (07Excl-1-44)  Saving a backup workbook means that each time the workbook is saved, Excel copies the current version of the workbook on disk to a file with the same name, but with the words, Backup of, appended to the front of the file name.
65. b - false (07Excl-1-44)  Case sensitive means that Excel cannot differentiate between uppercase and lowercase letters.
66. a - true (07Excl-1-46)  If a print area is not selected, Excel automatically selects a print area on the basis of used cells.
67. b - false (07Excl-1-47)  The Close button and Control-menu icon on the title bar close the workbook, and the Close button and Control-menu icon on the menu bar close Excel.
68. a - true (07Excl-1-51)  If the entry in a cell is long and the errors are minor, Edit mode may be a better choice than selecting the cell and retyping the entire entry.
69. b - false (07Excl-1-51)  To delete a character in a cell, move the insertion point to the right of the character to be deleted and then press the DELETE key, or place the insertion point to the left of the character to be deleted and then press the BACKSPACE key.
70. b - false (07Excl-1-52)  In Insert mode, Excel overtypes the character to the right of the insertion point.
71. b - false (07Excl-1-52)  In Overtype mode, as a character is typed, Excel inserts that character and moves all characters to the right of the typed character one position to the right.
72. b - false (07Excl-1-52)  Excel provides the Undo command on the Edit menu and the Undo button on the Standard toolbar to repeat previous actions.
73. b - false (07Excl-1-53)  The Redo button on the Standard toolbar and the Redo command on the Edit menu can be used to erase the most recent cell entry.
74. b - false (07Excl-1-53)  Always press the SPACEBAR to clear a cell.
75. a - true (07Excl-1-54)  With the Office Assistant active, a question, word, or phrase can be typed in a text box and the Office Assistant provides immediate help on the subject.
76. a - true (07Excl-2-6)  To start Excel, Windows must be running.
77. b - false (07Excl-2-8)  Excel considers a date to be text and, therefore, displays it left-aligned in the cell.
78. a - true (07Excl-2-9)  If a formula is entered in cell F3 to multiply the values in cells D3 and E3, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F3.
79. b - false (07Excl-2-10)  Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after the arithmetic operators.
80. b - false (07Excl-2-10)  When more than one operator is involved in a formula, Excel follows a different basic order of operations from that used in algebra.
81. b - false (07Excl-2-12)  Regardless of the length and complexity of a formula, using Point mode to enter formulas often is slower and less accurate than using the keyboard.
82. a - true (07Excl-2-14)  When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and perform calculations using the appropriate values.
83. a - true (07Excl-2-16)  A function takes a value or values, performs an operation, and returns a result to the cell.
84. b - false (07Excl-2-18)  When Point mode is used to enter a function, the arrow keys can be used to complete the entry.
85. b - false (07Excl-2-20)  The MIN function is used to determine the highest number in a range.
86. a - true (07Excl-2-21)  Excel has more than 400 functions that perform just about every type of calculation that can be imagined.
87. b - false (07Excl-2-23)  One of the least common mistakes made with Excel is to include a wrong cell reference in a formula.
88. a - true (07Excl-2-23)  The Trace Dependents command on the Auditing submenu highlights the cells with formulas in the worksheet that reference the active cell.
89. a - true (07Excl-2-24)  If the Range Finder is used to change cells referenced in a formula, press the ENTER key to complete the edit.
90. b - false (07Excl-2-26)  If the Trace Precedents command on the Auditing submenu is clicked, Excel displays cells with formulas in the worksheet that reference the active cell.
91. b - false (07Excl-2-28)  When developing presentation-quality worksheets, different fonts seldom are used in the same worksheet.
92. a - true (07Excl-2-30)  The font type, size, or style can be changed at any time while the worksheet is active.
93. a - true (07Excl-2-32)  Borders can be removed by selecting the range and clicking the No Border button on the Borders palette.
94. b - false (07Excl-2-32)  A background color can be removed by selecting the range, clicking the Font color button, and then clicking Automatic.
95. a - true (07Excl-2-33)  Left alignment, center alignment, and right alignment are used so often that Excel has Left Align, Center, and Right Align buttons on the Formatting toolbar.
96. b - false (07Excl-2-34)  When the Currency Style button is used, Excel assigns a floating dollar sign that displays immediately to the left of the first digit.
97. b - false (07Excl-2-34)  The Cells command on the Format menu or the Format Cells command on the shortcut menu must be used to assign a fixed dollar sign.
98. b - false (07Excl-2-36)  The Increase Decimal button on the Formatting toolbar removes a decimal place from the selected cell each time it is clicked.
99. b - false (07Excl-2-36)  The Decrease Decimal button on the Formatting toolbar is used to display additional decimal places in a cell.
100. b - false (07Excl-2-38)  A floating dollar sign always displays to the left side of a cell, and the fixed dollar sign always displays immediately to the left of the first digit.
101. a - true (07Excl-2-39)  When a cell is rounded to suit a particular format, while all the decimal places may not display, Excel does maintain all the decimal places for computational purposes.
102. b - false (07Excl-2-40)  When conditional formatting is used, if the condition is false, Excel applies the formatting.
103. a - true (07Excl-2-42)  The Add button in the Conditional Formatting dialog box allows up to two additional conditions to be added.
104. a - true (07Excl-2-43)  12.75 points is equal to about one-sixth of an inch.
105. a - true (07Excl-2-43)  When the format assigned to a cell causes the entry to exceed the width of a column, Excel automatically changes the column width to best fit.
106. b - false (07Excl-2-46)  When a worksheet is printed, hidden columns print.
107. b - false (07Excl-2-48)  To set a row height to best fit, double-click the top boundary of the row heading.
108. a - true (07Excl-2-48)  If specialized terms often are used that are not in the spell checker's standard dictionary, the Spelling dialog box can be used to add them to a custom dictionary.
109. b - false (07Excl-2-50)  If a range of cells is selected before starting the spell checker, Excel checks only the spelling of the words outside the selected range.
110. a - true (07Excl-2-50)  To check the spelling of all the sheets in a workbook, right-click a sheet tab, and then click Select All Sheets on the sheet tab shortcut menu.
111. b - false (07Excl-2-51)  Portrait orientation means the printout is printed across the length of the page.
112. a - true (07Excl-2-53)  Excel sets the orientation for a new workbook to portrait.
113. a - true (07Excl-2-53)  When the mouse pointer is a magnifying glass, the previewed page in the Preview window can be clicked to carry out the function of the Zoom button.
114. b - false (07Excl-2-54)  The Print dialog box displays when the Print button on the Standard toolbar is used.
115. b - false (07Excl-2-55)  The formulas version of a worksheet shows the results of the formulas that have been entered.
116. b - false (07Excl-2-55)  Because the values version of a worksheet displays and prints the formulas, rather than the results, it makes it easier to see if any mistakes were made in formulas.
117. a - true (07Excl-2-55)  When a change is made from the values to the formulas version, Excel increases the width of the columns so the formulas and text do not overflow into adjacent cells on the right.
118. a - true (07Excl-2-58)  To get external data from a World Wide Web site, it is necessary to have access to the Internet.
119. a - true (07Excl-2-58)  Data returned by stock-related Web queries is real-time in the sense that it is no more than 20 minutes old during the business day.
120. a - true (07Excl-2-60)  Excel displays the data returned from a Web query in an organized, formatted worksheet, which has a worksheet title, column titles, and a row of data for each stock symbol entered.
121. a - true (07Excl-2-61)  If, when making a Web query, the External Data toolbar does not display, right-click any toolbar and then click External Data.
122. a - true (07Excl-2-62)  Sheet names can contain up to 31 characters (including spaces) in length.
123. b - false (07Excl-2-62)  Longer sheet names mean more sheet tabs will display.
124. b - false (07Excl-2-62)  The leftmost and rightmost scroll buttons can be used to move one sheet to the left or right.
125. a - true (07Excl-2-62)  A new feature of Office 2000 is the capability of e-mailing a worksheet or workbook directly from within Excel.
126. a (07Excl-2-7)  To start a new line in a cell, press __________ after each line, except for the last line, which is completed by clicking the Enter box or pressing the ENTER key.
127. d (07Excl-2-10)  The __________ preceding a formula is an important part of the formula, because it alerts Excel that a formula or function is being entered and not text.
128. b (07Excl-2-10)  Moving from left to right in a formula, the order of operations is as follows: first negation (-), then all __________.
129. c (07Excl-2-15)  To select the nonadjacent range F11, H11, and I11, select cell F11, and then, while holding down the __________ key, drag through the range H11:I11.
130. d (07Excl-2-16)  With Excel, functions can be entered using the __________.
131. b (07Excl-2-18)  Excel has a function called the __________ that displays the highest value in a range.
132. a (07Excl-2-23)  The __________ on the Auditing submenu highlights the cells in the worksheet that are referred to by the formula in the active cell.
133. d (07Excl-2-26)  When verifying a formula using the Auditing commands, to change the active cell to the one at the other end of the blue line, __________.
134. a (07Excl-2-34)  Customized numeric formats can be assigned using the __________ on the Format menu.
135. c (07Excl-2-39)  To display negative percents in a column in bold with a red background so they stand out, the __________ on the Format menu can be used.
136. b (07Excl-2-42)  The __________ in the Conditional Formatting dialog box can be used to remove one or more active conditions.
137. d (07Excl-2-43)  When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of __________.
138. d (07Excl-2-43)  To set a column width to best fit, __________ boundary of the column heading above row 1.
139. a (07Excl-2-46)  To display a hidden column, position the mouse pointer to the __________.
140. c (07Excl-2-50)  If a workbook already has been saved, to save a workbook using a new name or on a different drive, __________.
141. c (07Excl-2-53)  Rather than click the Next and Previous buttons to move from page to page on a multiple page worksheet in the Preview window, the __________ keys can be pressed.
142. b (07Excl-2-54)  The __________ button in the Preview window magnifies or reduces the displayed worksheet.
143. d (07Excl-2-55)  In the Print dialog box in the accompanying figure, the __________ instructs Excel to print all the sheets with content in the workbook.
144. b (07Excl-2-55)  In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the selected range.
145. c (07Excl-2-55)  In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the active sheet displaying on the screen or the selected sheets.
146. a (07Excl-2-55)  To toggle between the values version and the formulas version of a worksheet, press __________.
147. b (07Excl-2-58)  Each of the following Web queries is available when Excel first is installed except __________.
148. b (07Excl-2-61)  To change the stock symbols Excel uses when refreshing the data in a Web query, click the __________ on the External Data toolbar.
149. d (07Excl-2-61)  To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then __________.
150. b (07Excl-2-64)  If a copy of a worksheet is sent in HTML format, the recipient would __________ able to open it in Excel.

Return To ITE 140 Home Page

What other name is the cell address known?

Which of the following characters is permitted in a workbook file name?

Which of the following elements of an Excel worksheet contains the tabs with commands and buttons?

What are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet?