Calc elements such as cells, columns, rows, functions, charts etc., Format – menu contains the commands of various text and cell formatting features. Tools – menu contains various tools and functions such as spell check, protect document, insert pictures, macros, etc., Data – menu contains the commands to manipulate data in a worksheet such as sort, filter, subtotal, validity etc., Window – menu shows display options such as New Window, Close Window, Split and Freeze. Help – menu lists in-built help features available with OpenOffice. .
. . Tools Bar Under the menu bar, there are three toolbars available by default. They are: ( ) Standard Toolbar ( ) Formatting Toolbar ( ) Formula bar Standard Toolbar Formatting Toolbar Formula bar Figure .
OpenOffice Calc Tool bar Standard Toolbar – contains frequently used menu such as File, Edit, Data etc., commands as icons such as New Open Save, Send, Print, Print Preview, Cut, Copy, Paste, Sorting, Inserting chart etc., Formatting Toolbar – contains frequently used text and cell formatting commands as such as changing font style, font size, font colour, alignments, cell formatting etc., Formula bar – This is a very important element in a spreadsheet. It contains Name box, Function Wizard, Sum button, Function button and Input line (Refer Figure . ). Name box : It display the current cell address Function Wizard : It is used to insert function Sum button : It is used to quickly insert sum function.
Input Line : This is used to show the contents of the current cell. It always shows actually what is typed in a cell. It can also be used to edit the contents. Name box / Address Box Input Line Sum button Function Wizard Function button Figure .
Calc Formula bar . . . Scroll bar Spreadsheet window also has two sets of scroll bars ( ) Vertical Scrollbar and ( ) Horizontal Scrollbar (Refer Figure .
) Vertical Scroll bar : It is used to move the screen up and down. Horizontal Scroll bar : It is used move the screen left and right. Scroll buttons : used to move the screen to the relative distance.