Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - ClickGPT V4.0 C-5
P. 27

    Come, let's now learn      We can find the highest
                                                    to use formulas in      scorer in her spreadsheet.
                                                          Excel.
                                                   Can anyone give me
                                                  an example of using a
                                                 formula in spreadsheet?

                                          Yes, ma'am!                                                            That's nice.

                     Test Your Knowledge                                                          21 st  Century   #Critical Thinking
                                                                                                      Skills
                        If you get 95, 85, and 90 marks in Maths, English and Computer Science respectively then find out your
                        average marks and percentage.

                     Excel is one of the most useful programs because it provides a wide range of tools to work with data.
                     In this chapter, you will learn about cell range, charts, formulas, and functions.
                     UNDERSTANDING CELL RANGE

                     A group of selected cells is called a range. To form a range, the selected cells should be in continuation.
                     When a range is selected in a worksheet, a rectangular shape is formed.
                     We can use a cell range to perform a calculation on multiple cells. We create the address of a range by
                     separating the starting and ending cell addresses with a colon (:) sign. For example, if we have selected
                     the cells from B2 to E3, then the address of the range will be B2:E3.
                     Selecting a Range in a Worksheet

                     Perform the following steps to select a range by using the mouse:

                                 Click on the first cell from which   1
                                 you want to start the range.
                                                                                                 Hintbot
                                                                              To select a range: Click on the first cell. Press
                                                                              and hold the Shift key and click on the last cell
                                                                              up to which you want to make the selection.

                                                    Press and hold the left mouse button and drag    2
                                                    the mouse diagonally to select the desired range.

                                                                                 Charts, Formulas & Functions in Excel  25

| 22 23 24 25 26 27 28 29 30 31 32 |