CA II EOC Review - Spreadsheets

Edit Answers
123456789101112131415161718192021222324252627282930
Across
  1. 3. Rectangular area bound by the category and value axes
  2. 5. A feature that combines a data document with a main document to mass produce personalized letters or other documents
  3. 8. What is shown in a chart, created from row or column headings
  4. 10. Optional title or name for a chart
  5. 11. An automatic feature moves text to the next line when a line is full and text can no longer fit
  6. 13. Cell address that does not change when copied in a formula
  7. 16. Values or cell references (included between parentheses) that a function needs to complete its calculation
  8. 17. Cell address that adjusts either the row or the column when the formula is copied
  9. 19. Data is arranged in the shape of a pie with data represented by various percentages of the pie
  10. 20. A method of keeping certain rows of columns visible at all times (such as headings or certain labels)
  11. 23. Projecting with a spreadsheet by changing the data
  12. 26. A built-in mathematical function that determines the average of a block of cells
  13. 28. Format data using commas and dollar signs
  14. 29. Sets of formatting specifications
  15. 30. Chart object that explains the colors, patterns, or symbols used in a chart
Down
  1. 1. A chart in which data is represented by vertical bars
  2. 2. Chart in which data is represented by lines
  3. 4. Returns the lowest number in a range
  4. 6. A format that converts a decimal number to a percentage
  5. 7. Alternative term for order of precedence
  6. 9. Object that explains the colors, patterns, or symbols used in a chart
  7. 12. Function that returns the highest number in a range of cells
  8. 14. Cell address that adjusts to the row or column where a copied formula is located
  9. 15. A feature that allows the user to copy of fill data in cells adjacent to the original cell
  10. 18. Data is represented by horizontal bars
  11. 21. Built-in set of formatting instructions that applies fonts, colors, borders, and other formats to a range
  12. 22. Horizontal or vertical grouping of values from the worksheet
  13. 24. Printing option that allows user to change page scaling
  14. 25. One value from a data series
  15. 27. Built-in mathematical formula