# 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 another Bill sheet of any store based on the conditions which will we calculate in ms excel sheet.
In the Bill sheet, you have seen that Item, Item Price, Quantity, Discount, and Net Amount which we calculate by inputting formula in the excel cell. Below are the conditions of the question based on that you will be writing a formula in the ms excel cell to the calculation.
 S.N Name Quantity(kg) Rate Amount Discount(10%) Net Amount 1 Apple 20 150 3000 300 2700 2 Lemon 30 120 3600 360 3240 3 Grapes 50 230 11500 1150 10350
Q.1 Calculate the Amount of the fruits item.
Q.2 At Special Occasions, Store discounts 10% on every item, Calculate the discount price and net amount of all items.
Q.3 Insert Bar chart of the above item to show item total price.
Solution:
Here I explain the basic mathematical computer practical question on ms-excel related to Bill Sheet of the store that is mostly asked for your competitive exam, entrance exam, bank exam, governmental exam, interview exam, public service commission exam.
I think that to solve this question, you have to write basic mathematical trick and again I suggest you compare the question condition with your natural language; then draw an algorithm like code for it to solve.
For e.g.
To calculate Total multiplying Quantity with Item Price.
Algorithm code as
Total=Quantity X Rate
After this now write the actual formula for it in your excel cell.
Below is the detailed solution of the above question, how to solve step by step.
Write the formula for the above questions.
Amount: -
=D3*E8
The above formula type in F3 Cell as you see in the figure below.
Discount (10%):-
=F3*20%
Type the above formula in G3 Cell which means to calculate by multiplying Total by 10% as the shown figure below.
Net Amount:-
=F3-G3
Type the above formula in H3 Cell by Subtracting Amount-Discount as shown figure below.
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.