Name _____________________________________________ Sect. _____ Score _____/40

Excel Chapter 16 Review Sheet

Complete the sentences below to hand in at the start of our next class.

  1. pg. 319: A worksheet consists of a grid of rows and columns into which you can enter numbers, __________________, and _______________________.
  2. pg. 319: Excel refers to a spreadsheet as a ________________________. A worksheet is always stored in a ____________________________ that contains one or more worksheets.
  3. pg. 320: The mouse pointer displays as a ______________________________ when it’s within the worksheet.
  4. pg. 320: Columns appear vertically and are identified by ____________________ at the top of the worksheet window. Rows appear horizontally and are identified by ____________________ at the left side of the worksheet window.
  5. pg. 320: The intersection of a single row and a single column is called a __________________.
  6. pg. 321: A _____________________________ appears around the active cell.
  7. pg. 321: When text is too long for a cell, it will _____________________________ into the next cell if the cell is empty. If it’s not empty, the text that doesn’t fit into the cell will ___________________________________.
  8. pg. 321: Numerical data may appear as a series of ____________________________ if the number does not fit in the cell.
  9. pg. 321: To select an entire row in a worksheet, click the ______________________________ at the left of the screen.
  10. pg. 322 (Table 16-1): To move the insertion point to the last cell with data in a row, press ________ plus ____________________. To move to the first cell in a row, press Ctrl plus _______________.
  11. pg. 324: If you choose not to enter the data you have keyed, you can press __________ or click the _____________________ button (the red X) in the Formula Bar.
  12. pg. 324: The ___________________________ feature in Excel corrects common mistakes as you enter data.
  13. pg. 324: With the _____________________________ feature, Excel completes the first few characters you key in a cell with existing entries in the same column. If the characters match an existing entry, Excel _____________________ the existing entry.
  14. pg. 325: When you add a new column, the existing data shifts to the ___________________.
  15. pg. 325: To insert or delete multiple columns and rows in a single step, select the _______________ number of columns or rows before executing the command.
  16. pg. 327: When data is too wide for the cell, Excel displays a series of number signs (####), _________________ the data, or allows the data to run ____________________ the column, depending on the type of data in the cell.
  17. pg. 327: You can widen the column in two ways: drag the _______________________ of the column letter to the desired size, or select the cells you want to change and then use the Column command on the _____________________ menu and then select Width from the submenu to specify the exact width, or you can let Excel find the best fit by clicking the ___________________ option on the same submenu.
  18. pg. 328: You can choose to have text wrap within a cell in the same way text wraps within a word-processing document. Select the cells, open the Format menu, and then choose ________________, and click the _____________________ tab and turn on the Wrap text option.
  19. pg. 328: If you want to clear the cell contents but not replace it with other data, select the cell and then press the _________________________________ or the ____________________________.
  20. pg. 328: When you delete data using the Delete or Backspace keys, the ____________________ for the cell remain in the cell.
  21. pg. 329: The fill command can only be used when the destination cells are ____________________ to the original cell.
  22. pg. 331: By default, Excel aligns text at the ____________________ of the cell and numbers at the ____________________ of the cell.
  23. pg. 332: In the Format Cells dialog box, the _______________________ tab gives you options for outlining a cell or range of cells.
  24. pg. 332: In the Format cells dialog box, the _________________________ tab lets you add a fill color or shading pattern to cells.
  25. pg. 334: If you undo an action and then change your mind, you can reverse the undo action by using the ______________________ command.
  26. pg. 334: When you undo or redo an action from the drop-down list, Excel will also undo or redo all the actions listed ________________________ on the list.