Page 37 - iPlus_Ver_2.0_class_8
P. 37

4.  What is a group of selected cells called?

                       a. Selection                                     b. Cell range

                       c. Combination                                   d. None of these


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

                       a. Bar                                           b. Value Axis

                       c. Data                                          d. Formulas

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

                       a. Home tab                                      b. Formula tab

                       c. Insert tab                                    d. View tab


                     7.  What can be sorted by using the Sort A to Z option?

                       a. Numbers                                       b. Symbols

                       c. Text                                          d. All of these


                     8.  What does the NOW () function display?
                       a. Date                                          b. Time


                       c. Both a and b                                  d. None of these

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


                                          Hints: Functions, Mixed, SQRT, custom sort, column


                     1.  .......................... are predefined formulas in Excel.

                     2.  The .......................... function returns the square root of the given number.

                     3.  The .......................... chart usually displays the data in the form of vertical bars.

                     4.  In .......................... Referencing, you can lock either a column or a row by preceding it with a Dollar
                        ($) symbol.

                     5.  .......................... 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.                                             ..........................




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