Calculating Percentages in Excel

This video tutorial explains how to calculate percentages in Excel. It covers setting up columns for monthly sales data, calculating total and average sales, and determining monthly revenue percentages and percent changes. The tutorial provides step-by-step instructions for using Excel formulas to perform these calculations, including formatting results as percentages.

What is the first step in setting up a spreadsheet to calculate percentages in Excel?

• Format the cells as percentages

• Calculate the total revenue

• Expand the width of the first four columns

• Enter the sales data for each month

Tags

CCSS.6.SP.B.5C

Which Excel function is used to calculate the total sales for the first six months?

• AVERAGE

• SUM

• COUNT

• PRODUCT

Tags

CCSS.6.SP.B.5C

How can you calculate the average sales for the first six months in Excel?

• Use the SUM function and divide by 6

• Use the AVERAGE function

• Use the COUNT function

• Use the PRODUCT function

To find the percentage of January's revenue relative to the total, which formula should be used?

• B8 / B2

• B2 / B8

• B2 * B8

• B8 - B2

What is the next step after calculating the percentage of each month's revenue as a decimal?

• Highlight the column and format as currency

• Highlight the column and format as percentage

• Highlight the column and format as date

• Highlight the column and format as text

How do you format a decimal value as a percentage in Excel?

• Right-click and select 'Format Cells', then choose 'Percentage'

• Right-click and select 'Format Cells', then choose 'Date'

• Right-click and select 'Format Cells', then choose 'Text'

• Right-click and select 'Format Cells', then choose 'Currency'

Tags

CCSS.6.RP.A.3C

What is the formula to calculate the percentage change from January to February?

• (B2 - B3) / B3

• (B3 + B2) / B2

• (B3 - B2) / B2

• (B3 * B2) / B2

Tags

CCSS.6.RP.A.3C

If the sales decrease from February to March, what should the percentage change be?

• Undefined

• Negative

• Positive

• Zero

Tags

CCSS.6.RP.A.3C

How can you apply the percentage change formula to the next five months in Excel?

• Manually enter the formula for each month

• Use the fill handle to drag the formula across cells

• Copy and paste the formula into each cell

• Re-enter the formula for each month

Tags

CCSS.6.RP.A.3C

What is the final step after calculating monthly percentage changes?

• Format the cells as percentage

• Format the cells as currency

• Format the cells as date

• Format the cells as text

Tags

CCSS.6.RP.A.3C