Page 228 - IT_Play_V1.0 Class9
P. 228
ENTERING DATA IN SHEET
To begin entering the data, click on the cell. While typing, the data can also be seen in the Formula bar.
After typing the data, press the Enter key or move the cursor to the other cell or click on the other cell using
mouse. Consider an example to work on a spreadsheet:
Open a new spreadsheet. Type the name of a school, say ‘ABC Public School’ in A1 cell and then press the
down arrow key to make the cell A2 as the active cell.
Now, in cell A2, type 'Performance Report'. Move to row
number 3. Type the headings of the data in separate
columns by pressing the right arrow key/mouse click:
Enroll. No. in column A, Name in column B, Class in
column C, Section in column D and Father’s Name in
column E.
Now, we can feed data under the given headings in
separate cells starting from the 4th row viz., below the
separate column headings.
To enter the formula in the cell, you need to first select the cell and
then enter a formula. For example, to add the two values 5 and 3, you
need to type =5+ 3 in the cell.
Notes
The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
appear after the ‘fx’ button, i.e., Cross Mark and Tick Mark. Tick Mark button is the check
mark button and it works as OK button. Cross Mark button is the cancel button and it cancels
whatever is typed. ‘AutoSum’ button is used to calculate the sum of specified range of cells.
FORMULA
A formula is a mathematical expression that performs calculations using values, cell references, and operators.
One of the most important features of a spreadsheet package is the ability to perform calculations, for which
formulas are used. Formulas are entered to carry out mathematical operations such as addition, subtraction,
multiplication, and division. Entering a formula in a cell is a logical entry that shows the relationship between
different cells. In LibreOffice Calc or Excel, a formula always starts with an equal (=) sign. The formula applied
in a particular cell can be viewed in the formula bar when the specific cell is selected.
Formulas in Calc include the following:
Formula with Cell Address
Each cell in the sheet has a unique address that is formed by the intersection of its column and row, such
as ‘A10’. Here, ‘A’ is the column name and ‘10’ is the row number. Formulas are applied to cells on the basis
of the cell address that displays the output as a result of calculation done between data of different cell
addresses. Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a
formula is entered to calculate the sum of these numbers with their cell address; thus it will be displayed as
‘=A1+A2+A3+A4’.
226 Information Technology Play (Ver 1.0)-IX

