Page 290 - open office
P. 290

1 .  What is justified alignment
                 Ans.  The contents will be displayed completely within the column width by increasing the column width.
                  11.  What is the use of fill handle
                 Ans.  The Calc Fill Handle tool is used to automatically fill input in series. It fills the next cells when we drag it with the
                      next predefined value. For example, if you want to fill the numbers in sequence of even numbers 2, 4, 6...., or
                      days of the week as Monday, Tuesday,.... or month names as  an, Feb,....,  we need to enter the first two values,
                      select them and drag to the next cells to generate the series.

              B.  Application based questions:                                                          L if e Sk il l s  &  V a l ues
                   1.  Ashmit wants to present the information in the form of a chart. He has a data of single series and the graph
                      must show relative circular size of each value. Which chart type must he use?
                 Ans.  Pie chart

                   2.  Rohit is  preparing a monthly  sales  report with the help of  a Spreadsheet. While  typing, the text is  not
                      accommodated within the column width. Which option should he use to make the text appear properly?

                 Ans.  Shrink to fit Cell size



              Unsolved Exercise



                                                              Section A
                                                      (Objective Type Questions)

              A.  Multiple choice questions:
                  1.  We can replace multiple occurrences of a word using which of the following facilities of Calc? [CBSE Handbook]
                       i.  By find and replace                               ii.  By replace only

                     iii  By copy command                                   iv.  By preview command
                  2.  The ‘Chart Wizard’ dialog box appear with four steps on the left side. Which of the following is not a step
                     among these steps?
                     i.  Data Series                                        ii.  Chart Element
                     iii.  Chart Type                                       iv.  Legend
                  3.   What is the name of the mechanism to arrange the data in a particular order?

                     i.  Sorting                                            ii.  Searching
                     iii.  Filtering                                        iv.  Validating
                  4.  Which of the following option is used to print a chart?
                       i.  Insert   Chart                                   ii.  File    iew

                       iii.  File   Print                                   iv.   iew   Chart
                  5.  How many axes does charts in Calc have?
                     i.  Two                                                ii.  Three
                     iii.  Five                                             iv.  Four










               290      Touchpad Information Technology-IX
   285   286   287   288   289   290   291   292   293   294   295