Lesson 19 Excel Vocabulary

1234567891011121314
Across
  1. 2. an calculations that you could perform using a scientific calculator
  2. 3. functions that describe large quantities of data
  3. 4. displayed within a worksheet and one that you can place alongside the data source, giving context to the chart
  4. 5. Specifies the numbers, text, or cell references used by a function to calculate a value
  5. 9. if you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula
  6. 12. a mathematical expression that calculates a value
  7. 14. the sequence used to calculate the value of a formula
Down
  1. 1. points to a specific cell and does not change when copied
  2. 6. a number or cell reference
  3. 7. graph that provides a visual representation of the workbook data
  4. 8. contains both relative and absolute references
  5. 10. containing more than one operator
  6. 11. a special formula that names a function instead of using operators to calculate a result
  7. 13. a mathematical symbol that you use to combine values and then return a single value