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

i.   In cells F4, what is the formula needed to calculate the cost of dinner plates?         [1]
                           a.  =ROUND(D4;E4)                               b.  =MOD(D4:E4)

                           c.  =PRODUCT(D4;E4)                             d.  =POWER(DR;E5)
                      ii.   In cell F11, what is the formula that computes the total amount?                       [1]
                           a.  =SUM(F4;F10)                                b.  =SUM(F4:F10)

                           c.  =COUNT(F4:F10)                              d.  =SUM(D4=D10)
                      iii.   What is the formula to find out the item that costs the minimum out of all the items   [1]
                           mentioned?

                           a.  =MIN(D4:D10)                                b.  =MIN(E4:E10)
                           c.  =MIN(D4;D10)                                d.  =MIN(F4:F10)
                      iv.   What is the formula to find out the most costly item in the list?                      [1]

                           a.  =MAX(D4:D10)                                b.  =MAX(D4;D10)
                           c.  =MAX(F4:F10)                                d.  =MAX(F4;F10)

                      v.   What is the data type for the field ‘Items purchased’?                                  [1]
                           a.  Numeric                                     b.  Alphanumeric

                           c.  Date/Time                                   d.  Formula
                      vi.   Which of the following commands is used to merge two or more cells?                    [1]

                           a.  Format     Merge Cells                      b.  Tools    Merge Cells
                           c.  Edit    Merge Cells                         d.  None of these
                      vii.   Which  of  the  following  features  is  used  to  fill  the  numbers  in  the  S.  No.  column
                           automatically?                                                                          [1]

                           a.  Series                                      b.  AutoFill
                           c.  Fill                                        d.  All of these

                                                               PART–B
                 All questions are compulsory.  In case of internal choices, attempt any one.

                 16.  What is Cell Referencing? Discuss its different types giving suitable examples.              [2]
                 17.  Akashdeep has made a presentation for his new project. The content is ready but he does not have
                      enough time to design the slides for presentation. Name the feature which will help him to create a
                      professional presentation without devoting much time.                                        [2]

                 18.  What is a presentation? What are the various ways in which we can add multimedia features in a
                      presentation?                                                                                [2]
                 19.  What formula should be contained in the cell C2 to calculate Temp in Fahrenheit?














                                                                                       Sample Question Paper     231
   228   229   230   231   232   233   234