Commonwealth Computer Navigator's Certificate

Module 4 : Spreadhseets using OpenOffice 3.0 Back to Module 3 : Word Processing using OpenOffice 3.0 Writer

Getting to know the application | Working with and in cells | Managing Worksheets | Working with Formulas and Functions | Formatting cells | Creating charts and graphs | Preparing the spreadsheet for distribution Go to Module 5 : Database Management using OpenOffice 2.0 Base

Section 4.7: Preparing the spreadsheet for distribution Section Overview All calculations have been done, cells and cell contents have been formatted, charts and graphs have been created and, as appropriate, moved, duplicated, resized or deleted. You have also taken steps to enhance the appearance of cells and cell contents, as well as charts and graphs. You are now ready to share your work with others, so you need to pay attention to the appearance of the spreadsheet as a whole. In this final section we look at ways to improve the appearance of the individual worksheet, since the spreadsheet consists of a series of worksheets. However before doing so, you must do a final check to ensure the accuracy of your data. Outcomes Upon completion of this tutorial, the learner will Outline what needs to be done to ensure the accuracy of data Make final adjustments to a worksheet, such as changing margins and orientation and adjusting page setup. Add and/or edit headers and footers, and insert fields. Carry out all tasks to prepare the spreadsheet for printing Apply all procedures for printing a spreadsheet. The following subsections are covered in this tutorial: Are all data accurate? Setting up the worksheet Making other adjustments to the worksheet Preparing to print Printing