How to Use Percentages in Microsoft Excel

This tutorial covers calculating percentages in Microsoft Excel, addressing common issues and explaining how Excel uses decimals for percentage calculations. It provides step-by-step instructions for basic percentage formulas, formatting percentages, and calculating percentage changes. Practical examples and tips are included to enhance understanding.

What is the basic formula for calculating a percentage?

• Whole divided by part, then multiply by 100

• Part multiplied by whole, then divide by 100

• Whole multiplied by part, then divide by 100

• Part divided by whole, then multiply by 100

Why might Excel show a percentage as 5000%?

• Excel multiplies by 100 twice

• Excel interprets percentages as decimals

• Excel adds extra zeros by default

• Excel formats all numbers as percentages

How does Excel interpret 1%?

• As 10.0

• As 0.1

• As 1.0

• As 0.01

What is the correct formula for calculating percentage increase?

• New value minus old value, divided by old value

• Old value minus new value, divided by old value

• New value minus old value, divided by new value

• Old value minus new value, divided by new value

What happens when you apply the percentage format in Excel?

• It divides the number by 100

• It adds a percentage sign only

• It multiplies the number by 10

• It multiplies the number by 100 and adds a percentage sign

How can you calculate 20% tax on a price in Excel?

• Subtract 20 from the price

• Divide the price by 0.2

• Add 20 to the price

• Multiply the price by 0.2

What should you remember when using Excel's percentage format?

• It divides by 100 and adds a percentage sign

• It only multiplies by 100

• It multiplies by 100 and adds a percentage sign

• It only adds a percentage sign

How do you express a fraction as a percentage in Excel?

• Multiply the fraction by 100

• Divide the fraction by 100

• Add 100 to the fraction

• Subtract 100 from the fraction

What is the benefit of using Excel's percentage formatting?

• It simplifies the formula writing process

• It makes numbers larger

• It changes the color of the cell

• It automatically corrects errors

What is a common mistake when calculating percentages in Excel?

• Forgetting to divide by the whole

• Multiplying by 100 manually

• Using the wrong cell reference

• Adding numbers incorrectly