Excel B

1234567891011121314151617181920
Across
  1. 2. type of cell reference that doesn't change when copied
  2. 7. button on the ribbon that adds up all the numbers in a range of cells
  3. 9. rules that determine which operation to perform first
  4. 12. type of cell reference that looks like this: A2
  5. 13. type of cell reference that looks like this: G$12
  6. 14. dragging the fill handle on a cell to copy the cell's contents
  7. 16. a formula that uses more than one arithmetic operator.
  8. 19. function that returns the smallest value in a set of values
  9. 20. the equal sign
Down
  1. 1. item on the ribbon that open a dialog box or tast pane
  2. 3. function that adds all the numbers in a range of cells
  3. 4. function that counts the number of cells in a range that contain numbers
  4. 5. a predefined worksheet formula
  5. 6. function that adds all the numbers and divides the sum by the number of cells
  6. 8. displays a list of functions from which you can choose
  7. 10. button you press while dragging and dropping to copy cells
  8. 11. clears the contents of selected cells
  9. 15. puts the cell into edit mode
  10. 17. lets you convert from relative cell reference to an absolute cell reference
  11. 18. function that returns the largest value in a set of values