Microsoft Office Tutorials and References
In Depth Information
Case Problems
6. Use AutoSum to calculate the total current assets, other assets, current liabilities,
and shareholders’ equity in the ranges D11:F11, D17:F17, D25:F25, and D33:F33,
respectively, for each of the previous three years.
7. Insert a formula in the range D19:F19 to calculate the total assets (current assets plus
other assets) for each year.
8. 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.
9. Use the spelling checker to correct any spelling mistakes in the Balance Sheet
worksheet, and then proofread the worksheet.
10. 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.
11. View the Balance Sheet worksheet in Page Layout view zoomed to 80%, and then
scale the height and width of the worksheet to ﬁ t on one page.
12. Insert a new worksheet named Documentation at the beginning of the workbook.
13. In the Documentation worksheet, enter the following data:
Cell A1: Halley Foods
Cell A3: Author Cell B3: your name
Cell A4: Date Cell B4: the current date
Cell A5: Purpose Cell B5: Balance Sheet for Halley Foods for 2011 through 2013
14. Save, preview, and then print the entire Halley Foods workbook.
15. Print the formula view of the Balance Sheet worksheet on two pages in landscape
orientation. Return the Balance Sheet worksheet to Page Layout view when you’re
ﬁ nished.
16. Save and close the workbook, and then submit the ﬁ nished workbook and printouts
Case Problem 3
Explore using
AutoSum
to calculate
production
statistics.
Data File needed for this Case Problem: Global.xlsx
Global Site GPS Kevin Hodge is a production assistant at Global Site GPS, a leading
manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin’s jobs is to
monitor output at the company’s ﬁ ve regional plants. He wants to create an Excel
workbook that reports the monthly production at the ﬁ ve sites, including the monthly average,
minimum and maximum production, and total production for the previous year. You will
create the workbook that reports these statistics. Complete the following:
1. Open the Global workbook located in the Excel1\Case3 folder, and then save the
workbook as Global Site in the same folder.
2. Rename the Sheet1 worksheet as Production History , and then insert 12 new rows at
the top of the worksheet.
3. Increase the width of column A to 23 characters and the width of columns B through
F to 14 characters.
4. In the range B7:F7, enter the titles Plant1 , Plant2 , Plant3 , Plant4 , and Plant5 ,
respectively.
5. In the range A8:A11, enter Total Units Produced , Average per Month , Maximum ,
and Minimum , respectively.
6. Select the range B26:F26, use AutoSum to calculate the sum of the production
values for each of the ﬁ ve plants, and then drag and drop the selected cells to the
range B8:F8.
7. Select the range B26:F26, use AutoSum to calculate the average of the production
values for each of the ﬁ ve plants, and then drag and drop the selected cells to the
range B9:F9.
Search JabSto ::

Custom Search