Page 236 - CA_165_V2.0_C9_Flipbook
P. 236

B.  Fill in the blanks.
                      1.   The addressing of a cell in a formula is called ......................................
                      2.  ..................................... referencing is a way to apply formula in which the value of range of cells do not change
                          even if the formula is copied to a new cell.
                      3.  ..................................... is the pictorial representation of data present in a worksheet.
                      4.  ..................................... is the  process of arranging  data  in ascending  and  descending  order  based on  a
                          particular field.
                      5.  .....................................  error occurs when a cell reference is not valid.

                  C.  Assertion and Reasoning question:
                        The following questions consist of two statements – Assertion (A) and Reasoning (R). Answer these
                      questions by selecting the appropriate option given below:

                      i.   Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).
                      ii.   Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A).
                      iii.  Assertion (A) is true, but Reason (R) is false.
                      iv.   Assertion (A) is false, but Reason (R) is true.
                            1.  Assertion (A): In OpenOffice Calc, mixed referencing allows copying formulas while keeping either the
                            row or column fixed.

                               Reason (R): A mixed reference like $A1 or A$1 ensures only one part remains constant when copied.
                            2.  Assertion (A): The <> operator in OpenOffice Calc is used to compare two numeric values only.
                               Reason (R): In OpenOffice Calc, the <> operator checks for inequality and can be used to compare both
                            numeric and text values.

                                                               SECTION B
                                                       (Subjective Type Questions)

                  A.  Very short answer type questions.
                      1.   Give formula to add content of cell A2 and A3.
                      2.   What is the formula to divide the content of C4 by the product of content of cells A3 and A5.
                      3.   How to find out minimum value out of the range B3: B7? Give formula.
                      4.   What is the formula to find out the no. of employees whose salaries are given in the range D6:D30.
                      5.   Write the formula to find out the value of  5 .
                                                                 4
                  B.   Short answer type questions.
                      1.   Explain any two logical functions with example.
                      2.   Define Operators. List and describe all the operators.
                      3.   Describe the reason for the occurrence of the following errors:
                          i.  #VALUE                                          ii.  #REF!
                      4.   Write down the steps to hide columns in OpenOffice Calc.
                      5.   Explain the following terms used in a chart:
                          i.  Data Series                                     ii.  Walls & Floors
                  C.   Long answer type questions.
                      1.   What is Formula? Explain the different types of formula used in OpenOffice Calc.
                      2.     What  is  the  significance  of  Cell  Referencing?  Explain  the  different  types  of  cell  referencing  used  in
                          OpenOffice Calc.


                   234   Touchpad Computer Applications (Ver. 2.0)-IX
   231   232   233   234   235   236   237   238   239   240   241