# 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

## Blogging & Wordpress Tutorials, Courses

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

### Wordpress

Intermediate

Consider the following Bill information of an office and write the formula asked.
Write a formula to calculate the Taxable for every store.
Write a formula to calculate the Net Pay for every employee.
Write a formula to find the total amount, Total of Net Pay and Total of 1% Tax of all stores.

1% Taxable:
Displays "Yes", If the amount is greater than 5000, otherwise Display "No"
Net Pay:
if Taxable is Yes, then Calculate Net Pay as 1% of Amount,
Net Pay:- Amount-Amount*1%.

Solution:-
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.
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.
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.

Type the formula in the related cell step by step as shown in Figure Below.
In the F5 cell, type the below formula to display yes or no,
Tax: =IF(E5>5000,"Y","N")
In the G5 cell, type the below formula to calculate Net Pay.
Net Pay: =IF(F5="Y",E5-E5*1%,E5)
In the G8, G9 and G10 cells, respectively; type the below formula to calculate Total Amount, Total Net Pay and Total Tax.
Total Amount: =SUM(E5:E7)
Total Net Pay: =SUM(G5:G7)
Total Tax: =(E5+E7)*1%

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.