Challenge 4

Challenge 4

*Creating simple formulas

A convenient and time-saving feature of Google Sheets is its ability to add, subtract, multiply, and divide numerical information for you. Google Sheets uses mathematical expressions called formulas that make handling these calculations easy. In this lesson, we'll focus on formulas that contain one mathematical operator.

Most of the time, you will be using a cell's address in the formula. This is called using a cell reference. The advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate. Using cell references in your formulas will make sure the values in your formulas are accurate.

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select the Challenge sheet.
3. In cell D4, create a formula that multiplies cells B4 and C4. Be sure to use cell references.
4. Use the fill handle to copy the formula to cells D5 and D6.
5. In cell D7, create a formula that adds cells D4, D5, and D6.
6. Change the quantity in cell B4 to 15. You should also see cells D4 and D7 change.
7. When you're finished, your spreadsheet should look something like this:

*Challenge yourself, but if you need assistance on how to do certain tasks then click this link, it will take you to the tutorial