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
One angle is inside a right triangle
Y represent the total number of newspapers sold by Colby.
keeping in mind that a year has 12 months, thus 6 months is really 6/12 of a year.
Answer:
150 ft^3
.1 ton or 200 lbs
Step-by-step explanation:
The volume is given by
V = l*w*h
V = 5*5*6
V = 150 ft^3
To find how much 1 ft^3 weighed take the weight and divide by the volume
15 tons / 150 ft^3
.1 ton / 1 ft^3
1 ft^3 weights .1 ton
We know that 1 ton = 2000 pounds
.1 ton = 200 pounds
