« previous next »

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

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Stem Cell Research Could Expand Clinical Use of Regenerative Human Cells Stem Cell Research Could Expand Clinical Use of Regenerative Human Cells
cell parts cell parts
The bacterial cell wall: (a) gram-positive bacterium; (b) gram-negative bacterium. The bacterial cell wall: (a) gram-positive bacterium; (b) gram-negative bacterium.
Three pathways of complement combined. (a) Figure shows a summary of how each pathway proceeds. (b) ... Three pathways of complement combined. (a) Figure shows a summary of how each pathway proceeds. (b) ...
Attachment and cell entry by HIV. Attachment and cell entry by HIV.
A cervical cancer cell A cervical cancer cell
Video: Protein Secondary and Tertiary Structures - Animation

For a complete list of videos, visit our video library