PITS Crosswords Part 1

12345678910111213141516171819202122232425262728293031323334353637383940
Across
  1. 8. Excel button that quickly totals a selected range
  2. 11. Output object used for formatted printing in Access
  3. 13. Cell reference with $ signs that does not change when copied
  4. 16. Unique identifier field that cannot contain duplicates
  5. 18. Visual representation of data like bar or pie
  6. 19. Query that prompts the user for input each time it runs
  7. 20. A single column of data in an Access table
  8. 22. Database object that stores data in rows and columns
  9. 23. Set of automated actions in Access to perform tasks
  10. 24. An Excel file that can contain multiple worksheets
  11. 26. Excel function that returns the mean of numbers
  12. 27. Built-in Excel calculation like SUM or AVERAGE
  13. 28. Link between tables using matching fields
  14. 32. A single tab/page inside an Excel workbook
  15. 36. Faint background text/image behind Word content
  16. 37. Box on a PowerPoint slide where content is inserted
  17. 38. Print option that includes slide with speaker notes
  18. 39. Effect used when moving from one slide to the next
  19. 40. Report feature that organizes records into categories
Down
  1. 1. Print option that puts multiple slides on one page
  2. 2. Cell reference that changes when copied to another cell
  3. 3. Electronic grid for rows and columns used to organize and calculate data
  4. 4. Starts with "=" in Excel to calculate values
  5. 5. Text area at the bottom of each Word page for repeated info
  6. 6. Question you ask Access to retrieve selected data
  7. 7. Excel feature that changes cell formatting when a rule is met
  8. 9. Combination of fields, operators, and functions used in calculations
  9. 10. Menu-like form with buttons for navigation in Access
  10. 12. Field setting in Access that controls what kind of data can be stored
  11. 14. Pre-designed set of colors and fonts for PowerPoint slides
  12. 15. A single row of data in an Access table
  13. 17. Effect applied to objects on a slide (text, images, shapes)
  14. 18. Query field created using a formula such as OnHand*Cost
  15. 21. Excel function that searches vertically and returns a matched value
  16. 25. Step-by-step tool that helps create objects quickly
  17. 29. Controls the layout and formatting of all slides
  18. 30. Graphical interface used to enter and edit data in Access
  19. 31. Excel feature that restricts what users can type in a cell
  20. 33. Condition used in a query to filter results
  21. 34. Word tool that generates multiple letters from a data list
  22. 35. Arranging data in ascending or descending order