Page 74 - TP_Prime_v2.2_Class_6
P. 74

Periodic Assessment                             2


                                                      (Based on chapters 3, 4 & 5)




                  A.  Write a short note on the following:

                       1.   Selecting Unrelated Cells
           Prime (Ver. 2.2)-VI  __________________________________________________________________
                           __________________________________________________________________




                           __________________________________________________________________

                       2.  Cell referencing
                           __________________________________________________________________
                           __________________________________________________________________

          72               __________________________________________________________________

                       3.  Auto Fill
                           __________________________________________________________________

                           __________________________________________________________________

                           __________________________________________________________________


                  B.  Name the function that performs the following:

                      1.   It returns a number after rounding to the specified digits.                   __________
                      2.   It joins together two or more different strings.                              __________

                      3.    It checks whether the given condition is met, and returns value1 if the condition

                           evaluates to true and returns value2, if the condition evaluates to false.    __________

                      4.    It returns the count of number of values in the selected range.              __________

                  C.  Identify and write the names of these tools.


                      1.           ______________                   2.           ______________



                      3.           ______________                   4.           ______________



                      5.           ______________                   6.           ______________
   69   70   71   72   73   74   75   76   77   78   79