1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Leviafan [203]
3 years ago
15

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.
Computers and Technology
1 answer:
NISA [10]3 years ago
5 0

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

You might be interested in
How can i become an ailen?
DIA [1.3K]
Go to a different state as a migrant and then your a alien
8 0
3 years ago
Read 2 more answers
Why are high-quality transformers wound with large diameter wire?
lesya692 [45]
So that they can lower the I2R losses
8 0
3 years ago
1. A green traffic sign means
NeX [460]

Answer:

general regulatory and speed control.

7 0
3 years ago
4.3 mini programs AP computer science
allochka39001 [22]

1.

name = input("Enter your name: ")

num1 = int(input("Hello "+name+ ", enter an integer: "))

num2 = int(input(name+", enter another integer: "))

try:

   if num1 % num2 == 0:

       print("The first number is divisible by the second number")

   else:

       print("The first number is not divisible by the second number")

except ZeroDivisionError:

   print("The first number is not divisible by the second number")

try:

   if num2 % num1 == 0:

       print("The second number is divisible by the first number")

   else:

       print("The second number is not divisible by the first number")

except ZeroDivisionError:

   print("The second number is not divisible by the first number")

2.

import random, math

num1 = float(input("Enter a small decimal number: "))

num2 = float(input("Enter a large decimal number: "))

r = round(random.uniform(num1, num2), 2)

print("The volume of a sphere with radius " + str(r) + " is " + str(round(((4 / 3) * math.pi * (r ** 3)), 2)))

I hope this helps!

8 0
3 years ago
What is a popular use for SLR film cameras? (choose one)
Artemon [7]
Answer is c i believe
3 0
3 years ago
Other questions:
  • What is the best overall approach to education and career development for IT professionals?
    14·1 answer
  • Differences between Quality of Services and a Service of Quality approach
    9·1 answer
  • Which of the following lists contains the five essential elements of a computer? Group of answer choices: 1. inputs, returns, pr
    11·1 answer
  • I want pizzzzzzzaaaaaaaaaaa
    9·1 answer
  • Write a program that reads an integer, a list of words, and a character. The integer signifies how many words are in the list. T
    9·1 answer
  • Unwanted email sent to large groups of people who did not request the communication is called _____
    12·1 answer
  • Match each proofreading mark to the expected result.
    10·1 answer
  • Help me decide this hurry
    12·1 answer
  • What does Al stand for?
    10·1 answer
  • which of the following indicates that the loop should stop when the value in the quantity variable is less than the number 50​
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!