Question
Use Google Sheets and create a spreadsheet containing the yearly Salary details of 10 employees of a university under the headings employee name, yearly basic salary, DA percentage, Provident fund deductions, Income Tax deduction, and net salary. You may use the following formulas for making the spreadsheet:
DA amount = DA percentage * yearly basic salary Provident fund = 8% of yearly basic salary Income Tax deduction is computed as: For yearly basic salary < 5,00,000 tax=0 For yearly basic salary >= 5,00,000 but <10,00,000 tax = 20% of (yearly basic salary - 5,00,000) For yearly basic salary >= 10,00,000 tax = 1,00,000+ 30% of (yearly basic salary 10,00,000) Net Salary = yearly basic salary + DA amount - Provident fund - tax
Answer :
Word Count : 487
_________ _________ __________ ________ __________ ___ __________ ____ _____.
_______ _____ ______ _______ _______ _____ ___ _____ _________ ______ ____ ______.
__________ _____ _______ __________ _________ _____ __________ _________ _____ _________.
____ _______ ________ ________ ______ _______ __________.
_________ _____ __________ __________ ____ _________ _____ __________ _________.
_____ ___ ___ _____ ______ _____ _____ _______ _______ __________.
____ _____ _________ ___ _________ _____ _____ __________ ________ _____ ____.
_________ __________ ____ __________ _____ __________ ______ _____.
________ ______ ________ _____ ______ _________ ____ ___ ____.
______ _______ __________ _____ ___ __________ ______ _________ ________ __________.
__________ ________ ______ _____ ________ ______.
___ __________ _________ ________ ______ ____ _________ _________ ____ ___.
_________ __________ ________ ____ ___ _____ __________ _____ ______ ____ _____.
___ ______ __________ __________ __________ ______ __________.
_____ ______ _______ ____ __________ _________ ______ ______ _________ ______ ________.
___ ___ _____ __________ ______ ____ _____ __________ ____ _______.
_________ ____ _____ ___ ____ __________ _______ ______ _______ ________ ___ ______.
______ __________ _____ ________ _________.
_________ ________ _________ ___ _____ _________ ___ _________.
___ _____ ____ ____ ______ __________ ___.
___ ______ ________ ______ ________ ________ _________ _____.
_________ ______ ________ ______ _______ __________.
_________ ___ _______ ____ ______ _________.
______ _______ ___ _____ ______ _____ ______ ______.
____ __________ ____ __________ _________ ___ __________ __________ ________.
_________ ______ _______ _______ ___ _____ __________ _______ _______ ______ _________ _______.
_______ ________ ___ _______ ____ ____ ________ ______ ________ ___ __________.
________ ____ _______ ______ ___ ____ _____ _________.
_______ __________ _______ _______ ___ _________ __________ _______ _______ _______ ___ ______.
______ __________ _____ ___ ______ ____ ___ _____ ___.
___ ________ _____ _______ _______ _________ ____ ___.
___ ________ ______ ________ ________ _____ _______ ________ __________ ________ _____ ____.
______ ________ ___ ____ ________ ____ _______ ______ ________ __________.
________ _____ ________ _______ _________.
____ ______ __________ _____ _________.
_____ _____ ________ ______ _______.
_____ ____ _________ ________ ____ _________.
____ ________ ________ _________ ________ ___ _______ __________ ______ ___ _____ __________.
________ _______ __________ ____ ____ ____.
_______ ___ __________ __________ ____ _____ _________.
__________ ___ _____ ______ ____ ____ _________ _______ __________ ______ ___.
_____ ______ ________ _______ _______ _____.
Skip in 10
आइए हम एक उदाहरण के रूप में 10 कर्मचारियों की सैलरी शीट को मैन्युअल रूप से (Google Sheets में लागू करने योग्य फार्मूलों सहित) संख्यात्मक रूप से तैयार करें। नीचे सभी कॉलम और गणनाएँ क्रमवार दी गई हैं: --- ### स्तंभ शीर्षक (Column Headings): 1. Employee Name 2. Yearly Basic Salary 3. DA % 4. DA Amount = (DA % × Basic Salary) 5. Provident Fund = 8% of Basic Salary 6. Income Tax Deduction (As per rules given) 7. Net Salary = Basic + DA - PF - Tax --- ### कर्मचारियों का डेटा और गणनाएँ: | Employee Name | Yearly Basic Salary (Rs) | DA % | DA Amount (Rs)
___ __________ ____ _________ ______ ________ ______ _________ ___ _______ ____._________ _________ __________ ________ __________ ___ __________ ____ _____.
_______ _____ ______ _______ _______ _____ ___ _____ _________ ______ ____ ______.
__________ _____ _______ __________ _________ _____ __________ _________ _____ _________.
____ _______ ________ ________ ______ _______ __________.
_________ _____ __________ __________ ____ _________ _____ __________ _________.
_____ ___ ___ _____ ______ _____ _____ _______ _______ __________.
____ _____ _________ ___ _________ _____ _____ __________ ________ _____ ____.
_________ __________ ____ __________ _____ __________ ______ _____.
________ ______ ________ _____ ______ _________ ____ ___ ____.
______ _______ __________ _____ ___ __________ ______ _________ ________ __________.
__________ ________ ______ _____ ________ ______.
___ __________ _________ ________ ______ ____ _________ _________ ____ ___.
_________ __________ ________ ____ ___ _____ __________ _____ ______ ____ _____.
___ ______ __________ __________ __________ ______ __________.
_____ ______ _______ ____ __________ _________ ______ ______ _________ ______ ________.
___ ___ _____ __________ ______ ____ _____ __________ ____ _______.
_________ ____ _____ ___ ____ __________ _______ ______ _______ ________ ___ ______.
______ __________ _____ ________ _________.
_________ ________ _________ ___ _____ _________ ___ _________.
___ _____ ____ ____ ______ __________ ___.
___ ______ ________ ______ ________ ________ _________ _____.
_________ ______ ________ ______ _______ __________.
_________ ___ _______ ____ ______ _________.
______ _______ ___ _____ ______ _____ ______ ______.
____ __________ ____ __________ _________ ___ __________ __________ ________.
_________ ______ _______ _______ ___ _____ __________ _______ _______ ______ _________ _______.
_______ ________ ___ _______ ____ ____ ________ ______ ________ ___ __________.
________ ____ _______ ______ ___ ____ _____ _________.
_______ __________ _______ _______ ___ _________ __________ _______ _______ _______ ___ ______.
______ __________ _____ ___ ______ ____ ___ _____ ___.
___ ________ _____ _______ _______ _________ ____ ___.
___ ________ ______ ________ ________ _____ _______ ________ __________ ________ _____ ____.
______ ________ ___ ____ ________ ____ _______ ______ ________ __________.
________ _____ ________ _______ _________.
____ ______ __________ _____ _________.
_____ _____ ________ ______ _______.
_____ ____ _________ ________ ____ _________.
____ ________ ________ _________ ________ ___ _______ __________ ______ ___ _____ __________.
________ _______ __________ ____ ____ ____.
_______ ___ __________ __________ ____ _____ _________.
__________ ___ _____ ______ ____ ____ _________ _______ __________ ______ ___.
_____ ______ ________ _______ _______ _____.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.