Page 387 - TP_IT_V1.0_C9_flipbpookl
P. 387

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 sheet in LibreOffice 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 sheet in LibreOffice Calc:










                         After creating the sheet, 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 sheet in LibreOffice Calc:
















                                                                                                           Projects  385
   382   383   384   385   386   387   388   389   390   391   392