Ask Question
29 December, 19:48

In cell E6, create a formula to calculate the percentage of total sales accounted for by DVDs. The formula will divide DVD sales in C6 by total sales in C20. Use an absolute reference to the total sales in cell C20, and a relative reference to DVD sales in cell C6.

+2
Answers (1)
  1. 29 December, 19:53
    0
    = 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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “In cell E6, create a formula to calculate the percentage of total sales accounted for by DVDs. The formula will divide DVD sales in C6 by ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers