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/D9*100
d.=D9/D10*100
correct: d
Business
You might also like to view...
Which costing method will produce different results under perpetual and periodic systems?
A) Specific identification B) Average-cost C) FIFO D) Both FIFO and specific identification
Business
In the Constitution, the power over international affairs is primarily, though not exclusively,
vested in the states. Indicate whether the statement is true or false
Business
Use the following to calculate the acid-test ratio. (Round your answer to two decimal places.)
Cash $100,000 Short-term investments 17,000 Net current receivables 250,000 Inventory 330,000 Total current liabilities 760,000 A) 0.79 B) 5.88 C) 0.92 D) 0.48
Business
Title VII of the Civil Rights Act prohibits job discrimination on the basis of merit
Indicate whether the statement is true or false
Business