Scribd Logo
Upload

Welcome to Scribd!

  • 646 views

    Excel Final Assignment

    Uploaded by

    Atul Zore
    This document contains an Excel assignment to generate a salary statement for 10 employees for the month of April. It involves calculating details allowance, HRA, conveyance, gross salary, tax, PF, loan, net salary for each employee. The assignment also requires generating a graph of employee details, sorting records by designation, filtering records by net salary range, and calculating total salary by branch.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Excel Final Assignment

    Uploaded by

    Atul Zore
    646 views1 page
    This document contains an Excel assignment to generate a salary statement for 10 employees for the month of April. It involves calculating details allowance, HRA, conveyance, gross salary, tax, PF, loan, net salary for each employee. The assignment also requires generating a graph of employee details, sorting records by designation, filtering records by net salary range, and calculating total salary by branch.

    Original Description:

    assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an Excel assignment to generate a salary statement for 10 employees for the month of April. It involves calculating details allowance, HRA, conveyance, gross salary, tax, PF, loan, net salary for each employee. The assignment also requires generating a graph of employee details, sorting records by designation, filtering records by net salary range, and calculating total salary by branch.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    646 views1 page

    Excel Final Assignment

    Uploaded by

    Atul Zore
    This document contains an Excel assignment to generate a salary statement for 10 employees for the month of April. It involves calculating details allowance, HRA, conveyance, gross salary, tax, PF, loan, net salary for each employee. The assignment also requires generating a graph of employee details, sorting records by designation, filtering records by net salary range, and calculating total salary by branch.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 1

    Excel Assignment- MMS Date – 21st September 2016 Total Marks 10

    SALARY STATEMENT FOR THE MONTH OF APRIL


    MPNO NAME DESG Branch BASIC
    1 RAJ OFFICER Mumbai 5000
    2 RAJESH CLERK Mumbai 3500
    3 ANAND MANAGER Delhi 7000
    4 RAJU CLERK Delhi 4000
    5 HEMANT MANAGER Mumbai 8000
    6 SANTOSH CLERK Delhi 3780
    7 BHAUMIK OFFICER Delhi 4200
    8 MANJIT OFFICER Mumbai 5000
    9 KAMAL OFFICER Delhi 3800
    10 SONU CLERK Mumbai 2500

    1.

    a. Calculate DA as following condition


    For Officer 10%, Manager 15%, & Clerk 5% of Basic (using vlookup
    function).
    b. Calculate HRA as following condition( using vlookup function)
    For Officer - 10000, Manager - 30000, Clerk - 5000
    2. Calculate Conveyance 10% of Basic
    3. Calculate Gross [Basic + DA +HRA+CONV]
    4. Calculate Tax according to Slabwise on Gross by if function
    i.e. <10000 = 0
    >10000 = 750
    5.

    a. Calculate P.F as 5% on Basic Salary


    b. Calculate Loan 2% of Gross
    6. Calculate Net Salary i.e. [Gross-[IT+PF+LOAN]]
    7. Draw a graph of Name, Basic, Gross & Net [Graph of 3D & should well
    formatted]
    8.

    a. Sort your Record according to Desg wise.

    9. Display the Records of Net Salary between 6000-9000 and get the result on a
    new page
    10. Get the total salary branch wise.

    You might also like