Tutorial 8 Crossword

123456789101112131415
Across
  1. 4. / logical function that returns a TRUE value if any of the logical conditions are true, and a FALSE value if none of the logical conditions are true
  2. 5. / when the lookup value is less than or equal to the largest possible value in the first column of the lookup table, the corresponding value from the second column is returned to the cell
  3. 6. / logical function that evaluates a condition, and then returns one value if the condition is true, and a different value if the condition is false
  4. 7. / provides access to the Duplicate values conditional format and the Manage Rules options
  5. 9. / an expression that returns either a TRUE value or a FALSE value
  6. 10. / determines if a cell contains an error value and then displays the message you choose rather than the default error value
  7. 11. / function that adds the values in a range that match criteria you specify
  8. 12. /function that calculates the average of values in a range that match criteria you specify
  9. 13. / actual table name or column header used to create a formula that references all or parts of an Excel table
  10. 15. / horizontal lookup function that searches across the first row of the lookup table until the lookup value exactly matches a value in the first row and then retrieves corresponding value from second row of lookup table
Down
  1. 1. / function that calculates the number of cells in range that match criteria you specify
  2. 2. / specifies the condition, the formatting, and the cell or range to apply the rule to
  3. 3. / logical function that returns a TRUE value if all of the logical conditions are true, and a FALSE value if any of the logical conditions are false
  4. 7. / formula automatically copied to all cells in a column within an Excel table
  5. 8. / when one IF function is placed inside another IF function to test an additional condition
  6. 14. / value you are trying to find