Ch. 11 Vocab Crossword: Advanced Spreadsheet Uses

12345678910111213
Across
  1. 4. Form of copying and pasting.
  2. 5. Function that tests for true or false.
  3. 8. Value the function needs for the calculation.
  4. 9. Used to display trends over time.
  5. 10. Number of periods it will take to repay a loan.
  6. 11. Preprogrammed formula in spreadsheet software.
  7. 12. Best chart type for comparing individual values across categories. Also called a column chart in Microsoft Excel.
  8. 13. Amount of a loan.
Down
  1. 1. Contains only the data from a spreadsheet with commas to denote the beginning and end of each datum in a row.
  2. 2. Chart that displays the relative size of each fractional part of a whole.
  3. 3. Similar to embedding, but a connection is maintained between the copy and the original source.
  4. 6. Changes the appearance of a cell’s value based on parameters set by the user.
  5. 7. Illustrates data in a picture-like format. Also called a graph.