Please provide a step by step solution
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 worksheets. P
manufacturing corporation, you are gathering information on supplies and In your position as an administrator for Gateway Global, an electronics equipment expenses. You have gathered information for the first quarter of the year and decide to create a workbook containing worksheets for monthly information. Sales 2018 Case Study Part . 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 the Total row that sums the amounts in the Supplies, Equipment, and Total columns. 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 Total Department Production Technical Support Finance Sales and Marketing Facilities Total Supplies $25,425 $14,500 $5,790 $35,425 $6,000 Equipment $135,500 $65,000 $22,000 $8,525 $1,200 Unit 2 Chapter 5 | Moving Data within and between Workbooks 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 After creating and formatting the worksheet, complete the following: Make the following changes to the data in Sheet2: Change January Expenditures to February Expenditures. o o O o e 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 name it 5-GGExp. Print all the worksheets in the workbook and then close the workbook. O 0 o manufacturing corporation, you are gathering information on supplies and In your position as an administrator for Gateway Global, an electronics equipment expenses. You have gathered information for the first quarter of the year and decide to create a workbook containing worksheets for monthly information. Sales 2018 Case Study Part . 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 the Total row that sums the amounts in the Supplies, Equipment, and Total columns. 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 Total Department Production Technical Support Finance Sales and Marketing Facilities Total Supplies $25,425 $14,500 $5,790 $35,425 $6,000 Equipment $135,500 $65,000 $22,000 $8,525 $1,200 Unit 2 Chapter 5 | Moving Data within and between Workbooks 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 After creating and formatting the worksheet, complete the following: Make the following changes to the data in Sheet2: Change January Expenditures to February Expenditures. o o O o e 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 name it 5-GGExp. Print all the worksheets in the workbook and then close the workbook. O 0 o
