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 =ALLOWDEDU 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 msexcel 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
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.
No comments:
Post a Comment