Formulas

Now that you're able to navigate your way around a spreadsheet, it's time to introduce some functionality to your Google Sheets with formulas.

Formulas allow you to perform calculations in your Google Sheets, similar to the way you'd use a calculator. Writing formulas helps reduce the likelihood of errors arising from performing mental arithmetic or pen-and-paper calculations to manually input values; they also allow interested stakeholders to see how cell values were calculated.

In this exercise, you'll perform multiplication and division in a formula to fill in the missing Price, Quantity, and Total Price values, where Total Price is calculated by multiplying Price and Quantity.