Answer:
Total sales revenue use excel function : ( SUMIF. =sumif(range, criteria, [sum_range] )
For each of the stores: Use excel function: For Store 1: =sumif(B4:B99,1,I4:I99) then repeat same for Store 2 to store 8
Step-by-step explanation:
To modify the spreadsheet to calculate the total sales revenue we will add a column " sales revenue "
multiply values of column : ( unit sold * unit price ) to get Total sales revenue. then use excel function : ( SUMIF. =sumif(range, criteria, [sum_range] ) to find Total sales revenue
calculate the total revenue for each of the 8 stores using a pivot table using "store identification number" in row and " sales revenue " in values field
To get the sales revenue ; replace " store identification value" with sales region " column
Answer:
1/2
Step-by-step explanation:
Since it is given that the cone and the hemisphere have the same height, and since the height of a hemisphere would be equal to its radius, the cones height must also be equal to its base radius.
With this information we can use the respective volume formulas.
Hemisphere:
πr^3
Cone:
πhr^2
Since h (height) = r we can say the cone volume equals:
πr^3
Now to find the ratio we divide the cone volume equation by the hemisphere volume equation
pi and r^3 cancels out from the division and we are left with
ratio = (1/3)/(2/3)
ratio = 1/2
Answer:
=
Step-by-step explanation:
Answer:
height of vertical post = 6ft
its shadow = 20 in
For all shadows cast at the same time, the ratio of the height of a shadow-casting structure to the length of its shadow is the same. (Assuming, of course, that it's the sun casting the shadows.)
So the ratio is
4 feet / 12 inches = 4 feet / 1 foot = 4/1 = 4,
and if h is the height of the cell tower,
h/122 feet = 4
h = 4 x 122 feet = 488 feet. <---------------- Final answer
Hope I helped,
-Adrian Velez
Step-by-step explanation: