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:
d
Step-by-step explanation:
he is benifeting from both
Answer:A -3,6
Step-by-step explanation: Substitue the answers in and they work out
Answer:
106
Explanation:
3a+b2
Substitute the values for the variables:
3(14) + 2(32)
Solve:
3(14) + 2(32)
42 + 64
106
Answer:
(1, 4.5 )
Step-by-step explanation:
The required point is at the midpoint of AB
Use the midpoint formula
Given A(4, 3) and B(- 2, 6 ), then
midpoint = [ 0.5(4 - 2), 0.5(3 + 6) ] = (1, 4.5 )
