Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 90 - 2619_PlusGPT V2.1_C-7
P. 90

    test Your skiLLs

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

                            (i)  $A$4                                        (ii)  A1

                           (iii)  D6                                        (iv)  B3
                         b.  Which of the following functions is used to calculate the average of a range of values?

                            (i)  AVERAGE                                     (ii)  SUM

                           (iii)  AVG                                       (iv)  INT
                         c.   What is the cell address in a formula called?

                            (i)  Range                                       (ii)  Cell reference

                           (iii)  Mixed reference                           (iv)  Formula

                         d.  What is a group of selected cells called?
                            (i)  Selection                                   (ii)  Combination

                           (iii)  Cell range                                (iv)  Cell reference

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

                                                Cell reference, Formulas, Functions,  Referenced

                         a.                      always start with an equal to (=) sign.

                         b.  If you change the value in the                   cell, the result of the formula will automatically
                            update.
                         c. A                      is like the address of a cell in Google Sheets.

                         d.                      are predefined formulas in Google Sheets.
                      3.  Answer the following:

                         a. What is cell reference?
                              _____________________________________________________________________________________________

                              _____________________________________________________________________________________________

                         b.  What is the use of the PRODUCT() function?
                              _____________________________________________________________________________________________

                              _____________________________________________________________________________________________

                         c.  What are the rules to enter a function?
                              _____________________________________________________________________________________________

                              _____________________________________________________________________________________________

                      88    Premium Edition-VII

| 85 86 87 88 89 90 91 92 93 94 95 |