Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2629_Devagiri_C-7
P. 23

    BRIDGE BACK
                      1.  What are two common uses of Excel in the workplace?

                      2.  Why do you think Excel is considered a powerful tool for analysing data?

                     Excel is a powerful tool that helps you organise, analyse and present data. In this chapter, you
                     will learn how to use formulas, create charts and manage information to make tasks easier and
                     more efficient.

                            USING FORMULAS TO PERFORM CALCULATION

                     In mathematics, formulas help with calculations and Excel works the same way. Formulas in Excel

                     start with an equal to (=) sign. If you forget the equal sign, Excel will consider the data as text and
                     the calculations won’t work.

                     ELEMENTS OF A FORMULA
                     The elements of a formula are:

                         References: These are cell addresses or ranges of cells
                        used in calculations (e.g., A1, B2:C5).

                         Operators: These symbols  indicate  the  operation           The maximum length of a formula
                        to  perform, such  as  addition  (+), subtraction (-),        in Excel is 8,192 characters.
                        multiplication (*) and division (/).

                         Constants: These are fixed values, like numbers (5, 10) or text (Hello), that remain unchanged
                        during calculations.

                     DIFFERENT WAYS TO ENTER FORMULAS
                     You can enter the formula directly into the cell or through the formula bar.

                         Enter  a  formula  directly  into  the cell: You can type  the
                        formula directly into the cell by starting with an equal sign
                        (=B2*C2) and then press the Enter key to see the result in the
                        cell D2.

                                                             Enter  a formula  in  the formula  bar: Select  the cell and
                                                            enter the formula in the formula bar (=B2*C2), then press
                                                            the Enter key to see the result in the cell D2.

                                                                                                                      21
                                                                                                         Excel in Excel

| 18 19 20 21 22 23 24 25 26 27 28 |