« previous next »

Author Question: The following shows the Department, the cell where the quarterly sales are stored in Excel, and the ... (Read 137 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?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

The effects of germ-line versus somatic cell mutations. The effects of germ-line versus somatic cell mutations.
A molecular model showing chromosome territories in the cell nucleus of humans A molecular model showing chromosome territories in the cell nucleus of humans
Examples of cell types derived from ectoderm, mesoderm, and endoderm. Examples of cell types derived from ectoderm, mesoderm, and endoderm.
Bacterial colonies, each derived from a single cell Bacterial colonies, each derived from a single c Bacterial colonies, each derived from a single cell Bacterial colonies, each derived from a single c
Model of malaria protozoa in a red blood cell. New parasites are produced and mature in the RBC, ... Model of malaria protozoa in a red blood cell. New parasites are produced and mature in the RBC, ...
The Largest Cell The Largest Cell
Video: Random alignment at Metaphase I Animation

For a complete list of videos, visit our video library