IT Skills Lab 1
Subject Code: KMBN 151
PRACTICAL FILE
(SESSION 2023- 2025)
Submitted to: Submitted by:
Ms. Neha Sabharwal Shantanu Sharma (A)
(Assistant Professor-IT) Semester 1st
INSTITUTE OF TECHNOLOGY & SCIENCE, GHAZIABAD
GT Road, Mohan Nagar, Ghaziabad-201007
www.its.edu.in
1
Table Of Contents
S.No. Topic Page No. Date Sign
1. Mail Merge 03-07 20.11.23
2. Creating Magazine in MS Word 08-13 20.11.23
3. PowerPoint Presentation 14-19 24.11.23
4. Basic Functions In Excel 20-23 13.12.23
5. Operations In Excel 24 13.12.23
6. IF Function In Excel 25 15.12.23
7. Lookup Function In Excel 26-27 20.12.23
8. Vlookup Function In Excel 27-28 20.12.23
9. Sumifs Function In Excel 28-29 26.12.23
10. Text Function In Excel 30-35 28.12.23
2
Step 1: click on the Mailings tab in the word ribbon.
Step 2: click on Start Mail Merge. now go to the option Step by step mail merge wizard.
3
Step 3: select the type of document Letter.
Step 4: select starting document Use the current document.
4
Step 5: Click on Select Recipients and choose Type a new list.
Step 6: Click on Create then click on Customize Columns and type the recipient information.
5
Step 7: Click on More items now click on Database Fields to add personalized fields like First name,
Last name or any other details you have in your data source.
Step 8: Click on Preview Results to see how your document will look for each recipient
6
Step 9: Click on Finish & Merge. Choose Print Documents. Click OK to complete the merge.
7
Step 2: colors the shapes.
8
Step 3: click on Insert go to Picture.
Step 4: Click on Format.
9
Step 5: Go to insert and click on Add text.
Step 6: Go to the Page layout and then click on Postion for text wrapping.
10
Step 7: Click on “Home” do font and change colour of font.
Step 8: Go to Format tab and do shape fill.
11
Magazine second page
Step 1: Click on Page Layout then click on Margins.
Step 2: Insert text and Click on “Columns”.
12
Step 3: Click on “Picture” and insert picture.
Step 4: Select text and click on “Drop Cap”.
13
14
15
16
17
18
19
20
Step 3: Use Sum function for Total salary paid and use Max function for Maximum.
21
Step 6: Go to Home change colour,font and size of header.
22
Step 7: To find interest in use formula =C43+D43*D40 and to find “Ending balance” use formula
=C43+D43+E43
23
Step 2: To find out Markup use formula =C22$D$20 then drag down.
To find out Discount use formula =C22$E$20 then drag down.
24
Step 2: Apply IF Function =IF(C12>$G$19,”good”, “bad”).
25
LOOKUP FUNCTION
Step 1: To find out Sales use HLOOKUP function.
26
VLOOKUP
Step 1: To find Close, TOTTRDQTY, Open use the VLOOKUP.
27
Step 2: To remove Non EQ rows,first go to Sort & Filter then sort the data on the basis of
TOTTRRDVAL.
SUMIFS
Step 1: To find out sales of all Maruti Cars ,sales of all Auto Transmission , sales of all 1200cc cars and
Sales of all Eco cars Use SUMIF.
28
Step 2: Use COUNTIF for number of Petrol Cars and Eco cars.
Use SUMIFS for sales of all Maruti Petrol cars and sales of Tata & Manual cars.
Use COUNTIFS for count of all Eco & 1000cc cars.
29
TEXT FUNCTION
Step 1: Use LEN function for find the length of sentence.
Use FIND function for find the comma.
Step 2: Use LEFT function for find text on left of comma.
30
Step 3: Use MID function for find 10 character after comma.
Step 4: Use PROPER to converts text string to proper case.
31
32
Step 7: Use LOWER function to convert all text in small alphabets.
Step 8: Use UPPER function to convert all text in capital.
33
Step 9: Use TRIM & UPPER for remove the space from text with capital letter.
Step 10: Use SUBSTITUTE for replace exciting text with new text.
34
35
