Excel Tutorial 1.2

123456789101112131415161718192021222324252627
Across
  1. 3. A formula is written using __________ that combine different values, resulting in a single value that is then displayed in the cell.
  2. 6. result of the formula When the active cell contains a formula, the ____________ appears in the formula bar and the ____________ appears in the cell.
  3. 10. and Drop The technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, dragging the selection to a new location, and then releasing the mouse button.
  4. 12. An expression that calculates a value.
  5. 14. Redisplays the hidden content in the workbook.
  6. 16. Removes the data from the selected row or column but leaves the blank row or column in the worksheet.
  7. 17. This function adds the values in the specified range.
  8. 18. A temporary storage location for text and graphics.
  9. 21. Orientation Specifies in which direction content is printed on the page.
  10. 23. Sign (=) In Excel, every formula begins with a(n) _________.
  11. 24. Orientation In this page orientation, the page is wider than it is tall.
  12. 26. You can force the printout to a single page by __________ the printed output.
  13. 27. Essentially decreases that row height or column width to 0 pixels.
Down
  1. 1. Orientation In this page orientation, the page is taller than it is wide.
  2. 2. Changes a workbook's appearance to make the content of a worksheet easier to read.
  3. 4. of Operations If a formula contains more than one arithmetic operator, Excel perform s the calculation based on the __________, which is the sequence in which operators are applied in a calculation.
  4. 5. A line that you add along an edge of a cell. Borders are used to improve the readability of the worksheet.
  5. 7. Quickly inserts functions to sum, average, or count values in a range or find the minimum or maximum value in a range.
  6. 8. A named operation that replaces the action of an arithmetic expression.
  7. 9. Layout Tab Used to specify how the worksheet will be arranged.
  8. 11. Operators The most common operators that perform addition, subtraction, multiplication, division, and exponentiation.
  9. 12. Size Specifies how big the text is.
  10. 13. Every function follows a set of rules, or __________, which specifies how the function should be written.
  11. 15. View. Shows the contents of the active sheet in the workbook window.
  12. 19. Layout View Shows how the worksheet will appear when printed.
  13. 20. Removes the data from the row or column as well as the row or column itself.
  14. 22. Fill Enters text based on patterns it finds in the data.
  15. 25. Break Preview Shows the location breaks in the printed worksheet.