EXCEL Crossword Puzzle

123456789
Across
  1. 2. A function that adds up all of the numbers in a range of cells based on a criterion that the user specifies.
  2. 3. A list of commands that are recorded or coded with the purpose of executing the commands using a single command.
  3. 7. A function used in a formula within another function.
  4. 8. A function that allows the user to make a comparison between two values and then returns a true or false result.
  5. 9. A function that performs a vertical lookup to retrieve data from a specific column in a table.
Down
  1. 1. A feature that creates rows and columns based on values in the selected cells.
  2. 4. A function that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.
  3. 5. A function that performs a horizontal lookup by searching for a value in the top row of a table and returning the value from the same column.
  4. 6. A function that uses a position to return a value within a table or range.