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.
