« previous next »

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

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Cell signalling via integrins in anchoring junctions Cell signalling via integrins in anchoring junctions
Giant cell tumor of tendon sheath. Giant cell tumor of tendon sheath.
Stem cell research may cure diabetes, but lacks funding Stem cell research may cure diabetes, but lacks funding
sperm cell sperm cell
Blank cell diagram Blank cell diagram
This table shows the growth of a crowd at a rally over a 3 h period. This table shows the growth of a crowd at a rally over a 3 h period.
Video: Stroke volume

For a complete list of videos, visit our video library