Author Question: The following shows the Department, the cell where the quarterly sales are stored in Excel, and the ... (Read 133 times)

casperchen82

  • Hero Member
  • *****
  • Posts: 540
The following shows the Department, the cell where the quarterly sales are stored in Excel, and the amount of quarterly sales. Which is the formula that can be used to find the percent of total sales for Housewares?
 
  Bath
 

  D7: 7,320
 

  Children's
  D8: 11,450
  Housewares
  D9: 15,934
  Total Sales
  D10: 34,704
 
 

  a.=(D7+D8+D9)/3
  b.=D9/(D7+D8)
  c.=D10/D9100
  d.=D9/D10100

Question 2

Find the distribution of the total for each of the following departments:
 
  Dept 501
  8,302
  Dept 412
  13,425
  Dept 387
  28,926
  Dept 923-A
  14,692
 
 

  a.11.7; 19.8; 41.3; 19.8
  b.12.7; 20.5; 44.3; 22.5
  c.10.5; 18.6; 42.5; 21.7
  d.12.2; 19.5; 43.4; 20.6



juliaf

  • Sr. Member
  • ****
  • Posts: 344
Answer to Question 1

correct: d

Answer to Question 2

correct: b



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

For a complete list of videos, visit our video library