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

