Public Service Commission Preparation & Blogging

Post Top Ad

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-Word

Practical Guides

Ms-Word

Asked Papers

Ms-Word

Practice Sets

Ms-Word

Tips & Tricks


Ms-Excel

Practical Guides

Ms-Excel

Asked Papers

Ms-Excel

Practice Sets

Ms-Excel

Tips & Tricks


Ms-Powerpoint

Practical Guides

Ms-Powerpoint

Asked Papers

Ms-Powerpoint

Practice Sets

Ms-Powerpoint

Tips & Tricks


Ms-Access

Practical Guides

Ms-Access

Asked Papers

Ms-Access

Practice Sets

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.


Ms-Word

MCQ Sets

Ms-Excel

MCQ Sets

Ms-Powerpoint

MCQ Sets

Ms-Access

MCQ Sets


HTML

MCQ Sets

Operating System

MCQ Sets



Interviews Preparations

The most important part of preparing for an Interview is practice. Preparation is the key to a successfull interview so take a look at Preparations Questions and Tips & Tricks how to answer them. Let's Get started to learn.


Interview Questions

Asked Before

Tips & Tricks

Based on Experience



Question Papers

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.


Section Officer

Asked Before

Computer Officer

Asked Papers

Nayab Subba

Asked Papers

Computer Operator

Asked Papers


Kharidar

Asked Papers

Asst. C.O.

Asked Papers



Modal Practice Paper Sets

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.


Section Officer

Modal Sets

Computer Officer

Asked Papers

Nayab Subba

Modal Sets

Computer Operator

Modal Sets


Kharidar

Modal Sets

Asst. C.O.

Modal Sets



Tutorials & Courses

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.


Section Officer

Tutorials

Computer Officer

Tutorials

Nayab Subba

Tutorials

Computer Operator

Tutorials


Kharidar

Tutorials

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.


Wordpress

Tips

Blogging

Tips

Wordpress

New Strategies

Blogging

New Strategies


Blogging

Make Money

Wordpress

Make money

Blogging

Guide

Wordpress

Guide


Blogging

For Beginners

Wordpress

For Beginners

Blogging

Tutorials

Wordpress

Tutorials


Wordpress

How to start?

Blogging

How to start?

Blogging

Intermediate

Wordpress

Intermediate


Post Top Ad

Consider the following salary sheet of a company based on the conditions which are as follows and which you calculate in your ms excel sheet. 
In the salary sheet, you have seen that Monthly Salary, Income Tax, Social Tax, Net pay field are already filled, but it is clear that this field value is calculated by you, I have just written for you. 
EmpCode
Name
Address
Monthly Salary
Income Tax
Social Tax
Net Salary
A001
Hari Sharma
Banepa
22500
3375
225
18900
A002
Ramita Gurung
Kathmandu
27000
4050
270
22680
A003
Anjana Giri
Bhaktapur
30000
6000
300
23700
A004
Sarita Ghimire
Sanga
20000
0
200
19800
Q.1 Calculate income tax as follows (Yearly Basis)
  • If the employee salary less than or equal to 250000, no income tax will be charged.
  • If the employee salary greater than 250000 and less than 350000, 15% income tax will be charged.
  • If the employee salary greater than or equal to 350000, 20% income tax will be charged.
Q.2 Calculate the social tax which is 1% of monthly salary.
Q.3 Calculate net salary as follows:-                      
Salary-(Income tax+Social Tax)
Solutions:
This question is asked frequently in competitive exams, entrance exams, bank exams, governmental exams, interview exams, public service commission exam or any other exam. 
I  suggest you some trick to solve this type of questions especially in case of "IF conditions" before in another Ms-excel conditions questions.
The trick is for the formula "how to write formula for IF Conditions" Let's start again as when you compare the question condition with your natural language. Write a question in your Language and convert it into an algorithm like code for it to solve. 
For e.g.
if you come after 10:00 a.m., you will be charged as 5% of your Salary. 
Algorithm code as
Let's you come after  10:00 a.m., then
If(Come Time>10, Salary-Salary*5%)
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 the formula for the
Income Tax: -
=IF(E5*12<=250000,0,IF(AND(E5*12>250000,E5*12<350000),E5*15%,IF(E5*12>=350000,E5*20%)))
The above formula type in F5 Cell as you see in the figure below.
Let's compare this question to the natural language so that we are able to write algorithm code then accurate formula.
First Condition

If the employee salary less than or equal to 250000, no income tax will be charged.
If Salary <=250000, income tax will be zero (0)
Second Condition
If the employee salary greater than 250000 and less than 350000, 15% income tax will be charged.
If Salary >250000 and <350000, income tax will be Salary*15%.
Third Condition
If the employee salary greater than or equal to 350000, 20% income tax will be charged.
If Salary >=350000, income tax will be Salary*20%.Ok, let's move on Social Tax which we calculate.
Social Tax: 
To calculate this cell you type the "=E5*1%" formula in G5 Cell. It's simple to calculate by multiplying the Monthly salary by 1%.
Net Salary: 
To calculate this cell you type the "=(E5-(F5+G5))" formula in G5 Cell. It's simple to calculate by Subtracting the Monthly from the Total Tax.

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

Post Top Ad