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:
Tooth infection
Step-by-step explanation:
If the price of an object drastically dropped 75%, then the dropped price is equal to 25% of the original price. That means that to find the original price, we have to multiply by the reciprocal of 25% (4). The original price would be $85.99 * 4 which is $343.96.
Answer:
0.06
Step-by-step explanation:
Answer: b. Consolidate all credit cards onto a single card with a single interest rate.
Step-by-step explanation: Steps a, c and d are in correct order. First, we have to arrange our debts in order of paying them off. Second, we need to determine how much extra money we have each month that can be contributed to debt payment. And finally, we need to track our progress of paying debt. So, option b is not included in the steps.
Thus, the correct option is b. Consolidate all credit cards onto a single card with a single interest rate.
