Page 240 - CA_165_V2.0_C9_Flipbook
P. 240

9.  Create a worksheet in ‘Calc’ for the following data:
                                                             ABC Corporation
                       Name     Designation     Basic Pay    HRA      TA        DA       Tax     Total Pay   Net Pay
                       Samar Manager              10000      30%     5% of    40% of     20%
                                                              of     Basic   Basic Pay    of

                                                             Basic    Pay     20% of     Basic
                                                              Pay            Basic Pay   Pay
                          Enter data for 10 persons.
                          Align the data item in the center of a Cell.
                          Use the formula ‘Total Pay = Basic Pay + HRA + TA + DA’ to calculate the Total Pay.
                          Use the formula ‘Net Pay = Total Pay - Tax’ to calculate the Net Pay.
                          Heading ABC Corporation should be Bold, Center of a Cell and must be underlined.

                          Using the Name and Basic Pay draw a Line, Bar, Pie and Column Chart.
                          Add filter to the above data and view selected rows based on different criteria.
                  10.  Electricity Consumption Year 2014–15:

                        Railway Traction     Industrial    Agricultural   Commercial      Domestic      Others
                             22.2%             31.4%          24.9%           3.6%          15.6%        2.1%

                      Draw a Pie Chart and Column Chart for the above data.
                  11.   The table below shows marks obtained by 50 students in Computer Class Test. Draw a Column Chart
                      (graph) based on the table.

                       Marks                 3        4        5        6        7        8        9        10

                       No.of Students        1        3        4        8        12       10       9        3

                  12.  For the following data, draw a Pie Chart.

                             Items             Rent           Food           Cloth        Education      Misc

                          Expenses in%          15%            35%            10%            20%          20%
                  13.   Create  a  presentation  titled  “Which  has  greater  environmental  destructive  potential,  Mankind  or
                      Nature?” Provide at least one slide for the following:

                         The Risks                                               Mega Tsunami
                         Earthquake                                              Hurricanes
                         Soil Degradation                                        Man-made Global Warming

                          Nuclear Bomb                                           Conclusion
                        For each of the above slides, select suitable layout for the slides. Insert Header and Footer and set the
                      background colour as green.
                  14.   Create an Impress presentation titled “Classical Dance forms of India”. Create at least any one slide
                      for the following:
                      i.   Place of origin                                    ii.  History
                      iii.  Speciality                                        iv.  Costumes
                      Also provide relevant images for each of the above.


                   238   Touchpad Computer Applications (Ver. 2.0)-IX
   235   236   237   238   239   240   241   242   243   244   245