Page 238 - IT_Play_V1.0 Class9
P. 238

Recap Zone


                  Text data refers to the data which is a combination of alphabets, spaces, digits and/or other characters.
                  Numeric data consist of digits (0–9), Exponential (e), decimal (.) and numeric operators like +, -, /, *, %, $.
                  Date and Time are values and therefore can be added or subtracted and can be included for other
                   calculations.
                  A  formula  is  an  expression  that  helps  to  perform  arithmetical  calculation  and  also  executes
                   non-arithmetical tasks.
                  Cell content can be modified by either replacing or deleting it.
                  Mathematical operator is a symbol that performs certain mathematical or logical operations.
                  Functions  are  in-built  formula  in  LibreOffice  Calc  that  can  be  used  to  perform  arithmetical  and
                   non-arithmetical tasks.
                  AUTOSUM is a shortcut tool for adding the values of a range of cells.




                                                          Exercise


                                                 Section A (Objective Type Questions)

              A.  Multiple choice questions.
                 1.   If you want to display the largest value from a set of cells, which function should you use?
                    i.  MIN()                ii.  MAX()               iii.  AVERAGE()         iv.  COUNT()

                 2.  Which of the following error occurs when there is a problem with a number in a formula or function?
                    i.  ###                  ii.  #VALUE!             iii.  #NAME?            iv.  #NUM!

                 3.  What type of data can be entered as "5+8" in a cell?
                    i.  Text                 ii.  Formula             iii.  Date/Time         iv.  Numeric
                 4.  Which key is used to paste the copied or cut content in a new cell?
                    i.  Ctrl+C               ii.  Ctrl+V              iii.  Ctrl+X            iv.  Ctrl+Z
                 5.  Which of the following is a valid formula?
                    i.  =B1+B2               ii.  =Sum(A1:A5)         iii.  =A1-A2            iv.  All of these
              B.  State whether the following statements are true or false:

                 1.  The #VALUE! error occurs when a wrong type of argument is used.                         .......................
                 2.   The AND function returns TRUE if any condition enclosed in the bracket is TRUE, otherwise
                    it produces FALSE.                                                                       .......................
                 3.  The ROUND() and MOD() are example of statistical function.                              .......................
                 4.  The * operator performs division operation.                                             .......................
                 5.   Text data refers to the data that is a combination of alphabets, spaces, digits and/or
                    other characters.                                                                        .......................

                                                                                                     21 st
              C.  Assertion and reasoning question.                                               Century   #Critical Thinking
                                                                                                    Skills
                 The following question consists of two statements – Assertion (A) and Reason (R). Answer the question by
                 selecting the appropriate option given below:
                 i.   Both A and R are true and R is the correct explanation of A.
                 ii.  Both A and R are true but R is not the correct explanation of A.



                236     Information Technology Play (Ver 1.0)-IX
   233   234   235   236   237   238   239   240   241   242   243