ion Complete each statement. 1. A group of selected cells is called a ____________________. RESPONSE: ANSWER: range POINTS: 0 / 1 2. You can magnify or reduce the view of a worksheet with the ____________________ controls on the status bar. RESPONSE: ANSWER: zoom POINTS: 0 / 1 Matching Identify the letter of the choice that best matches the phrase or definition. a. Workbook b. Active worksheet c. Cell reference d. Worksheet e. Spreadsheet 3. Identifies the cell, and is formed by combining the cell's column letter and row number ANSWER: C POINTS: 0 / 1 4. A collection of worksheets ANSWER: A POINTS: 0 / 1 5. A grid of rows and columns in which you enter text, numbers, and the results of calculations ANSWER: E POINTS: 0 / 1 6. A computerized spreadsheet ANSWER: D POINTS: 0 / 1 7. The worksheet that is displayed in the work area ANSWER: B POINTS: 0 / 1 Match the letter of the cell format option below to the worksheet format described in the numbered questions. a. Accounting g. Date b. Time h. Number c. Scientific i. Percentage d. Fraction j. Custom e. Text k. Currency f. General l. Special 8. Displays both text and numerical data as keyed ANSWER: F POINTS: 0 / 1 9. Displays numerical data with a fixed amount of places to the right of the decimal point, with the option of having a thousand comma separator. ANSWER: H POINTS: 0 / 1 10. Displays numerical data preceded by a dollar sign; however, dollar signs and decimal points do not necessarily line up vertically within the column ANSWER: K POINTS: 0 / 1 11. Displays numerical data with a dollar sign at the left of the cell and decimal point that line up vertically within a column. ANSWER: A POINTS: 0 / 1 12. Displays text and numerical data as a date. ANSWER: G POINTS: 0 / 1 13. Displays text and numerical data as a time. ANSWER: B POINTS: 0 / 1 Match the following worksheet problems with the operation below that will address them. a. You need to copy data from one cell to several other adjacent cells. b. You would like to view the top row on the worksheet even when scrolling down several screens. c. You would like to place a range of data in a different part of the worksheet. d. You would like to add a blank column between two columns that already contain data. 14. Paste ANSWER: C POINTS: 0 / 1 15. Fill ANSWER: A POINTS: 0 / 1 16. Insert ANSWER: D POINTS: 0 / 1 17. Freeze Panes ANSWER: B POINTS: 0 / 1 Identify the letter of the choice that best matches the phrase or definition. a. Operand b. Operator c. Mixed cell reference d. Absolute cell reference e. Relative cell reference 18. A symbol that indicates the type of calculation to perform ANSWER: B POINTS: 0 / 1 19. A constant (text or number) or cell reference used in a formula ANSWER: A POINTS: 0 / 1 20. Adjusts to its new location when copied or moved ANSWER: E POINTS: 0 / 1 21. Do not change when copied or moved to a new cell ANSWER: D POINTS: 0 / 1 22. Cell references that contain both relative and absolute references ANSWER: C POINTS: 0 / 1 True/False Indicate whether the statement is true or false. 23. The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value. ANSWER: T POINTS: 0 / 1 FEEDBACK: 24. The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Office Button, the Ribbon, and the status bar. ANSWER: T POINTS: 0 / 1 FEEDBACK: 25. The cell in the worksheet in which you can type data is called the open cell. ANSWER: F POINTS: 0 / 1 FEEDBACK: 26. Numbers that do not fit in the cell are shown as a series of question marks (??????). ANSWER: F POINTS: 0 / 1 FEEDBACK: 27. To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a doubleheaded arrow. Click and drag to the right until the column expands to the width you want. ANSWER: T POINTS: 0 / 1 FEEDBACK: 28. Text that is too long to fit within a cell is displayed in the next cell, if it is empty. ANSWER: T POINTS: 0 / 1 FEEDBACK: 29. The primary purpose of a spreadsheet program like Excel is to solve problems that involve words. ANSWER: F POINTS: 0 / 1 FEEDBACK: 30. To paint a format, you must highlight the cell that you want to format. ANSWER: T POINTS: 0 / 1 FEEDBACK: 31. The color of the text in a cell may not be changed. ANSWER: F POINTS: 0 / 1 FEEDBACK: 32. The fill commands are available only if you plan to copy to cells adjacent to the original cell ANSWER: T POINTS: 0 / 1 FEEDBACK: 33. Inserted cells do not affect the position of existing cells. ANSWER: F POINTS: 0 / 1 FEEDBACK: 34. Freezing rows and columns locks them in position on the screen. ANSWER: T POINTS: 0 / 1 FEEDBACK: 35. Excel contains a spell checking tool. ANSWER: T POINTS: 0 / 1 FEEDBACK: 36. You can use shortcut keys to quickly cut, copy, and paste cells. ANSWER: T POINTS: 0 / 1 FEEDBACK: 37. The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet. ANSWER: F POINTS: 0 / 1 FEEDBACK: 38. To remove one or more rows or columns, right-click the selected rows or columns, and then click Delete on the shortcut menu. ANSWER: T POINTS: 0 / 1 FEEDBACK: 39. To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes. ANSWER: T POINTS: 0 / 1 FEEDBACK: 40. Design view is helpful when you prepare a worksheet for printing. ANSWER: F POINTS: 0 / 1 FEEDBACK: 41. By default, Excel is set to print pages in landscape orientation. ANSWER: F POINTS: 0 / 1 FEEDBACK: 42. In a complex formula, subtraction will be performed before multiplication. ANSWER: F POINTS: 0 / 1 FEEDBACK: 43. The AutoSum feature may be used to add a long column of numbers. ANSWER: T POINTS: 0 / 1 FEEDBACK: 44. You may display formulas in the worksheet rather than displaying formula results. ANSWER: T POINTS: 0 / 1 FEEDBACK: 45. The plus sign (+) is an example of an operand in a worksheet formula. ANSWER: F POINTS: 0 / 1 FEEDBACK: 46. Each formula begins with a quotation mark ("). ANSWER: F POINTS: 0 / 1 FEEDBACK: 47. You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references. ANSWER: T POINTS: 0 / 1 FEEDBACK: Multiple Choice Identify the choice that best completes the statement or answers the question. 48. The name of each worksheet appears in the ____ at the bottom of the worksheet window. a. sheet task bar c. sheet box b. sheet tab d. sheet dialog box ANSWER: B POINTS: 0 / 1 FEEDBACK: 49. The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell. a. Formula Bar c. Name Space b. Name Pane d. Name Box ANSWER: D POINTS: 0 / 1 FEEDBACK: 50. To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace. a. Formulas c. Data b. Proofing d. Editing ANSWER: D POINTS: 0 / 1 FEEDBACK: 51. To replace cell contents, select the cell, type the new data, and then enter the data by clicking the Enter button on the Formula Bar or by pressing the ____. a. Enter key c. either a. or b. b. Tab key d. neither a. nor b. ANSWER: C POINTS: 0 / 1 FEEDBACK: 52. ____ appear horizontally and are identified by numbers on the left side of the worksheet window. a. Rows c. Cells b. Headings d. Columns ANSWER: A POINTS: 0 / 1 FEEDBACK: 53. When Excel starts, the program window displays a blank workbook titled Book1, which includes ____ blank worksheets. a. one c. three b. two d. four ANSWER: C POINTS: 0 / 1 FEEDBACK: 54. The____ always appear in the Formula Bar. a. file name c. workbook name b. contents of the active cell d. worksheet name ANSWER: B POINTS: 0 / 1 FEEDBACK: 55. ____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. a. Headings c. Columns b. Rows d. Cells ANSWER: C POINTS: 0 / 1 FEEDBACK: 56. The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____. a. period c. comma b. semicolon d. colon ANSWER: D POINTS: 0 / 1 FEEDBACK: 57. Each cell is identified by a unique cell reference, which is formed by combining the cell's column letter and ____. a. column heading c. cell contents b. row number d. row heading ANSWER: B POINTS: 0 / 1 FEEDBACK: 58. ____ determines the best width for a column or the best height for a row, based on its contents. a. MaxFit c. FitNow b. FitAuto d. AutoFit ANSWER: D POINTS: 0 / 1 FEEDBACK: 59. Horizontal alignments do NOT include ____. a. left c. right b. centered d. bottom ANSWER: D POINTS: 0 / 1 FEEDBACK: 60. Excel ____ all numbers. a. right-aligns c. top-aligns b. left-aligns d. bottom-aligns ANSWER: A POINTS: 0 / 1 FEEDBACK: 61. To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the Home tab of the Ribbon. a. Move c. Orientation b. Text d. Align ANSWER: C POINTS: 0 / 1 FEEDBACK: 62. One way to see all the text stored in a cell is to wrap text. The ____ adjusts automatically to include additional lines until all the text is visible. a. row width c. column width b. row height d. column height ANSWER: B POINTS: 0 / 1 FEEDBACK: 63. A ____ is a preset collection of design elements, including fonts, colors, and other effects. a. gallery c. theme b. style d. group ANSWER: C POINTS: 0 / 1 FEEDBACK: 64. Press the ____ keys to apply underlining. a. Ctrl+B c. Ctrl+U b. Ctrl+L d. Ctrl+I ANSWER: C POINTS: 0 / 1 FEEDBACK: 65. To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys a. Ctrl+1 c. Ctrl+3 b. Ctrl+2 d. Ctrl+4 ANSWER: A POINTS: 0 / 1 FEEDBACK: FIGURE 2-1 Excel Case 2-1 Tessa's boss gave her the spreadsheet above. She is working on changing the formatting. Please refer to the figure above while answering the question below. 66. Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this? a. On the Home tab, in the Editing group, click the Find & Select button, and then click Replace b. On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace c. On the Home tab, in the Proofing group, click the Find & Select button, and then click Find d. none of the above ANSWER: A POINTS: 0 / 1 FEEDBACK: 67. A group of cells that touch each other and form a rectangle are a a. cell. c. highlight. b. range. d. name box. ANSWER: B POINTS: 0 / 1 FEEDBACK: 68. Which of the following copies formatting from a cell and applies it to other cells? a. Format Painter b. Copy c. Currency Style d. AutoFormat ANSWER: A POINTS: 0 / 1 FEEDBACK: 69. If you want to center a title over a worksheet area, which formatting feature would you choose? a. Center button b. wrap text c. Merge and Center button d. Autoformat ANSWER: C POINTS: 0 / 1 FEEDBACK: 70. Which of the choices below lists an example of a cell address for a label somewhere in the first column? a. 1A c. A1 b. B1 d. all the choices listed are correct ANSWER: C POINTS: 0 / 1 FEEDBACK: 71. When you are using the copy-drag-and-drop method, what should your mouse pointer look like? a. c. b. d. no choice given is correct ANSWER: A POINTS: 0 / 1 FEEDBACK: 72. What should you do if you accidentally delete a column? a. Insert a new column b. Undo the action that deleted the column c. Redo the action that deleted the column d. Make more room in the existing column by widening it. ANSWER: B POINTS: 0 / 1 FEEDBACK: 73. What location would you place the active cell into, in order to freeze the panes so that column A and rows 1-4 don't move when the user scrolls down and to the right. a. A5 c. B4 b. A4 d. B5 ANSWER: A POINTS: 0 / 1 FEEDBACK: 74. What happens if data are copied in cells that have existing data? a. the new data will not be copied b. the old data will be placed on the clipboard c. an error/warning message will appear d. the old data will be replaced by the new data ANSWER: D POINTS: 0 / 1 FEEDBACK: 75. On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells. a. Format c. Workbook b. Worksheet d. Cells ANSWER: D POINTS: 0 / 1 FEEDBACK: 76. To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab. a. row number c. column letter b. row letter d. column number ANSWER: A POINTS: 0 / 1 FEEDBACK: 77. To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button. a. Page Layout c. Format b. Layout d. Page Setup ANSWER: D POINTS: 0 / 1 FEEDBACK: 78. Worksheets printed in ____ orientation are wider than they are long. a. portrait c. wide b. landscape d. normal ANSWER: B POINTS: 0 / 1 FEEDBACK: 79. Excel inserts ____whenever it runs out of room on a page. a. a blank row c. an automatic hyperlink b. an automatic page break d. a paragraph marker ANSWER: B POINTS: 0 / 1 FEEDBACK: 80. A ____ is text that prints in the top margin of each page. a. header c. margin b. footer d. marker ANSWER: A POINTS: 0 / 1 FEEDBACK: 81. A ____ is text that prints in the bottom margin of each page. a. header c. margin b. footer d. marker ANSWER: B POINTS: 0 / 1 FEEDBACK: 82. Which operator represents exponentiation? a. ^ c. + b. * d. / ANSWER: A POINTS: 0 / 1 FEEDBACK: 83. Which of the following do you press to switch between displaying formulas and displaying values? a. Ctrl+~ c. Shift+# b. Ctrl+> d. Shift+* ANSWER: A POINTS: 0 / 1 FEEDBACK: 84. In the formula =B5*3, what is the operator? a. B5 c. * b. = d. 3 ANSWER: C POINTS: 0 / 1 FEEDBACK: 85. The sequence used to calculate the value of a formula is called the ____. a. evaluation map c. order of evaluation b. sequence map d. sequence order ANSWER: C POINTS: 0 / 1 FEEDBACK: 86. When the formula =A3+A4 is copied from cell A5 to cell B5, the formula changes to ____. a. =B3+B4 c. =$B3+$B4 b. =B4+B5 d. =B$4+B$5 ANSWER: A POINTS: 0 / 1 FEEDBACK: 87. When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____. a. =$A$3+$A$4 c. =A3+A4 b. =$B$5+$B$6 d. =$B$3+$B$4 ANSWER: A POINTS: 0 / 1 FEEDBACK: 88. The Sum button is located in the ____ group on the Home tab of the Ribbon. a. Commands c. Editing b. Formulas d. Data ANSWER: C POINTS: 0 / 1 FEEDBACK: 89. The SUM function that adds the numbers in the range D5:D17 is ____. a. SUM(D5:D17) c. (D5:D17)SUM b. =SUM(D5:D17) d. =(D5:D17)SUM ANSWER: B POINTS: 0 / 1 FEEDBACK: