Page 221 - CA 165 ver 1.0 Class 9
P. 221

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.


                                                                PART B

                 A.   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

                 B.   Long answer type questions.
                     1.   What is Formula? Explain the different types of formula used in ‘Calc’.
                     2.   What is the significance of Cell Referencing? Explain the different types of cell referencing used in ‘Calc’.
                     3.   What are the different parts of a Function? Explain with an example.
                     4.   Explain different types of errors in ‘Calc’.
                     5.   What are Charts in ‘Calc’? Discuss different types of Charts.
                 C.   Application based questions.
                     1.     Akash Kumar is inserting the marks for 1st summative test. He wants to perform some calculations and do
                         analysis, i.e., Max, Min, Abs. Which Office application will you suggest Akash to use for this purpose?
                     2.   While writing a formula Sudeep found an error having “####”. Name this error.
                     3.   Sugandha has made the following data entries in Calc. Which formula has she used in the cell B8?






































                                                                                                Data Analysis    219
   216   217   218   219   220   221   222   223   224   225   226