| A | B |
|---|
| SUM | gives the total of the selected range of cell values |
| AVERAGE | calculates the average of the selected range of cell values |
| COUNT | counts the total number of cells in a range that contains a number |
| SUBTOTAL | returns the subtotal in a database |
| MODULUS | works on returning the remainder when a particular number is divided by a divisor |
| POWER | returns the result of a number raised to a certain power |
| CEILING | rounds a number up to its nearest multiple of significance |
| FLOOR | rounds a number down to the nearest multiple of significance |
| CONCATENATE | merges or joins several text strings into one text string |
| VLOOKUP | finds things in a table or a range by row |
