CIS111E Chapter 2 Formulas and Functions

Card Set Information

CIS111E Chapter 2 Formulas and Functions
2015-09-26 13:38:42

Formulas and Functions
Show Answers:

  1. Relative Cell Reference (p. 158)
    Indicates a cell's relative location, such as five rows up and one column to the left, from the cell containing the formula.
  2. Absolute Cell Reference (p. 158)
    Provides a permanent reference to a specific cell.
  3. Mixed Cell Reference (p. 160)
    Combines an absolute cell reference with a relative cell reference.
  4. Circular Reference (p. 160)
    A formula that contains a direct or indirect reference to the cell containing the formula.
  5. Function (p. 166)
    Predefined computation that simplifies creating a formula that performs a complex calculation.
  6. Argument (p. 166)
    An input, such as a cell reference or value, needed to complete a function
  7. Syntax (p. 166)
    A set of rules that governs the structure and components for properly entering a function.
  8. Formula AutoComplete (p. 166)
    Displays a list of functions and defined names that match letters as you type a formula.
  9. Function ScreenTip (p.167)
    A small pop-up description that displays the function's arguments.
  10. SUM function (p. 168)
    Totals values in two or more cells and displays the result in the cell containing the function.
  11. AVERAGE function (p. 170)
    Calculates the arithmetic mean, or average, for the values in a range of cells.
  12. MEDIAN function (p. 170)
    Finds the midpoint value, which is the value that one half of the data set is above or below.
  13. MIN function (p. 171)
    Displays the lowest value in a range.
  14. MAX function (p. 171)
    Identifies the highest value in a range.
  15. COUNT function (p. 171)
    Tallies the number of cells in a range that contain values.
  16. COUNTBLANK function (p. 171)
    Tallies the number of cells in a range that are blank.
  17. COUNTA function (p. 171)
    Tallies the number of cells in a range that are not blank, that is, cells that contain data, whether a value, text, or a formula.
  18. TODAY function (p. 173)
    Displays the current date.
  19. NOW function (p. 173)
    Uses the computer's clock to display date and military time.
  20. IF function (p. 181)
    Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
  21. Logical Test (p. 182)
    An expression that evaluates to true or false.
  22. Lookup Table (p. 184)
    A range that contains data for the basis of the lookup and data to be retrieved.
  23. Breakpoint (p. 184)
    The lowest value for a category or in a series.
  24. VLOOKUP function (p. 184)
    Looks up a value in a vertical lookup table and returns a related result from the lookup table.
  25. PMT function (p. 187)
    Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
  26. Rate (p. 187)
    Is the periodic interest rate, the interest rate per payment period.
  27. NPER (p. 187)
    Is the total number of payment periods.
  28. PV (p. 187)
    Is the present value of the loan.
  29. Range Name (p. 192)
    A word or string of characters that represents one or more cells.