How to calculate Employee Salary Sheet in Ms-excel ?

Ms-Office Practical Guides

In this section, we present the learning materials for your computer practical exam especially in Ms-Office. Most important, frequently asked Questions, Practical Guides, Practice Sets, and Tips & Tricks from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the practical exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's started to learn.

Ms-Access

Tips & Tricks

Multiple Choice Questions Sets

Here we presents the selected, Most important, frequently asked Multiple Choice Questions from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the written exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's Get started to learn.

I knew its hard to find the right question papers in internet from one website. But it's good to say here i collects questions papers sets that are previously asked from psc exams. These questions will be helpful for the final preparation of your exam. Let's start to expand your knowledge.

Here we have writes some sample practical paper sets for your exam. Try to solve these questions within time at home frequently. If you solve this within time you will cover almost every quetions in exam hall. These questions will be helpful for the final preparation of your exam. Let's start to practice.

In this section, we presents the learning materials for your Public Service Commission exam, bank exam, Nea exam, institutional exan etc. This section contains chapters with solutions, cources, or any thing that helps for your written exam, practical exam & interview based on curriculam. Let's start to prepare for your exam.

Asst. C.O.

Tutorials

Blogging & Wordpress Tutorials, Courses

In this place, you will find blogging tips, new strategies, and will teach you how to be a bogger with just the most basic computer skills. Everything you need to know to start blogging-we'll show you how step by step for blogging and wordpress. Let's Get started to learn.

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

Basic:-=IF(D3="PEON",7000,IF(D3="ACCT",14000,IF(D3="MNGR",18000,IF(D3="ADMN",22000))))

Allowance:- =IF(NOT(OR(D3="ADMN",D3="MNGR")),E3*15%,0)

Deductions:- =IF(D3="PEON",E3*1%,IF(OR(D3="MNGR",D3="ACCT"),E3*11%,IF(D3="ADMN",E3*15%)))

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.

Author Details