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
The answer is 8 .. hope this helps a lot :)
Step-by-step explanation:
It is given that, a mouse covered a distance of 3/24 miles over a distance of 3 hours. Each hour, the mouse traveled the same distance. Distance traveled in 1 hour can be calculated by dividing 3/24 miles by 3. So,

Matt calculations shows that the distance is 3/8 hours. While dividing 3/24 by 3, he doesn't take reciprocal of 3 as a result he get 9 on numerator and 24 on denominator. Simplified fraction of 9/24 is 3/8. But the correct answer should be 1/24 hours.