Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2632_CodeMind
P. 23

    We have already learnt in the previous class that formulas (mathematical expressions) are used to
                      perform calculations. In this chapter, we will learn more about formulas and different ways to add a
                      formula in a worksheet. We will also learn about different types of built-in functions in Excel.
                      Different Ways to Enter Formulas

                      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, the result
                      of the formula will appear in the cell:

                         • Typing the formula in the Formula bar: In this way, we can type the formula in the Formula bar
                         after selecting the cell. After entering the formula, when we press the Enter key on the keyboard,
                         the result will appear.

                           22    Premium Edition-VI

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