Page 266 - Trackpad IT-402_Class-IX
P. 266
The name of the application window i.e., OpenOffice.org Calc appears next to it. The control buttons, i.e., Maximize,
Minimize and Restore and close are available on the extreme right of this bar.
• Menu Bar: The bar just below the Title Bar is the Menu bar. This bar has got different menus like File, Edit, View,
Insert, Format, Tools, Data, Window and Help. Each menu is like a category that contains different related options
that are used to perform different tasks.
• For example, the options related to the file such as New, Open, Save, Print, etc. are present in the File menu.
• Toolbars: Just below the menu bar, there is a set of three default toolbars which are explained below.
w Standard Toolbar: It consists of some standard operations which are common across all the applications of
OpenOffice software. Some of these are New, Open, Cut, Copy, Paste Save, etc.
w Formatting Toolbar: It consists of the tools used to format the spreadsheet. Formatting the spreadsheet includes
the options like change of text colour, size, style, alignment, number formatting, etc.
Font Name Font Size
w Formula Bar: It is the most important bar in a spreadsheet and is used for entering and editing a formula.
Name Box Function Wazard Input Line
Sum Button Function Button
It contains different options which are given as follows:
w Name Box: It displays the name or reference of an active cell or a selected cell range.
w Function Wizard: It is used to insert functions through interactive step-by-step processes.
w Sum: It is used to insert a sum function directly for the currently selected cell range.
w Function: It adds a formula to the current cell. If you click this icon then it changes to and you are ready to
enter a formula in the input line.
w Input Line: It is used to enter a formula that needs to be applied in the current cell or selected cell range. It
also displays the contents of the selected cell (i.e., data, formula, or function) and allows editing of the cell
contents.
• Worksheet: A file in the OpenOffice Calc is known as a worksheet. The default name of the worksheet is “Untitled1”.
Initially, it has three sheets (or sheet tabs) and more can be added or subtracted later as per the need.
A worksheet is divided into rows and columns to form a grid of cells where data can be arranged in an organised
manner.
266 Trackpad Information Technology-IX

