Percentages
One type of calculation you'll find yourself doing repeatedly in Google Sheets are percentage calculations. Percentage calculations have all sorts of uses, such as predicting compound interest on savings accounts to measuring project progress.
In this exercise, you'll work with percentages to calculate the total cost of each item, which includes the price of the item and a sales tax (also called value added tax or VAT) of 21%.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- Calculate the sales tax for each item, which is 21% of the item price, in cells
F2:F5. - Calculate the total cost of each item, which is the sum of the item price and sales tax, in cell
G2:G5.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise