Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 43 - 2620_Birla Open Mind C-6
P. 43

    Creating a Chart
                     To create a chart, follow the given steps:

                      1   Select the
                          range of cells.
                                                                   2   Click on the     3   Click on the Insert Column
                                                                       Insert tab.          or Bar Chart command.

                                    4   Select the 2-D Column
                                        Chart option.

                          DATA TYPES IN EXCEL

                     In Excel, there are three different types of data that you can enter. These are:
                         Labels: The label is used to define the information on the spreadsheet, i.e.,
                       heading  of  columns,  titles  and  names.  We  can  not  do  any  mathematical
                       calculations on labels. Labels are aligned to the left side of a cell.
                         Values or Numbers: Values are numeric data on which mathematical calculations are performed.
                       This  type  of  data includes  numbers  0–9  and  special  characters, such  as –, +,  [, /, ?, >,  <,  %. The
                       numbers are always aligned to the right side of the cell and characters are always aligned to the left
                       side of the cell.
                         Formula: A formula is a mathematical expression used to do simple and complex calculations of the
                       numeric data inserted in 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 equal to sign, Excel
                     understands that user has entered 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 as follows:
                         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.

                                                                                   #Charts, Formulas and Functions in Excel  41

| 38 39 40 41 42 43 44 45 46 47 48 |