Ms Excel Practical Question; How to calculate Bill Sheet of any store (Pasal) 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.

Wordpress

Intermediate

Consider the following Bill sheet of a company 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.

Priya Kirina Pasal
Khalanga, Darchula
Bill No. 100					Date: 2076/10/19
SN	Item Name	Item Price	Quantity no.	Total	Discount	Net Amount
1	Tube Light	500	100	50000	10000	40000
2	Torch Light	600	50	30000	6000	24000
3	LCD Monitor	1400	100	140000	28000	112000
4	Motherboard	8000	10	80000	16000	64000

Conditions:-
Q.1 Calculate the total price of the item.

Q.2 At Dashain Festival, Priya Kirana Pascal discounts 20% on every item, Calculate the discount price and net amount of the all item.

Q.3 Insert Bar chart of the above item to show item total price.
Solution:

Here I explain the basic mathematical 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 Item Price

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.

Total: -
=E8*D8
The above formula type in F8 Cell as you see in the figure below.

Discount:-
=F8*20%
Type the above formula in G8 Cell which means to calculate by multiplying Total by 20% as the shown figure below.
Net Amount:-
=F8-G8

Type the above formula in H8 Cell by multiplying Total-Discount as shown figure below.

Bill Sheet of any store (Pasal)

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