Excel Unit Exam Review

1234567891011121314151617
Across
  1. 4. To delete a row, select the row heading on the Home tab in the Cells group, click the __________ button arrow, and select Delete Sheet Rows.
  2. 6. Which of the following describes the performance of the first calculation of a formula? (Remember PEMDAS!)
  3. 9. If you want to calculate how much interest you will pay on your mortgage, which function icon would you click in the Formulas tab?
  4. 12. Which command is used to insert a cut or copied selection into a cell or range of cells?
  5. 14. Which Excel feature is used to fill cells with data that is based on data in other cells or that follows a pattern?
  6. 15. The __________ handle is the small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series.
  7. 16. Click the __________ tab to get to Backstage view.
  8. 17. Which of the following places a duplicate of a selection in the Office Clipboard?
Down
  1. 1. Which of the following is a group of adjacent cells that you select to perform operations on all of the selected cells?
  2. 2. When you wish to reduce the visibility of unwanted rows or columns in a spreadsheet, what option from the shortcut menu can you use?
  3. 3. The columns in a worksheet are identified by __________.
  4. 5. Active cells in a worksheet are outlined by a bold __________.
  5. 7. All formulas begin with which character?
  6. 8. Which function determines the smallest value of a given list of numbers or arguments?
  7. 10. Which command spreads text evenly throughout the cell?
  8. 11. The __________ bar is near the top of the Excel window where you can enter or edit cell entries.
  9. 13. To __________ means to arrange and align or bring into alignment.
  10. 17. Which is the intersection of a row and column?