Page 232 - CA_165_V2.0_C9_Flipbook
P. 232

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): The =TODAY() function in OpenOffice Calc returns the current date.
                               Reason (R): The =TODAY() function does not require any arguments and updates automatically to
                            reflect the current date.
                            2.  Assertion (A): Sorting data in OpenOffice Calc only works with numeric values.
                               Reason  (R):  Sorting  in  OpenOffice  Calc  can  be  done  with  both  text  (alphabetically)  and  numbers
                            (numerically), depending on the selected range

                      Ans. 1. i.    2. iii.

                                                               SECTION B
                                                       (Subjective Type Questions)
                  A.   Very short answer type questions.
                      1.   Name the error displayed when we write =SIM in place of =SUM while applying the sum function.
                      2.   Which feature helps arrange data in ascending or descending order?
                      3.   Name the chart that uses lines to show information and change over a period of time.

                      4.   Name the chart that represents data in horizontal columns.
                      5.   What is a set of values which the user wants to plot in a chart called?

                      Ans. 1. #NAME    2. Sorting    3. Line Chart    4. Bar Chart    5. Data Series

                  B.  Short answer type questions.
                      1.   What is meant by sorting data?
                      Ans.  Sorting refers to the process of arranging data in ascending or descending order based on a certain
                          criteria.
                      2.   State the purpose of TODAY() and NOW() functions.
                      Ans. TODAY() produces the current date, it contains no argument.
                          NOW() produces the current date and time, it contains no argument.
                      3.   What is meant by Gridlines in a chart?
                      Ans.  Gridlines refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart
                          to enhance its readability.
                      4.   What does a #REF! error indicate?
                      Ans. #REF! occurs when a cell reference is not valid.
                      5.   Give difference between column chart and a bar chart.

                      Ans.                Column chart                                 Bar chart
                           A column chart represents the data over a   A bar chart represents the data in horizontal
                           period of time in columns.                  columns.
                           The measurement values are shown vertically   The measurement of values are organized
                           as Y-axis.                                  horizontally.


                   230   Touchpad Computer Applications (Ver. 2.0)-IX
   227   228   229   230   231   232   233   234   235   236   237