Page 119 - TechPluse_C6_Flipbook
P. 119

Test Sheet 2




                                                      (Based on chapters 5 to 8)
                                                              Section A
                 A.  Tick ( ) the correct option.

                     1.   What is the cell address in the formula known as?
                          (i)   Range                                 (iii)  Cell reference

                          (ii)   Mixed reference                      (iv)  None of these
                     2.   The variables that hold integers are called ...................... variables.

                          (i)   String                                (iii)   Floating
                          (ii)  Integer                               (iv)   Identifiers

                     3.    The ...................... function is used to calculate the average of a range of values.

                          (i)   AVERAGE( )                            (iii)   SUM( )
                          (ii)   AVG( )                               (iv)   COUNT( )

                     4.    The function used to find remainder after dividing two numbers is .......................

                          (i)   LEN( )                                (iii)   MOD( )
                          (ii)   CONCATENATE( )                       (iv)   MAX( )

                     5.    ...................... is a third generation language.

                          (i)   High-level language                   (iii)   Machine language
                          (ii)   Assembly language                    (iv)   Low-level language

                     6.    Which of the following is a way of achieving AI?
                          (i)   Machine learning                      (iii)   Both (i) & (ii)

                          (ii)   Decision Tree                        (iv)   None of these
                     7.    A computer programmer draws a ...................... before writing a computer program.

                          (i)   Chart                                 (iii)   Flowchart

                          (ii)   Scenery                              (iv)   Syntax

                 B.  Fill in the blanks.
                     1.   Good at resolving conflict in groups is an example of ...................... intelligence.

                     2.    The ...................... statement is used to display output.
                     3.    ...................... are predefined formulas in LibreOffice Calc.

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

                     5.    Siri, Alexa, and Chatbots are examples of .......................
                     6.    An ...................... is a program used to translate assembly language into machine language.



                                                                                                   Test Sheet 2      117
   114   115   116   117   118   119   120   121   122   123   124