Page 237 - CA_165_V2.0_C9_Flipbook
P. 237

3.   What are the different parts of a Function? Explain with an example.
                     4.   Explain different types of errors in OpenOffice Calc.
                     5.   What are Charts in OpenOffice Calc? Discuss different types of Charts.
                 D.   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 OpenOffice Calc. Which formula has she used in the
                         cell B8?



















                                                              SECTION C
                                              (Case-based/Passage-based Type Questions)
                       Data can be easily displayed through charts in a spreadsheet package. Based on the same data, a user can easily
                     switch from one type of chart to another. The charts are always linked to the data they are depicting. If you
                     make any change in the data, it will be reflected in charts also.
                     1.  .................................... charts help to compare how each value relates proportionally to the whole.
                         i.  Bar                                             ii.  Pie
                         iii.  Line                                          iv.  Area
                     2.     Which among the following is a version of a line or column graph? It is useful to emphasise on volume of
                         changes of data.
                         i.  X-Y Scatter                                     ii.  Bar
                         iii.  Pie                                           iv.  None of these
                     3.   Which among the following is not an advantage of chart?
                         i.  It summarises only small data set in visual form and estimates key value at a glance.
                         ii.  Charts are visually appealing and it is easy for the users to compare the information.
                         iii.  Charts help to forecast the trends on the basis of comparisons done.
                         iv.  None of these


















                                                                                                Data Analysis    235
   232   233   234   235   236   237   238   239   240   241   242