EXCEL
Case Problem 2 – Halley Foods Data file needed Halley.xlsxMichael Li is working on the annual financial export for Halley Foods of Norman, Oklahoma. One part of the financial report will be the company’s balance sheet for the previous three years. Michael has entered some of the labels for the balance sheet but wants you to finish the job by entering the actual values and formulas.Complete the following:1. Open the Halley workbook located on your flash drive then save it as Halley Foods.2. Rename the Sheet 1 worksheet as Balance Sheet, and then delete Sheet2 and Sheet3.3. Insert three new rows at the top of the sheet, and then enter the following text on four lines within cell A1:4. The four lines will contain the following:Halley Foods, Inc.Balance SheetFor years ended December 31, 2007 through December 31, 2009Prepared by (Your Name)5. Change the width of column A to 30 Characters, the width of column B to 20 characters, and the width of Column C to 26 characters. Autofit the height of row 1.6. Enter the assets and liability values found on a separate sheet of paper given by instructor.7. Use Autosum to calculate the total current assets, other assets, current liabilities, and shareholders’ equity in ranges D11:F11, D17:F17, D25:F25, and D33:F33, respectively, for each of the previous three years.8. Insert a formula in the range D19:F19 to calculate the value of the total assets (current plus other) for each year.9. Insert a formula in the range D36:F36 to calculate the value of the total current liabilities plus the minority interest plus the total shareholders’ equity for each year.10.Use Spell Check to correct any spelling mistakes in the Balance Sheet worksheet, and then proofread the worksheet.11.Change the zoom level of the Balance Sheet worksheet to 70% in Normal view to view the entire contents of the sheet in the workbook window12.View the Balance Sheet worksheet in Page Layout view zoomed to 80%, and then scale the height and width of the worksheet to fit on one page.13.Insert a new worksheet named Documentation at the beginning of the workbook.14.In the Documentation worksheet, enter the following data:Cell Data Cell DataA1 Halley FoodsA3 Author B3 your nameA4 Date B4 the Current DateA5 Purpose B5 Balance sheet for Halley Foods For 2007 through 200915.Save, preview, and then print the entire Halley Foods Balance Sheet16.Print the formula view of the balance sheet on two pages in landscape orientation. Return the Balance sheet to Page Layout viewSave and close w