Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 52 - 2611_SmartGPT Pro V(5.0) C-5
P. 52

    TYPES OF DATA IN EXCEL

                      In Excel, there are three different types of data that you can enter. These are:

                           Text: The text is used to define the information on the spreadsheet,          NAME  AGE  CLASS
                         i.e., the headings of columns, titles, and names. This includes any            AKSHAT    11    4 5
                                                                                                        SOUMYA
                                                                                                                  12
                         type of text, not just phone numbers, numbers, or formulas. We do              RAHUL     11    4
                         not do any mathematical calculations on text. Text is aligned on
                         the left side of a cell.

                                                                       Values or Numbers: Values are numeric
                                                                     data on which mathematical calculations are
                                                                     performed. This type of data includes characters
                                                                     0–9 and special characters, such as –, +, [, /,
                                                                     ?, >, <, %. The numbers are always aligned on
                                                                     the right side of the cell, and the characters are
                                                                     always aligned on the left side of the cell.
                           Formula:  A formula is a mathematical expression that performs both simple and

                         complex calculations on the numeric data entered into a cell. A formula always begins
                         with an equal (=) sign, e.g., = A2 + B2.

                                USING FORMULAS TO PERFORM CALCULATION

                      Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with an
                      equal sign, Excel understands that the user has given a formula here. If you don’t enter the
                      equal sign, Excel will treat your entry as text, and the calculation will fail.

                      DIFFERENT WAYS TO ENTER A FORMULA

                      There are mainly two ways to enter a formula in a worksheet:

                           Typing the Formula Directly in the Cell: In this
                         way, the formula is directly  typed  in the cell
                         after typing an equal sign (=). After entering the
                         formula in the cell, press the Enter key. When
                         the Enter key is pressed, result of the formula
                         appears in the cell.

                           Typing  the Formula in the Formula Bar: In
                         this way, we can type the formula in Formula

                         bar after selecting  the  cell. After entering  the
                         formula, when we press the Enter key from the
                         keyboard. The result will appear.

                       50   Computer Science (V5.0)-V

| 47 48 49 50 51 52 53 54 55 56 57 |