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
Step-by-step explanation:
x = father's age now
y = son's age now
x = 2y + 10
x - 20 = 5(y - 20) = 5y - 100
using the first in the second equation :
2y + 10 - 20 = 5y - 100
-10 = 3y - 100
90 = 3y
y = 30
x = 2y + 10 = 2×30 + 10 = 60 + 10 = 70
the father is now 70 years old, the son now 30 years old.
Answer:
,
, and "Yes"
Step-by-step explanation:
We will do as the instructions say.
-> See attached.
Standard form is Ax + By = C
Where A is a positive integer
The y needs to be moved to the left side so subtract 3y from both sides.
2x - 3y = -8
Answer:
2.8409091 miles
Step-by-step explanation: