Google Sheets Formulas

1234567891011121314151617
Across
  1. 1. a formula that allows you to divide one value by another and enter the quotient in the cell.
  2. 3. allows you to split text in a single cell into multiple cells.
  3. 5. a formula that adds the values within a range of cells.
  4. 7. a formula that determines a value for the cell if a function returns an error in a particular cell (or group of cells).
  5. 8. formula that finds the average of the data in a range of cells.
  6. 11. a formula that allows you to sort cells with numerical data from the lowest value to the highest.
  7. 12. a simple function that allows you to add the sum of two values to enter into a cell.
  8. 13. a formula that multiplies one number by another and input the product into the cell.
  9. 14. a formula that allows you to input the current time and date into a cell.
  10. 15. a formula used to determine how many cells within a range contain a value.
  11. 17. a formula that finds the sum of cells that meet certain conditions.
Down
  1. 2. a vertical lookup function that allows you to look up specific data within the spreadsheet.
  2. 4. a formula that enters the current date into a cell on your spreadsheet.
  3. 6. a simple formula you can use to subtract on value from another and input the sum into a cell.
  4. 9. a formula that determines whether two values within different cells on your spreadsheet are the same.
  5. 10. a formula that allows you to perform an action on multiple ranges of data, such a s adding the values of data in two seperate lists.
  6. 15. Formula that allows you to count how many cells within a certain range contain a value if they meet certain conditions.
  7. 16. formula that converts numbers within cells into formats such as currency, decimals, dates, or text.