Now, we can just multiply it and obtain the result
I used law presented on this example
A. £549 376 / 4 = £137344 per word
B. £549 376 / 16 = £34336 per letter
C. £549 376 / 37 = £14848 per letter
D. £549 376 / 512 = £ 1073
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
I believe the answer you are looking for is 2 angles
If it is a fraction like (3a-3b)/(3a+12b)
= [3(a-b)]/[3(a+4b)]
= (a-b)/(a+4b)
