1.01 - 1.05 Crossword Puzzle

123456789101112131415161718192021222324252627282930313233343536373839
Across
  1. 1. Function A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
  2. 2. Options A series of settings that allow you to change how a
  3. 5. A number, a cell address, a date, text, or Boolean data in
  4. 7. prints.
  5. 9. subtraction, multiplication, and division, on values in a worksheet.
  6. 10. Cell References A cell reference that adjusts the cell
  7. 12. or row reference, but not both.
  8. 14. formatting and formulas complete with designs, tools, and specific data types.
  9. 16. Or an area of the Backstage
  10. 18. An element that identifies the values to be used in a
  11. 20. Function A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
  12. 22. Pane A pane found on the left side of Backstage
  13. 24. based on its row number and column letter.
  14. 26. Regarding formulas, it is usually a number or cell address.
  15. 27. row markers in a cell address.
  16. 31. Reference A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
  17. 32. you set the scope of a named range to Workbook, you can
  18. 33. A symbol or name that represents something else; it
  19. 35. Commands on the default ribbon tabs are related in functionality.
  20. 37. Reference A reference that identifies a cell's location in the
  21. 38. The location within which Excel recognizes a named
  22. 39. An equation that performs calculations, such as
Down
  1. 1. A number or text value entered directly into a formula.
  2. 3. Function A function that determines how many cells in a range contain a number.
  3. 4. row markers in a cell address.
  4. 6. the named range on any sheet in the workbook.
  5. 8. Operator A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column
  6. 11. Range A group of cells, and occasionally a single cell, with a designated name.
  7. 13. automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
  8. 15. through a series of tabs.
  9. 17. Cell Reference A cell reference that uses an absolute
  10. 19. Parenthesis Parentheses inside of parentheses within a formula.
  11. 21. It provides you access to workbook and file-related
  12. 23. Cell Reference A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column
  13. 25. Files that already
  14. 28. Setting Pre-set options that determine how Excel will behave when performing an
  15. 29. which is either a specific worksheet or the entire workbook.
  16. 30. An area on the ribbon that contains groups of related
  17. 34. Files that already
  18. 36. of Operations The rules Excel follows to calculate any formula that contains two or more operators.
  19. 37. be a cell address, a range of cells, and so on.