Page 35 - Trackpad_ipro 4.1_Class8
P. 35

One Touch
                   One                    Learn                                             Section A (Objective)


                           ✓
                 A.  Tick ( ) the correct option.
                     1.  Which of the following cell references can be included in the relative reference?

                        a. A3                                           b. A$1

                        c. $A$4                                         d. $D6

                     2.  Which of the following functions is used to calculate the average of a range of values?

                        a. AVERAGE                                      b. AVG

                        c. SUM                                          d. None of these

                     3.  By what name is the cell address in the formula known as?

                        a. Range                                        b. Mixed reference

                        c. Cell reference                               d. None of these

                     4.  What is a group of selected cells called?

                        a. Selection                                    b. Cell range

                        c. Combination                                  d. None of these

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








                                                                             Spreadsheet—Functions and Charts    33
   30   31   32   33   34   35   36   37   38   39   40