FITS Lecture 3 Spreadsheet

12345678910111213141516171819202122232425262728293031323334
Across
  1. 2. Symbol used to specify calculation like + - * /
  2. 5. Checking formulas for accuracy and correct cell references
  3. 11. Number style displaying values with a currency symbol
  4. 13. Small square at bottom-right corner of a cell used to copy formulas
  5. 15. Changes appearance of cells based on criteria
  6. 18. Automatically fills data when a pattern is detected
  7. 22. Returns the current date
  8. 23. A cell or range of cells used in calculation
  9. 24. Finds the highest value in a range
  10. 27. Finds the lowest value in a range
  11. 28. Small button that provides automatic feature options
  12. 29. A predefined set of colors fonts and effects for a worksheet
  13. 30. Tool to identify and correct spelling errors in a worksheet
  14. 32. Calculates the mean of selected cells
  15. 34. Counts empty cells in a range
Down
  1. 1. A mathematical expression in Excel
  2. 3. Displays how the worksheet will look when printed
  3. 4. A predefined formula in Excel
  4. 6. Displays the formulas instead of results in the worksheet
  5. 7. Adds cells that meet a condition
  6. 8. Intersection of a row and column
  7. 9. Number style that aligns currency symbols and decimals
  8. 10. Restricts type of data entered into a cell
  9. 12. Number style that displays values as percentages
  10. 14. A set of predefined formatting options for cells
  11. 15. A number or text value that does not change
  12. 16. Returns the current date and time
  13. 17. Counts cells meeting a specified condition
  14. 19. A file containing one or more worksheets
  15. 20. Highlights which cells are referenced in a formula
  16. 21. Counts the number of numeric entries in a range
  17. 25. A single page in an Excel workbook
  18. 26. Adds a series of values together
  19. 31. A vertical group of cells in Excel
  20. 33. A horizontal group of cells in Excel