menu. View - menu contains the commends which are used to modify the environment of calc. Insert – menu contains commands for inserting various 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 spreadsheet such as sort, filter, subtotal, validity etc., Window – menu shows display options such as New Window, Close Windows, 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: Chapter ( ) Standard Toolbar ( ) Formatting Toolbar ( ) Formula bar Standard Toolbar Formatting Toolbar Formula bar Fig. . OpenOffice Calc Toolsbar Standard Toolbar – contains frequently used File, Edit and Data menu 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 you typed in a cell. It is also used to edit the contents. Name box / Address Box Input Line Sum button Function Wizard Function button Fig. .
Calc Formula bar . . . Scroll bar Spreadsheet window also has two sets of scrolling bars ( ) Vertical Scrollbar and ( ) Horizontal Scrollbar (Refer Figure .
) Vertical Scroll bar : It is used to move the screen up and down.