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

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:
=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:
=F8G8
Type the above formula in H8 Cell by multiplying TotalDiscount as shown figure below.
Solution:
Here I explain the basic mathematical question on msexcel 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:=E8*D8
The above formula type in F8 Cell as you see in the figure below.
=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:
=F8G8
Type the above formula in H8 Cell by multiplying TotalDiscount 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.
No comments:
Post a Comment