Page 38 - TP_iPlus_V2.1_Class8
P. 38

7.  Which chart is used to display the quantitative magnitude of the data graphically?

                        a. Column Chart                                  b. Pie Chart

                        c. Bar Chart                                     d. Area Chart


                      8.  Under which tab is "Change Chart Type" command present?

                        a. Page Layout                                   b. View

                        c. Design                                        d. Format

                  B.  Fill in the blanks using the words given below.


                                  Hints: UPPER, Logical, Legend, Absolute References, equal, custom sort


                      1.  In order to maintain the original reference as they are, you must use ...............................

                      2.  .............................. functions evaluate conditions and give the result as True or False.

                      3.  .............................. is a key which shows the meanings of symbols and colours used in the chart.

                      4.  An .............................. sign tells Excel that the succeeding characters constitute a formula.

                      5.  .............................. function converts the text string into uppercase.

                      6.  .............................. is used when data is to be sorted on the basis of more than one criteria.

                  C.  Write ‘T’ for true and ‘F’ for false.

                      1.  Every formula begins with a * sign.                                             ..........................

                      2.  Combined reference is a type of cell range.                                     ..........................

                      3.  We can create a Bar chart in Excel.                                             ..........................

                      4.  You can sort more than one column at a time in a selected
                         range of cells.                                                                  ..........................


                      5.  The Add Level button is available under the File tab.                           ..........................

                      6.  Data Labels refers to the horizontal and vertical lines in the plot area.       ..........................

                  D.  Match the following:

                      1.  POWER()                             a.  returns the length of the text string.

                      2.  Scatter Chart                       b.  Makes chart easy to understand

                      3.  Gridlines                           c.  returns the result of a number raised to some power.

                      4.  LEN()                               d.  Correlation between two sets of values






                    36
                         iPlus (Ver. 2.1)-VIII
   33   34   35   36   37   38   39   40   41   42   43