Module 2 Excel Elizabeth Westfall

Edit Answers
1234567891011121314151617181920212223242526
Across
  1. 3. The sequence in which operators are applied in a calculation
  2. 7. Information that appears at the top of each page
  3. 11. A function that displays the highest value in a range
  4. 12. A feature that automatically increases or decreases the width of a column so that the widest entry will fit
  5. 13. A command that checks for spelling errors
  6. 15. A function that calculates the average value of a collection of numbers
  7. 16. A letter number symbol or punctuation mark
  8. 17. The space between the page context and the edges of the page
  9. 18. Text or graphics at the bottom of each page
  10. 19. A reference that occurs when a formula refers to the same cell in which it is entered
  11. 20. A predefined coordinated set of colors fonts graphical effects that can be applied
  12. 22. The range being used as a destination in a data exchange
  13. 23. A range being used as a source
  14. 25. Short for picture element, an individual point of color on a display screen or printout
  15. 26. Special formatting that is applied if values meet specified criteria
Down
  1. 1. A function that displays the lowest value in a range
  2. 2. A reference in which a cell formula refers to another cell or cells that include a formula that refers back to the original cell
  3. 4. A formula that calculates the product of two or more numbers
  4. 5. A mathematical statement in a spreadsheet or table cell that calculates a value using cell references numbers and arithmetic operators
  5. 6. In programming to find and correct an error in VBA code and in Excel to find and correct errors in a worksheet
  6. 8. A symbol that alerts Excel that you are entering a formula or function
  7. 9. A cell reference that changes when the formula containing that reference is moved to a new location
  8. 10. The view that shows how the sheet will look when printed
  9. 14. An error in a spreadsheet that occurs when one of the defining values in a cell is itself
  10. 21. A feature that checks which cells are referenced in the formula assigned to the active cell
  11. 24. An Excel mode that lets you select cells to use in a formula by using the pointer or screen tap