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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!