Page 64 - Viva ICSE Computer Studies 7 : E-book

tab. The selected cell will be
merged and the text will be
centered.
2. Click on the cell A2 and type
Step 2 Step 1
‘Name’ . Press the right arrow
key. Type ‘Science’ in B2 and
in the same way, enter the
remaining subject names.

3. Click on the cell A3, type
‘Reena’ and press the Enter
Step 3
key. The active cell will move Step 4
to the cell A4. Similarly, enter
the remaining names.

4. Click on the cell B3 and enter the number ‘89’. Press the right arrow key. The cell pointer
will move to cell C3. Enter the number
‘90’. In the similar manner, enter
the remaining data as shown in the
screenshot.

Method 2: To enter data using ‘Formula’ bar,
click on the cell where you want to enter the
data. Then place the cursor on the ‘Formula’
bar and type your formula. Press the Enter
key after entering the complete formula.

Types of Data

There are three types of data that can be entered in an Excel sheet.

Numbers or Numeric Data

Numeric data consists of numbers from 0 to 9 and symbols like +, –, !, @, $, % and so on. It is
used in calculations.

Text Data Think and Discuss

Text data consists of alphabet, numbers, spaces and What is the extension of the file
special characters which are not used in calculations. saved in Excel 2016?

Formulae Data

Formulae data are the mathematical equations containing numbers, operators and cell
address. A formula should always begin with an equal to (=) sign. Numbers and formulae are
collectively known as values.

52