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
Part A:
To get the interest of 1 year
Multiply 20,000 by 5% or 0.05
You get $1,000
Thats the amount for 1 year, now to get for 4 years, multiply 1,000, by 4
She pays $4,000 in interest
Part B:
If she pays it off in 2 years, instead of 4 years, she will pay an interest of $2,000, divide 4 by 2
Part C:
This is the same as part b, she saves $2,000
Hope this helps
-GoldenWolfX
I personally use y2-y1 over x2-x1 because it's simple. Plot two y values and two x values. The first ones you plotted are x1 and y1, the others are x2 y2. Now subtract y2-y1 and x2-x1. Afterwards, divide the y value by the x value, that will give you slope.
Answer:
5x+10
Step-by-step explanation:
Distribute:
=(5)(x)+(5)(3)+−5
=5x+15+−5
Combine Like Terms:
=5x+15+−5
=(5x)+(15+−5)
=5x+10
Answer: If x =7, then x + 2 = 9 and x + 4 = 11. These are your three consecutive odd integers.
Step-by-step explanation: