OpenOffice Calc

Calc is the spreadsheet application you’ve always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.

Level-1.      Overview of OpenOffice.org Calc

1.   Describe the features of OpenOffice Calc

2.   The OpenOffice Calc Screen


level-2.      Entering Information in a Worksheet

1.   Entering numeric values

2.   Entering text values

3.   Entering dates and times

4.   Entering notes

5.   Entering formulas

6.   Saving the workbook


 level-3.     Editing the Worksheet

1.   Selecting cells and ranges

2.   Clearing and deleting cells

3.   Undoing commands

4.   Using Cut, Copy and Paste

5.   Adding rows and columns to the worksheet

6.     Entering a series of labels, numbers and dates


level-4.      Formatting a Worksheet

1.   Formatting cells

2.   Applying an Autoformat to a table

3.   Changing column widths and row heights

4.   Inserting page breaks


level-5.      Organising Information with Workbooks

1.   Linking Information between worksheets

2.   Using more than one Workbook


level-6.      Customising OpenOffice Calc to work the way you do

1.   Using the Zoom command

2.   Setting AutoCorrect options

3.   Setting Printing Options

4.   Controlling Page Orientation

5.   Adjusting the Margins

6.   Adding gridlines and other options


level-7.      Creating worksheet charts

1.   Planning a Chart

2.   Creating a Chart

3.   Formatting a Chart