Database and Spreadsheet Terminology Review

1234567891011121314151617181920
Across
  1. 2. Known as a 'graph' in UK English.
  2. 3. Form of data.
  3. 4. Container of data about one aspect of a topic or issue e.g. first name, last name.
  4. 5. Type of spreadsheet operators that do +, -, /, *, ˆ
  5. 8. Automatic method or function to do something specific e.g. SUM, IF etc.
  6. 10. Type of cell reference which has $ in it e.g. $A$4.
  7. 13. Database where tables are linked together.
  8. 16. The cell which is currently selected.
  9. 17. Link between tables.
  10. 18. Current page or component of a spreadsheet. Also known as a spreadsheet 'tab'.
  11. 19. Collection of data related to one topic or component of an issue.
  12. 20. Request or search for information in a database.
Down
  1. 1. Collection of data organised around a topic or issue.
  2. 4. Where you type in formulas, mathematical operators, etc.
  3. 6. Field whose values are used to join two or more tables together
  4. 7. Database with only one big large table.
  5. 9. Field whose values are always unique.
  6. 11. Visual representation of a model.
  7. 12. Definition of a field's name, data type and description.
  8. 14. Mathematical representation of reality.
  9. 15. Collection of facts, usually numeric, upon which calculations need to be performed.