« previous next »

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

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Leaf Cell Leaf Cell
Plant Cell Wall Formation Plant Cell Wall Formation
Microfilaments and Cell Movements Microfilaments and Cell Movements
The cell cycle. The cell cycle.
Nomogram chart. This example shows a line drawn from a child’s height of 100 cm to his weight, 35 ... Nomogram chart. This example shows a line drawn from a child’s height of 100 cm to his weight, 35 ...
Overview of Cell Organelles Overview of Cell Organelles
Video: Hydrogen bonds - role in the body

For a complete list of videos, visit our video library