Points to Remember: OpenOffice Calc - Data Tools and Printing

Points to Remember:

• Data Tools are used to manipulate the information in the spread-sheet

• Conditional format gives different font size, font colour and background colour for different data based on the user requirements.

• Sorting is used to re-arrange the items in ascending or descending order based on alphabets or based on values.

• Filters are used to show only the selected portion of data from a large size database

• Input Help is used to provide various options like week, month etc

• Header and Footer are some titles (such as Document Title, Author Name) or references (such as page no, number of pages, date) or remarks to be printed in the top (called as Header) and bottom of the page (called as Footer).

• If a sheet is printed on multiple pages, we can set up certain rows or columns to repeat on each printed page.