Google Sheets Formulas

1. a formula that allows you to divide one value by another and enter the quotient in the cell.
3. allows you to split text in a single cell into multiple cells.
5. a formula that adds the values within a range of cells.
7. a formula that determines a value for the cell if a function returns an error in a particular cell (or group of cells).
8. formula that finds the average of the data in a range of cells.
11. a formula that allows you to sort cells with numerical data from the lowest value to the highest.
12. a simple function that allows you to add the sum of two values to enter into a cell.
13. a formula that multiplies one number by another and input the product into the cell.
14. a formula that allows you to input the current time and date into a cell.
15. a formula used to determine how many cells within a range contain a value.
17. a formula that finds the sum of cells that meet certain conditions.

2. a vertical lookup function that allows you to look up specific data within the spreadsheet.
4. a formula that enters the current date into a cell on your spreadsheet.
6. a simple formula you can use to subtract on value from another and input the sum into a cell.
9. a formula that determines whether two values within different cells on your spreadsheet are the same.
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.
15. Formula that allows you to count how many cells within a certain range contain a value if they meet certain conditions.
16. formula that converts numbers within cells into formats such as currency, decimals, dates, or text.