Excel 5.1-5.6

12345678910111213141516171819202122232425262728
Across
  1. 2. This paste option applies the formatting from copied cells to destination cells.
  2. 6. Basic math operations like addition (+), subtraction(-), multiplication (*), and division(/).
  3. 11. This option prevents locked cells from being edited. You also have the option of adding password protection to a worksheet.
  4. 12. This paste option switches the rows and columns of the copied cells.
  5. 14. The color of the cell background. By default, there is no fill color.
  6. 15. A feature in Excel that automatically performs a calculation (like addition) on a group of numbers.
  7. 16. A feature that automatically adjusts the width and height of a column, row, cell, or header.
  8. 19. There are two page orientation options: Portrait, where the long edge of the paper is vertical; and Landscape, where the long edge of the paper is horizontal.
  9. 21. When activated, text will begin a new line when it reaches the end of a cell instead of continuing beyond the cell boundary.
  10. 22. Combines selected cells into one large cell, then centers the content.
  11. 23. A workbook tool that displays the contents of the active cell; it can be used to enter new values and formulas.
  12. 25. The values inside the parentheses of a function.
  13. 27. A document that stores and manipulates data in columns and rows.
  14. 28. Cells By default, locked cells cannot be edited when a worksheet is protected. Unlocked cells can still be edited.
Down
  1. 1. Hiding a row or column removes the information from view. However, the information is not deleted, and can be viewed by unhiding.
  2. 3. A frozen row or column that will stay visible on the screen no matter where you scroll on the worksheet. A common application is to freeze row and column titles on large worksheets.
  3. 4. The default file extension for Excel workbooks.
  4. 5. A set of calculations that are applied to values in a spreadsheet. Formulas range from simple mathematical operations to complex statistical calculations.
  5. 7. A computational procedure that performs a specific operation.
  6. 8. Displays numerical information, such as a date, monetary value, percentage, phone number, etc. Number formatting does not change the value of the cell.
  7. 9. A single spreadsheet within a workbook.
  8. 10. Draws an outline around a cell or group of cells.
  9. 13. This paste option enters the values of the copied cells. It does not copy formulas or source formatting.
  10. 17. These allow you to designate rows or columns to be repeated on each printed page. They are especially useful for printing labels and row/column headers.
  11. 18. A file that contains one or more related worksheets.
  12. 20. Designates a section of a worksheet to be printed. Information outside the print area will not be printed.
  13. 24. Predefined formatting options that can be applied to cells or groups of cells.
  14. 26. The Comma Separated Values extension is frequently used by spreadsheet programs other than Excel and by data downloaded from an Internet database