Page 37 - iPro_trackGPT_V5_Class8
P. 37

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

                     1.  Capital function converts the text into upper case.                            ..........................
                     2.  It is not possible to join together two or more different text strings
                        in Excel.                                                                       ..........................

                     3.  Every function in Excel must be followed by opening and closing
                        parentheses ().                                                                 ..........................
                     4.  You can select a cell range by either using the mouse or by holding down
                        the Shift key.                                                                  ..........................

                     5.  In the reference $G1, the column G is fixed, but the row is changable
                        change.                                                                         ..........................


                 C.  Fill in the blanks using the words given below:


                                                     Sorting, Functions, Count, Mixed, $


                     1.  .......................... sign is used before row number and column letter to create an absolute
                        reference.
                     2.  .......................... means arranging data in a certain order, like ascending (from smallest to
                        largest) or descending (from largest to smallest) order.

                     3.  $A5 is an example of .......................... referencing.
                     4.  Excel also contains built-in formulas called ...........................

                     5.  .......................... function returns the count of the number of values in the selected range.

                 D.  Match the following:

                     1.  Data Series                              a.   It can be horizontal or vertical, depending on
                                                                     the chart type.
                     2.  Data Labels                              b. It is a collection of related values.
                     3.  Gridlines                                c.   The rectangular section between the X and Y
                                                                     axes.

                     4.  Plot Area                                d.   It shows data values, category names, series
                                                                     names, etc.



                     Answer Arcade                                                            Section B (Subjective)



                 A.  Short answer type questions.

                     1.  Define chart.
                        ...................................................................................................................................................................................






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