Lab Index - Grade XI

Lab -1 Lab -2 Lab -3 Lab -4 Lab-5
Lab -6 Lab -7 Lab -8 Lab -9 Lab-10
Lab -11 Lab -12 Lab -13 Lab -14 Lab-15
Lab -16 Lab -17 Lab -18 Lab -19 Lab-20
Lab -21 Lab -22 Lab -23 Lab -24 Lab-25
Lab -26 Lab -27 Lab -28 Lab -29 Lab-30
Lab -31 Lab -32 Lab -33 Lab -34 Lab-
Lab No. 5
Date:

Lab Task:

[Word] Create a mail merge to send a letter to multiple friends.

PROCEDURE TO CREATE MAIL MERGE

1. Type the followig letter in MS Word

Date: 17 July 2018 To NAME ADDRESS Dear Sir / Madam Subject: Interview letter for the post of POST You are hereby informed to attend the interview for the post of POST 27 July 2018 by sharp 10 : 00 AM at company office ,Kathmandu . Bring all the documents and original transcript and citizenship card without fail. xyz Director 2. Make the following table in MS Excel

Name Address Post
Abdul Wahid Thahity Admin Manager
Rojee Khatri Lamjung Chief Accountant
Ankit Khatiwada Birgunj IT Officer
3. Click on Mailings
4. Select the data source (above table)
5. Insert the required Fileds
6. Click on Finish
Goto Top
Lab No. 6
Date:

Lab Task:

[Word] Create grade sheet
Goto Top
Lab No. 7
Date: 2079/05/29

Lab Task:

[Word] Make a front page of your lab report.

Word Sample Report with cover page and title page
Goto Top
Lab No. 13
Date: 2078-09-21

Lab Task:

[Excel] Make a mark-sheet
A B C D E F G H I J K L M N O
1 ABC College
2 KATHMANDU
3 SN Name Grade Eng Nep Soc Acc Eco Comp Total % Result Div Remarks Rank
4 1 abc-1 G1 50 50 50 50 50 50 ? ? ? ? ? ?

(a) Calculate total, percentage. Ans: =SUM(D4:I4) =ROUND((J4*100/600),2) (b) Calculate result, pass marks is 40 in each subject. Ans: =IF(MIN(D4:I4)>=40,"PASS","FAIL") (c) For division,Distinction >=80%, First >=60% , Second >=50% and third >=40%, otherwise '-'.

=IF(AND(L1="PASS",K4>=80),"DISTINCTION",IF(AND(L4="PASS",K4>=60),"FIRST",IF(AND(L4="PASS",K4>=50),"SECOND",IF(AND(L4="PASS",K4>=40),"THIRD","-"))))
(d) For remarks,Distinction= Excellent, First div = Very Good , Second div = Good , Third div = Fair , Otherwise Work Hard.
=IF(M4="DISTINCTION","EXCELLENT",IF(M4="FIRST","V.GOOD",IF(M4="SECOND","GOOD",IF(M4="THIRD","FAIR","WORK HARD"))))
(e) For rank, use the rank() function. Ans: IF(MIN(D4:I4)>=40,RANK(J4,$J$4:$J$5)," ")

Goto Top
Lab No. 14
Date: 2078-09-22

Lab Task:

[Excel] Make a salary sheet
A B C D E F G H I J K L
1 NEPAL WATER SUPPLY CORPORATION
2 CENTRAL OFFICE,TRIPURESHWOR
3 KATHMANDU
4 SN Name Address Post Basic
Salary		 HRA TADA MA Total
Salary		 PF Tax Net
Salary
5 1 abc1 KTM GM 50000 ? ? ? ? ? ? ?
6 2 abc2 Dharan MD 45000 ? ? ? ? ? ? ?
7 3 abc3 Butwal Officer 40000 ? ? ? ? ? ? ?
8 4 abc4 KTM Accountant 35000 ? ? ? ? ? ? ?
9 5 abc5 Sindhuli Driver 25000 ? ? ? ? ? ? ?

(a) House Rent Allowance (HRA), if address is KTM then 0, otherwise 10% of Basic Salary. Ans: =IF(C5="KTM",0,E5*10%) (b) Travelling Allowance - Dearness Allowance (TADA),7% of Basic Salary. Ans: = E5*7% (c) Medical Allowance (MA),5% of Basic Salary. Ans: = E5*5% (d) Find Total Salary. Ans: = E5+F5+G5+H5 (e) Provident Fund (PF),10% of Basic Salary. Ans: = E5*10% (f) Income tax : 8% of Basic Salary for General Manager(GM), 6% of Basic Salary for Managing Director(MD) and 5% for others. Ans: =IF(D5="GM",E5*8%,IF(D5="MD",E5*6%,E5*4%)) (g) Calculate Net Salary. Ans: = I5-J-K5


Goto Top