Page 36 - iprime_V2.2_class8
P. 36

Reb          t



                        Excel allows users to create custom formulas to perform calculations on their data.
                        A cell reference is a cell address that can be used in a formula to denote a specific cell.
                        The equal sign tells Excel that the succeeding characters constitute a formula.

                        A group of selected cells is called a range.
                        Excel also contains built-in formulas called functions that make it easy to perform common
                        calculations on data.
                        Charts make it easier to draw comparisons, analyse growth and relationships, among the
                        values.






                    OneOne Touch          Learn                                               Section A (Objective)



                  A.  Tick ( ) the correct option.

                     1.  .......................... cell reference can be included in relative reference.
                         a. A3                                           c. $A$4

                         b. A$1                                          d. $D6

                     2.  The .......................... function is used to calculate the average of a range of values.

                         a. Average                                      c. SUM

                         b. AVG                                          d. MAX
                     3.  The cell address in the formula is known as .......................... .

                         a. range                                        c. cell reference

                         b. mixed reference                              d. formula

                     4.  A group of selected cells is called a .......................... .
                         a. selection                                    c. combination

                         b. cell range                                   d. Data

                     5.  .......................... is the vertical axis that is used to plot values.

                         a. Bar                                          c. Data
                         b. Value Axis                                   d. Formulas

                     6.  Sort & Filter command is present under the .......................... .

                         a. Home tab                                     c. Insert tab

                         b. Formula tab                                  d. View tab




                  34     iPRIME (Ver. 2.2)–VIII
   31   32   33   34   35   36   37   38   39   40   41