Commonwealth Computer Navigator's Certificate

From WikiEducator
Jump to: navigation, search

Tutorial.png 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.

Icon objectives.jpg


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: