Google Sheets Functions MP3

Learn: A functionis a predefined formula that performs calculations using specific values in a particular order. Google Sheets includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.Google Sheets has a variety of functions available. Here are some of the most common functions you'll use:SUM: This functionaddsall of the values of the cells in the argument.AVERAGE: This function determines theaverageof the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.COUNT: This functioncountsthe number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.MAX: This function determines thehighestcell valueincluded in the argument.MIN: This function determines the lowest cell value included in the argument. Watch Me The parts of a function Similar to entering a formula, the order in which you enter a function into a cell is important. Each function has a specific order—called syntax—that must be followed in order for the function to calculate properly. The basic syntax to create a formula with a function is to insert an equals sign (=), a function name (AVERAGE, for example, is the function name for finding an average), and an argument. Arguments contain the information you want the formula to calculate, such as a range of cell references. Working with arguments Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.For example, the function =AVERAGE(B1:B9) would calculate the average of the values in the cell range B1:B9. This function contains only one argument. Creating a function The Functions button allows you to automatically return the results for a range of cells. The answer will display in the cell below the range.1. Select the range of cells you want to include in the argument. In this example, we'll select D3:D12.2. Click the Functions button, then select the desired function from the drop-down menu. In this example, we'll select SUM.3. In the cell directly below the selected cells, the function appears.4. Press the Enter key on your keyboard. The function will be calculated, and the result will appear in the cell. In this example, the sum of D3:D12 is $765.29. Check Your Understanding: 1. The function's order is called a Syntax Formula Range Argument 2. Arguments can refer to both individual cells and cell ranges and must be enclosed within _. parentheses quotes letters numbers 3. This function below is _ B1:B9. Average SUM MAX MIN Label the Parts of the Function ~Make Sure You Type the Words Exactly As the Below~Word Bank: Equals Sign - Function Name - Argument Equals Sign Function Name Argument Match the Function with Its Name SUM This function adds all of the values of the cells in the argument. AVERAGE This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument. COUNT This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range. MAX This function determines the highest cell value included in the argument. MIN This function determines the lowest cell value included in the argument. Apply: Google Sheets - Functions 1. Go to Google Classroom Assignment2. Click the Attached Google Sheets Document3. Complete Each Step Listed in the Spreadsheet. There are 6 total.Done? Make sure you turn in the blended worksheet and the Google Classroom Assignment