# PSC HELPER

Public Service Commission Preparation & Blogging

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

## Interviews Preparations

### Tips & Tricks

Based on Experience

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tips

Tips

New Strategies

New Strategies

Make Money

Make money

Guide

Guide

For Beginners

For Beginners

Tutorials

Tutorials

How to start?

How to start?

Intermediate

Intermediate

## Post Top Ad

Below is the question about calculating the salary sheet of a company based on the conditions which are as follows and which you calculate in your excel sheet. In the salary sheet, you have seen that Basic, Allowance, Deductions, Net pay field are already filled, but it is clear that this field value is calculated by you, I have just written for you.Â
Conditions:-
• Configure DESIG column in such a way that it cannot store more than 4 characters. The probable values for DESIG are ADMN, MNGR, ACCT & PEON
• Create a formula for BASIC so that it is, RS. 7000 for PEON, Rs. 14000 for ACCT, Rs. 18000 for MNGR, Rs. 22000 for ADMN
• ALLOWANCE will be 15% of BASIC if he/she is not ADMIN or MNGR
• DEDUCTIONS will be 1% of BASIC for PEON and 11% for MNGR and ACCT. For ADMN deduct 15% of BASIC
• Create range names so that you can type =ALLOW-DEDU as the formula for NET PAY column
 Salary Sheet ENO ENAME DESIG BASIC ALLOWANCE DEDUCTIONS NET PAY 1001 Mohan Bhatt ADMN 22000 0 3300 18700 1002 Pritam Bhatt MNGR 18000 0 1980 16020 1003 Sonam Chand ACCT 14000 2100 1540 10360 1004 Rahul Malhotra PEON 7000 1050 70 5880 1005 Poonam Khatun ADMN 22000 0 3300 18700 1006 Anamika Bhatt MNGR 18000 0 1980 16020
Solution:
Here I present the ms-excel practical questions for your competitive exam, entrance exam, bank exam, governmental exam, interview exam, public service commission exam or any other exam where basic computer practical exam be taken.
This questionÂ is most important which is asked mostly in exams. But this question is so easy can be calculated within the time in your exam if you are concentrate.Â
I think that to solve this question, just compare the question condition with your natural language; then draw an algorithmÂ like codeÂ for it to solve.Â
For e.g.
if today is Sunday, you will be discounted by 10% on every purchase,Â
Algorithm code as
Let you purchase x, then
If(today=sunday, x*10%)
After this now write the actual formula for it in your excel cell.
If you use this for all the conditions, you sure write the right formula for this question as well as for other questions also. Practice questions by writing theÂ first algorithm then convert it into the right formula. If you did this, you sure complete this question in your job exam.

Below is the detailed solution to the above question, how to solve step by step.
Write formulla for the
Net Pay:-Â =E3-ALLOW-DEDUCTION

If you have any queries, related to this question, ask me in the comment section without any hesitation. I would like to say thank you if this post is helpful for you or if I solve your problem through this question.