Show formulas that are put into excel

2. Total Mischief Mischief, Inc., is a regional pet toy supplier that tracks its business sales in a spreadsheet. The owner, Lisa Derrick, has provided you with a skeleton worksheet, T2_TotalMischief_ Data.xlsx, with the totals for each quarter by sales region. Lisa needs you to total each column and row, and then provide her with a clustered column chart of each region by quarter. See Figure T2.21 for a sample of what Lisa would like you to do. Regional Sales Summary Totals Northeast South Midwest West Totals 1st Quarter $119,700.00 $48,900.00 $34,600.00 $56,200.00 2nd Quarter $125,100.00 $52,000.00 $32,200.00 $49,000.00 3rd Quarter $133,400.00 $49,600.00 $47,000.00 $52,000.00 4th Quarter $139,500.00 $54,500.00 $45,900.00 $51,300.00 Northeast South Midwest West Totals Regional Sales Summary 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Totals $119,700.00 $125,100.00 $133,400.00 $139,500.00 $ 517,700.00 $ 48,900.00 $ 52,000.00 $ 49,600.00 $ 54,500.00 $ 205,000.00 $ 34,600.00 $ 32,200.00 $ 47,000.00 $ 45,900.00 $ 159,700.00 $ 56,200.00 $ 49,000.00 $ 52,000.00 $ 51,300.00 $ 208,500.00 $259,400.00 $258,300.00 $282,000.00 $291,200.00 $ 1,090,900.00 $160,000.00 $140,000.00 $120,000.00 $100,000.00 $80,000.00 $60,000.00 $40,000.00 $20,000.00 $- North east 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter