Page 271 - open office
P. 271
6. Write short notes on the following:
i. Formulae Bar ii. Sheet Tabs
iii. Operands iv. Cell
Ans. i. Formulae Bar: One of the most important features of the spreadsheet package is doing calculations. For
calculation, formulae are used. The formula applied in a particular cell can be viewed in the formula bar when
a specific cell is selected.
ii. Sheet Tabs: It lies below the active sheet of the screen. The names of the worksheets appear in the sheet
tabs at the bottom of the workbook. Click on the specific sheet tab to open it.
iii. Operands: Numeric data are the operands on which the formula is applied to perform arithmetical calculation.
Operands refer to data on which the formula is applied.
iv. Cell: A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit
of a worksheet where data (numbers, text, formulas, etc.) is entered.
. What are the different types of data that can be entered in the cells
Ans. Numeric Data: umeric data consists of digits ( – ), e (Exponential), decimal (.) and numeric operators like , -, /,
, , . umeric data or values are aligned towards the right side of a cell. umeric data are the operands on which
the formula is applied to perform arithmetical calculations. Operands refer to data on which the formula is applied.
Alphanumeric or Text Data: Alphanumeric data are the data that are textual in nature. It refers to the data that
is a combination of alphabets, spaces, digits and/or other characters. Alphanumeric data are mentioned within
double quotes “ ”. In Calc, alphanumeric data are aligned (by default) towards the left side of the cell and are
generally not meant for calculation.
Date and Time: ‘Calc’ displays date as sequential numbers known as Serial Values. The time is displayed as a
fractional part. Date and Time are values and therefore can be added or subtracted and can be included for
other calculations. They are aligned (by default) towards the right side of the cell.
Formula: A formula is an expression that helps to perform arithmetical calculation and also executes non-
arithmetical tasks. It consists of the operands and operators which operate upon the data. Formula has to be
expressed with prefix before the operator/data.
. What is a Spreadsheet Package What are its features
Ans. A spreadsheet package enables to accomplish such tasks quickly and efficiently. A spreadsheet package is an
application software that does analysis, calculations, comparisons and displays information in the required format
and in charts and graphs. By using a spreadsheet application, a user can arrange and store data in a systematic
manner and can also make use of logical functions to compute and analyze the data in different ways.
Spreadsheet packages are commonly used for keeping data, displaying organized data, generating results,
planning budgets, making annual reports of business organisations, generating salary statements, doing tax
calculations, etc.
Features of a Spreadsheet Package:
With the help of a spreadsheet package:
Bulk volume of data can be kept and handled in an easier way.
Complex and long calculations can be solved accurately.
Data can be exported to or imported from other packages.
Data can be expressed in tabular or pictorial forms, i.e. in the form of charts and graphs.
The formulae for calculation can be automatically applied to any data even when the data value changes.
. What is a formatting toolbar
Ans. It lies below the standard toolbar. It contains shortcut buttons that provide quick access to frequently used
formatting options that help to change the appearance of the text or data inside the sheet.
Working with Spreadsheet 2 1

