Page 332 - TP_IT_V1.0_C9_flipbpookl
P. 332

iv.   Pie Chart: It displays a circular chart cut by radii into segments, with each slice of pie showing the size is series, which
                       has no zero or less than zero value.

                                                                                             21 st   #Productivity & Accountability
              C.  Competency-based/Application-based questions.                            Century
                                                                                            Skills  #Technology Literacy
                 1.  Kartik’s father has recently been selected as the president of the society and was told to make a list of the neighbours with
                    details like name, number of members, phone number, address, date of shifting to their locality, and other details so that
                    he can share them with all the residents.
                     a.  Help him by suggesting the most suitable application software needed for this task.
                     b.  Which feature of the software will help him generate the serial number?
                     c.  Give the steps to change the font size and style.
                     d.  Give the steps to save the file.
                Ans.  a.  LibreOffice Calc
                     b.   AutoFill feature helps you fill the predictable series automatically in a range of cells using the fill handle (plus sign (+)).
                       This fill handle appears when the mouse pointer moves over the bottom right corner of an active cell. Drag this handle
                       down to the point till the series needs to be generated.
                     c.  Select Font and Style icons present on the Formatting toolbar.
                     d.  Click on the File → Save.
                 2.  Kabir has maintained his marks of five subjects in all 3 unit tests in three sheets. Help him do the given tasks:
                     a.  Write the steps to rename the sheets as Unit1, Unit2, Unit3.
                     b.  Feature to copy formula to rest of the cells.
                Ans.  a.  The steps to rename a Sheet are:
                        i.  Double-click the sheet in the Sheet tab. A Rename Sheet dialog box opens.
                        ii.  Type the name in the Name text box.
                        iii.  Click on the OK button.
                     b.  AutoFill feature or Copy and Paste options.
                 3.  Naina wants to store data of her monthly expenditures for a period of one year and also wants to perform some calculations
                    and analysis. Which LibreOffice application will you suggest Naina to use for this purpose?
                Ans.  LibreOffice Calc
                    Assertion and Reasoning Based Questions:
                    Direction: Questions 3-4, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions by selecting
                    the appropriate option given below:
                     a.  Both A and R are true and R is the correct explanation of A.
                     b.  Both A and R are true but R is not the correct explanation of A.
                     c.  A is true but R is false.
                     d.  A is false but R is true.
                 4.  Assertion (A): Charts in LibreOffice Calc are used to visually represent data.
                    Reason (R): Charts help in understanding data trends and comparisons more easily than raw numbers.
                  5.  Assertion (A): Bar charts in LibreOffice Calc are suitable for comparing data across different categories.
                    Reason (R): Bar charts can only display one dataset at a time and cannot be combined with other chart types.
                    Statement Based Questions:
                     Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to
                    the instructions given below:
                     a.  Statement 1 is True, Statement 2 is True
                     b.  Statement 1 is False, Statement 2 is False
                     c.  Statement 1 is False, Statement 2 is False
                     d.  Statement 1 is False, Statement 2 is True


                330   Trackpad Information Technology (Ver. 1.0)-IX
   327   328   329   330   331   332   333   334   335   336   337