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:
they are 16 and 4
Step-by-step explanation:
We can call the numbers x and y and we can write:
x - y = 12
x + y = 20
Adding these equations gives us 2x = 32 which means x = 16 and substituting this value into the first equation gives us y = 4.
Answer:
8/17 and 9/17
Step-by-step explanation:
8:9
both add up to 17
so it can be 8/17 or 9 but it cannot be simplified unless if you want them both as a mixed number which is
8/17 as a mixed number is 2 1/17
9/17 as a mixed number is 1 8/17
Answer:
Adult=58
Step-by-step explanation:
c=child, a=adult
6.4c+9.7a=1145 equation 1
c+a=149 equation 2
a=149-c modified equation 2 to isolate a
6.4c+9.7(149-c)=1145 substitute value of a from equation 1 into equation 2
6.4c+1445.3-9.7c=1145
-3.3c=-300.3
c=91
solve for a
c+a=149
91+a=149
a=58
Check answer:
6.4c+9.7a=1145
6.4(91)+9.7(58)=1145
582.40+562.60=1145
1145=1145
