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
First we need to find what 3% of 700 is. We know 10% is 70, 5% is 35, so we need to find out what 3% is. If you don't know how to calculate percentages of a number, I recommend starting with 10%. This way you know 10% of the number is 70, so you will also know that 1% of the number is 7. 7 x 3 = 21. So 3% of 700 is 21. Since it was over 6 years, we multiply 21 x 6. That gives us 126. She will be paid $126 in interest in the first six years.
She has 144-100=44. 44-4=40. Medium holds to beads you will need 4 medium boxes.
Answer:
x=3y+15
Step-by-step explanation:
Answer:
a) 3
b) 4
Step-by-step explanation:
The point P is(3,4)
which means that 3 is the point P's x- coordinate and 4 is it's y-coordinate
Because we use the axes as our reference point when plotting points,
the distance of P from x-axis and y-axis would be the point itself.
