Page 381 - Trackpad IT-402_Class-IX
P. 381

Calculate the total marks of Arjun in cell E6

                     Calculate the highest marks in the weekly test
                     Calculate the lowest marks in finals

                     Calculate the 20% of the weekly test of Shefali in cell E8
                     Calculate the percentage of Riti.

                     If the percentage of Riti is more than 85 give a message of Scholar Bage otherwise “Sorry” message should
                      be displayed.
                 3.  Create the given worksheet in OpenOffice Calc:

















                     Calculate the DA as 25 % of BASIC+HRA for each employee and display it in column D.
                     Calculate the NETSALARY as BASIC+HRA+DA–PF for each employee and display it in column F.

                     Find the maximum NETSALARY and display it in cell F9.
                 4.  Create the given worksheet in OpenOffice Calc:










                    After creating the worksheet, write functions/formulas to the following:
                     To calculate the AMOUNT as the product of RENT and DURATION in cell E2.

                     To calculate TAX as 10% of the corresponding AMOUNT to be entered in cell F2.
                     To calculate the BILLAMOUNT as the sum of AMOUNT and TAX in cell G2.

                     To find the highest RENT from column B in cell B8.
                     To count the number of rooms occupied from column C in cell C8.
                 5.  Create the given worksheet in OpenOffice Calc:
















                                                                                                      Projects  381
   376   377   378   379   380   381   382   383   384   385   386