Page 37 - TP_iPlus_V2.1_Class8
P. 37

Excel provides a variety of different chart formats, such as Bar, Column, Pie, Line, Area,
                        Scatter.
                          Charts make it easier to draw comparisons, analyse growth and relationships among
                        the values.

                          Sorting of data refers to the process of arranging data in ascending or descending
                        order based on a certain criteria.



                                                          Exercise


                                                        Section A (Objective)

                 A.  Tick (✓) the correct option.

                     1.  Which of the following is the relative cell reference?

                       a. B3                                            b. $B3

                       c. &B3                                           d. $B$3

                     2.  Which of the following functions is used to find the remainder after a number is
                        divided by the divisor?

                       a. PRODUCT                                       b. MOD

                       c. SQRT                                          d. POWER


                     3.  What is the cell address in the formula known as?
                       a. Range                                         b. Mixed reference

                       c. Cell reference                                d. None of these


                     4.  What kind of functions can calculate interest on a loan?

                       a. Statistical function                          b. Financial function

                       c. Date and Time Function                        d. Mathematical Function


                     5.  What is the horizontal axis that is used to plot the labels?
                       a. Bar                                           b. Value Axis


                       c. Data                                          d. Category Axis

                     6.  Under which group is the Sort & Filter command present?

                       a. Styles                                        b. Editing

                       c. Number                                        d. Alignment



                                                                                                                  35
                                                                              Spreadsheet—Functions and Charts
   32   33   34   35   36   37   38   39   40   41   42