Page 262 - Trackpad 402_Class-X_Final
P. 262

a. To calculate AMOUNT with the help of corresponding RENT and DURATION as RENT*DURATION to be written in E2.
              b. To calculate TAX as 10% of corresponding AMOUNT to be written in F2.
              c. To calculate BILLAMOUNT as total of corresponding AMOUNT and TAX to be written in G2.
              d. To find highest RENT from the column B to be written in B8.
              e. To count the number of rooms occupied from the column C to be written in C8.
          24.  Arguments passed to a macro from Calc are always        .                                   [2022]
              a. Strings                                         b. References
              c. Numbers                                         d. Values
          25.  List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet.   [2020]
          26.  What could you do to add an absolute reference?                                             [2016]
              a. Add dollar signs around the cell                b. Click F4
              c. Both (a) and (b)                                d. None of the above

          27.  What is conditional formatting? Explain “sort” and “filter” features available in spreadsheet.   [2017]



                                                                                21 st   #Leadership & Responsibility
            LAB ACTIVITY                                                      Century   #Creativity
                                                                                Skills

              1.  Create the following worksheet in OpenOffice Calc and display the sum of items according to items and
                then city.













              2.  Enter the following data into the worksheet and compute the strike rate of the batsman:

                                     Runs Scored             67
                                     Balls Faced             78
                                     Strike Rate             85.90

                                     End of document         Ctrl + Shift + End
                Now find out the strike rate on the basis of the following records:
                i.  When score is 45 and balls faced are 30.
                ii.  When score is 40 and balls faced are 90.
                iii.   When score is 89 and balls faced are 100.
              3.  Create the following worksheet in Calc:

                                               English              Hindi              Maths
                      Test 1              17                 16                  17

                      Test 2              15                 16                  18
                      Test 3
                Use the goal seek feature to predict how much marks should the student score in Test 3 to get 88% marks
                in total.




          262   Trackpad Information Technology-X
   257   258   259   260   261   262   263   264   265   266   267