Question: please do this for me GTransform Data 314 B A 1 Scenario Name 2 Price Donut 3 Units Sold 4 Gross Profit 5 Cost each


please do this for me
GTransform Data 314 B A 1 Scenario Name 2 Price Donut 3 Units Sold 4 Gross Profit 5 Cost each 6 Total Cost 7 Profit $0.00 $0.00 $0.00 8 10 11 12 13 14 Provtax Sales 380 PNT Donuts Type here to search 9. Use the Subtotals function in the "Subtotals sheet to calculate Subtotals for each Store - Then only display ONLY the Store subtotals NOT each row 2 marks 10. Use the VLOOKUP function in sheet "Vehicles" to return which vehicle the employee is driving 4 marks 11. Use the IF function in sheet "Surplus" to show the surplus over 400 units only. Then multiple that surplus number by 10 in the column 4 marks 12. Use the SUMIFS function in "Pets" to total Cats and Birds based on 2 criteria 2 marks GTransform Data 314 B A 1 Scenario Name 2 Price Donut 3 Units Sold 4 Gross Profit 5 Cost each 6 Total Cost 7 Profit $0.00 $0.00 $0.00 8 10 11 12 13 14 Provtax Sales 380 PNT Donuts Type here to search 9. Use the Subtotals function in the "Subtotals sheet to calculate Subtotals for each Store - Then only display ONLY the Store subtotals NOT each row 2 marks 10. Use the VLOOKUP function in sheet "Vehicles" to return which vehicle the employee is driving 4 marks 11. Use the IF function in sheet "Surplus" to show the surplus over 400 units only. Then multiple that surplus number by 10 in the column 4 marks 12. Use the SUMIFS function in "Pets" to total Cats and Birds based on 2 criteria 2 marks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
