Answer:
= C6/$C$20
Explanation:
Given
Cell C6 ; Cell C20 and Cell E6
Cell C6 = DVD Sales
Cell C20 = Total Sales
Cell E6 = The result cell.
Cell E6 gets it value by calculating the percentage of DVD sales.
In other words, E6 = C6/C20
From the question, cell C20 is to be referenced using absolute reference.
The absolute reference ensures that the value never changes no matter where the formula is copied. The dollar sign ($) fixes the reference to a given cell.
So, cell C20 will be referenced like this: $C$20
While cell C6 will be referenced using the default relative reference (C6)
The percentage formula will be entered in cell E6 as this
= C6/$C$20
Click the Percent Style button (Home tab > Number group) to display the resulting decimal fractions as percentages.
Increase the number of decimal places if needed
