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