Note: Use VLOOKUP FUNCTION FOR THE PROJECT
- invoice no.
- customer name field
- columns [sn | Items/Particulars | Quantity | price | Amount ]
- Total sum, Discount (if total is greater than 10000 then 3%), tax rate (1.5% in total sum), Net amount.
- write down all the formula that is required for prepare the Bill.
2. Prepare result for Shree Adarsha Yuva School, Satdobato, lalitpur, Contact no: 01525222 with including following details:
- student name, roll no, Subjects(XI Science), Total marks Obtain, percentage, rank, result(pass or fail), Division, remarks,
- write down all the formula that is required for prepare the result.
- at the heading of the result place details of school
- and highest marks obtain in every subject at the top of every subjects heading.
3. Prepare the salary sheet with given details:
- Salary sheet of ABC PVT. LTD.
- include columns (sn. Full Name, POST, B. Salary, Grade, City, M.ST, Travel, TA/DA, MA, CA, HRA, GA, PF, Total, TAX, Net Salary)
note: take a reference of a course book.
0 Comments