Advanced formulas and functions
1. Advanced formulas and functions
Welcome to Module Two, Advanced Formulas and Functions. Formulas and functions allow you to make quick calculations and better use your data. Google Sheets supports many of the formulas found in other spreadsheet applications. In this module, we're going to look at creating a formula, using functions, and referencing and validating data. We will also see how using named ranges can assist you when working with data sets. You can perform many different types of calculations by using functions to create formulas in Google Sheets. There are hundreds of functions in Sheets that can be used to create formulas to execute all sorts of calculations and manipulation of data. To see an up-to-date list of the supported functions, select the function list option from the Google Sheets Help menu. In the Sheets basics course, we covered cell addresses. Google Sheets uses the A1 notation for addresses, which is the column letter followed by the row number. A cell in column E row 56 has an address of E56. When referencing the cell in a formula, the address E56 will return the contents of the cell. There are two different types of cell references when copying the contents of a cell or including it in a formula. Relative references change when a formula is copied from one cell to another in the spreadsheet. An absolute reference will remain the same when they are copied. The default behavior in Google Sheets is to use relative referencing for formulas. For example, if a formula in cell A3 is =A1+B1, copying it to cell B3 will automatically update the formula to =B1+C1, relative to its current location. Absolute references, on the other hand, do not change when copied to a new cell. The references in the formula will remain constant. When creating formulas, simply place a dollar symbol in front of the cell address to make an absolute reference to it. Google Sheets supports logical functions based on conditions. Using the function "IF", a formula can be created using "and" or "and not" to test the value in Excel and define a result that appears in a cell displaying that result. If formulas are made up of a logical expression, which is a condition that the function is checking in reference to a value or calculation, and a value to return if the expression is true or false. Let's look at an example to show you how this works.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.