Functions are limited programmed calculations that we can directly use to find specific information and display it in our bill of materials. They include the following:

• If: This opens an if statement that will allow us to apply a condition.
• Average: This finds the average between different values.
• Count: This counts the number of cells, regardless of whether the cell is empty or filled.
• Max: This finds the maximum value within the selected cells.
• Min: This finds the minimum value within the selected cells.
• Sum: This finds the sum of values with the selected cells.
• Total: This sums all of the values in the column that are located above the selected cell.

Next, we will learn about mathematical operations.