« previous next »

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

casperchen82

  • Hero Member
  • *****
  • Posts: 540
on: Jun 24, 2018
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
Reply #1 on: Jun 24, 2018
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
« previous next »
 

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

Cell culture in a Petri dish Cell culture in a Petri dish
All living organisms descended from a common ancestral cell All living organisms descended from a common ancestral cell
Reconstructed Australopithecus afarensis spine shows that species walked upright. Reconstructed Australopithecus afarensis spine shows that species walked upright.
A cartoon of “King Andrew the First” shows Jackson standing atop the U.S. Constitution—a scepter in A cartoon of “King Andrew the First” shows Jackson standing atop the U.S. Constitution—a scepter in
The following information relates to the Cutting Department of Kittina Corporation for the ... The following information relates to the Cutting Department of Kittina Corporation for the ...
Video: Frequency of stimulation and force (Recruitment of motor units and force)

For a complete list of videos, visit our video library