始める無料で始める

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%.

この演習はコースの一部です

Google Sheets入門

コースを見る

演習の手順

  • 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.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する