please solve this for me and explain only using the excel i provided

zoom it please

provided everything, assesment 2 is the top excel file and the other one is the down file. please read the name of the file. you will figure it out

more information on what?

Data All Types Filter Tools at-If Analysis B11 fox B D 1 National Online Marketing Inc. 2 Computing Services Department Projected 3 Current budget Increase 4 Wages and benefits 371,875 13,016 5 Computer supplies 150,350 2,255 6 Training and development 63,850 6,385 7 Other administrative costs 49,576 2,479 8 Total costs: 635,651 9 10 New budget 384,891 152,605 70,235 52,055 659,786 SNAP Grade It assessment 2 USE GOAL SEEK 1. Open NationalBdgt.xlsx. 2. Save the workbook and name it EL2-C5-A2-NationalBdgt. 3. Make cell D8 the active cell and open the Goal Seek dialog box. 4. Find the projected increase for wages and benefits that will make the total cost of the new budget equal $655,000. 5. Accept the solution Goal Seek calculates. 1. Open PreCdn Target.xlsx 2. Save the workbook and name it EL2-C5-A3-PreCdn Target. 3. Create scenarios to save various percentage data sets for the four regions using the following information: a. A scenario named Original Target that stores the current values in K4:K7. b. A scenario named LowSales with the following values: East 0.20 West 0.32 Ontario 0.48 Quebec 0.37 c. A scenario named HighSales with the following values: East 0.36 West 0.58 Ontario 0.77 Quebec 0.63 4. Show the Low Sales scenario and then print the worksheet. 5. Create a scenario summary report displaying cell H18 as the result cell. AutoSave OFF PreCdnTarget Insert Home Formulas Draw Tell me Page Layout View Review Data 10 ' Calibri (Body) Custom 29 Wrap Text X a $ % ) Paste BIU a. Av Merge & Center A4 x H F . 1 K D fx 1140 B Precision Design and Packaging Proposed Sales Target for Canadian Distributor (in millions Description Ontario Quebec 2 WEM Total 3 2.05 Sales Target Assumptions East 0.30 West Ontario 0.65 Quebec 0.50 1.75 4 5 2.00 1.70 1.20 1.57 1.55 125 0.75 1.12 1.25 1.62 1.55 1.05 1.42 6 7 8 Model Number PD-1140 PD-2185 PD-1150 PD-1155 PD-3695 PD-3698 PD-3699 PD-4100 PD-4200 PO-4415 PD-5367 PD-6418 PD-7459 PO-8854 2.20 1.90 1.40 1.77 2.20 2.32 2.79 2.90 2.76 2.19 9 Gaylord with lid Premium Gaylord with lid Gaylord bottom Gaylord id Telescoping top and bottom Telescoping bottom Telescoping top Additional lids for telescoping containers "D" 4-piece container E0% container "EH"container "E"container Economy R.S.c Premium R.S.C Total 2.00 2.12 2.59 2.70 2.56 1.55 1.67 2.14 2.25 2.11 1.54 0.8 0.78 1.11 0.95 10 11 12 13 14 15 16 17 18 19 20 2.05 2.17 2.64 2.75 2.61 2.04 13 1.28 1.61 1.45 26.65 8.10 6.90 4.90 6.38 8.10 8.50 10.46 10.90 10.34 8.06 5.42 5.02 6.34 5.70 105.20 1.85 1.97 2.44 2.55 2.41 1.84 1.18 1.08 1.41 1.25 1.53 143 1.76 1.60 28.75 1.99 133 1.23 1.56 1.40 25.95 23.85 22 23 24 Data All Types Filter Tools at-If Analysis B11 fox B D 1 National Online Marketing Inc. 2 Computing Services Department Projected 3 Current budget Increase 4 Wages and benefits 371,875 13,016 5 Computer supplies 150,350 2,255 6 Training and development 63,850 6,385 7 Other administrative costs 49,576 2,479 8 Total costs: 635,651 9 10 New budget 384,891 152,605 70,235 52,055 659,786 SNAP Grade It assessment 2 USE GOAL SEEK 1. Open NationalBdgt.xlsx. 2. Save the workbook and name it EL2-C5-A2-NationalBdgt. 3. Make cell D8 the active cell and open the Goal Seek dialog box. 4. Find the projected increase for wages and benefits that will make the total cost of the new budget equal $655,000. 5. Accept the solution Goal Seek calculates. 1. Open PreCdn Target.xlsx 2. Save the workbook and name it EL2-C5-A3-PreCdn Target. 3. Create scenarios to save various percentage data sets for the four regions using the following information: a. A scenario named Original Target that stores the current values in K4:K7. b. A scenario named LowSales with the following values: East 0.20 West 0.32 Ontario 0.48 Quebec 0.37 c. A scenario named HighSales with the following values: East 0.36 West 0.58 Ontario 0.77 Quebec 0.63 4. Show the Low Sales scenario and then print the worksheet. 5. Create a scenario summary report displaying cell H18 as the result cell. AutoSave OFF PreCdnTarget Insert Home Formulas Draw Tell me Page Layout View Review Data 10 ' Calibri (Body) Custom 29 Wrap Text X a $ % ) Paste BIU a. Av Merge & Center A4 x H F . 1 K D fx 1140 B Precision Design and Packaging Proposed Sales Target for Canadian Distributor (in millions Description Ontario Quebec 2 WEM Total 3 2.05 Sales Target Assumptions East 0.30 West Ontario 0.65 Quebec 0.50 1.75 4 5 2.00 1.70 1.20 1.57 1.55 125 0.75 1.12 1.25 1.62 1.55 1.05 1.42 6 7 8 Model Number PD-1140 PD-2185 PD-1150 PD-1155 PD-3695 PD-3698 PD-3699 PD-4100 PD-4200 PO-4415 PD-5367 PD-6418 PD-7459 PO-8854 2.20 1.90 1.40 1.77 2.20 2.32 2.79 2.90 2.76 2.19 9 Gaylord with lid Premium Gaylord with lid Gaylord bottom Gaylord id Telescoping top and bottom Telescoping bottom Telescoping top Additional lids for telescoping containers "D" 4-piece container E0% container "EH"container "E"container Economy R.S.c Premium R.S.C Total 2.00 2.12 2.59 2.70 2.56 1.55 1.67 2.14 2.25 2.11 1.54 0.8 0.78 1.11 0.95 10 11 12 13 14 15 16 17 18 19 20 2.05 2.17 2.64 2.75 2.61 2.04 13 1.28 1.61 1.45 26.65 8.10 6.90 4.90 6.38 8.10 8.50 10.46 10.90 10.34 8.06 5.42 5.02 6.34 5.70 105.20 1.85 1.97 2.44 2.55 2.41 1.84 1.18 1.08 1.41 1.25 1.53 143 1.76 1.60 28.75 1.99 133 1.23 1.56 1.40 25.95 23.85 22 23 24