Question

» EXCEL 2016
rumand minimi
Project 1: Dear students, apart from your regular school fees, your parents are investing a lot of their
hard earned money on your education. To be aware of this investment, visit your school
uniform shop and school book shop. Enquire about the price of the following items and
calculate the total amount.
B
FIRST DAY AT SCHOOL
S.No.
Particulars
Items
Quantity
Price
Amount
1
Shirts
2
Trousers/Skirts
2
2 3
Neck Tie
1
als First Name
Anu
12 Vijay
103 Preeti
104 Neeti
105 Ajay
1106 Soha
2107 Rohan
108 Bindu
109 Sheetal
1 110 Mohit
Raina
Sharr
Sahn
Verm
Goya
Ali
Gupt
Kum
Mar
Jain
School Uniform
4
Shoes
1
5
Socks
2
6
School Belt
1
7
Text Books
One Set
8
Note Books
15
Stationery and
Books
9
Stationery
One Set
10
School Bag
1
Sheet1
Accessories
Lunch Box
1
Water Bottle
1
> Format the spreadshee
calculate the Total by
Fillup the data in the 'R
Now type the cost of each item in 'Price' column and calculate the amount as per quantity, in the 'Amount' column.
Find the total of the calculated amount of all the items.
​

Answer 1

Answer:

okkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk