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:
(0, -1)
Step-by-step explanation:
There are multiple ways of solving this however- since both equations are already in Y-Intercept form, we will use the "Equal Values Method"
First, since both equations are equal to Y, we can set them equal to each other and solve for X

To start, you must eliminate the fraction using a "fraction buster" multiply EVERYTHING by 4 then simplify.

Since we still have a fraction, we shall do it one more time. This time we multiply by 3

Now, solve how you normally would.
9x = 6x
-6x
3x = 0
X = 0
Now, since we know what X would equal in the solution, we are able to plug in X as 0 in one of our equations. We can choose the first one!

Now solve which would lead to y = -1
You have your solution as
(X,Y)
(0,-1)
Hope this helps!
The nearest million is 46 million since if the number to the right of "nearest so and so" is less than 5, you round down but if it is 5 or more then you round up.
Hope this helps!
Answer:
Take a look at my notes. I hope this helps.