Understanding Percentage Calculations in Excel

This video tutorial covers how to calculate percentages in Excel, focusing on percentage change, increase, and decrease. It explains the formulas needed for these calculations and provides tips on inputting percentages correctly in Excel. The tutorial is aimed at financial analysts and others who need to create accurate reports using Excel.

Why is it important for financial analysts to understand percentage change calculations?

• It is used for formatting Excel sheets.

• It is necessary for creating charts.

• It helps in creating accurate financial reports.

• It is required for data entry tasks.

What is the formula for calculating percentage change?

• Budget plus actual divided by actual

• Actual plus budget divided by budget

• Budget minus actual divided by actual

• Actual minus budget divided by budget

How can you rewrite the formula for percentage change?

• Budget divided by actual plus one

• Budget plus actual divided by two

• Actual plus budget minus one

• Actual divided by budget minus one

What is the first step in calculating percentage increase or decrease?

• Subtract the percentage from the price

• Divide the price by the percentage

• Identify the starting point in column A

• Multiply the price by the percentage

How do you calculate the new price after a percentage increase?

• Price times one plus the percentage

• Price minus the percentage

• Price plus the percentage

• Price divided by one plus the percentage

What happens if you input a percentage as a negative in Excel?

• The percentage is converted to positive

• The cell displays an error

• The percentage is ignored

• The formula for increase can be used for decrease

How can you input percentages directly in Excel?

• Type the number and then format as text

• Type the number and then format as currency

• Type the number and then format as date

• Type the number followed by the percentage sign

What is the result of inputting 0.05 in a cell formatted as a percentage?

• 5%

• 0.05%

• 0.5%

• 50%

What should you do before inputting a number if you want it to be a percentage?

• Format the cell as a percentage

• Format the cell as text

• Format the cell as a date

• Format the cell as currency

What happens if you format a cell as a percentage after entering a number?

• The number is formatted as text

• The number is converted incorrectly

• The number is formatted as currency

• The number remains unchanged