EXCEL

Case Problem 2 - Halley Foods Data file needed Halley.xlsx

Michael 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 Sheet

For years ended December 31, 2007 through December 31, 2009

Prepared 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 window

12.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 Data

A1                       Halley Foods

A3                       Author                     B3 your name

A4                       Date                        B4 the Current Date

A5                       Purpose                   B5 Balance sheet for Halley Foods

                                                            For 2007 through 2009

15.Save, preview, and then print the entire Halley Foods Balance Sheet

16.Print the formula view of the balance sheet on two pages in landscape orientation.  Return the Balance sheet to Page Layout view

Save and close w