Please provide a step by step solution

please note I'm not asking about formatting but would like the formula that goes with the assignment and also a worksheet that summarizes the supplies and equipment amounts for January, Feb and march.

Chapter 5 Case Study Part 1 41-42 Workbook The Summary worksheet should be in the same format as the Quarterly worksheets, showing 4 columns, with the data in the Quarterly summary linked to the monthly expenses. At the end of Part 1 of the case study, you should have 4 worksheet

Sales 2018 Case Study Part In your position as an administrator for Gateway Global, an electronics 1 manufacturing corporation, you are gathering information on supplies and equipment expenses. You have gathered information for the first quarter of the year and decide to create a workbook containing worksheets for monthly information. To do this, create a worksheet that contains the following information: . Company name is Gateway Global. . Create the title January Expenditures. . Create the columns shown in Figure WB-5.4. . Insert a formula in the Total column that sums the supplies and equipment amounts in each row in the Department column and insert a formula in columns. the Total row that sums the amounts in the Supplies, Equipment, and Total . Apply formatting such as fill color, borders, font color, and shading to enhance the appearance of the worksheet. Figure WB-5.4 Case Study Part 1 Department Supplies Equipment Total Production $25,425 $135,500 Technical Support $14,500 $65,000 Finance $5,790 $22,000 Sales and Marketing $35,425 $8,525 Facilities $6,000 $1,200 Total Unit 2 Chapter 5 | Moving Data within and between WorkbooksAfter creating and formatting the worksheet, complete the following: . Insert a new worksheet and then copy the data in Sheetl to Sheet2. . Insert a new worksheet and then copy the data in Sheetl to Sheet3 . Make the following changes to the data in Sheet2: . Change January Expenditures to February Expenditures. . Change the Production Department supplies amount to $38,550 and the equipment amount to $88,500. . Change the Technical Support Department equipment amount to $44, 250. . Change the Finance Department supplies amount to $7,500. . Make the following changes to the data in Sheet3: . Change January Expenditures to March Expenditures. . Change the Production Department supplies amount to $65,000 and the equipment amount to $150,000. . Change the Technical Support Department supplies amount to $21,750 and the equipment amount to $43,525. . Change the Facilities Department equipment amount to $18,450. Create a new worksheet that summarizes the supplies and equipment amounts for January, February, and March. Apply the same formatting to the worksheet as you applied to the other three worksheets. Change the tab name for Sheetl to Jan Exps, the tab name for Sheet2 to Feb Exps, the tab name for Sheet3 to Mar Exps, and the tab name for Sheet4 to Qtr Summary. Change the color of each tab. (You determine the colors.) Insert a header that prints your name at the left side of each worksheet and the current date at the right side of each worksheet. Save the workbook and workbook. name it 5-GGExp. Print all the worksheets in the workbook and then close the