Creating opening and Basic Formatting a word document
EX NO:01 Name:
Date: Reg.no:
Aim
To Create Open and do basic Formatting in a word document
Procedure
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: To Open an Existing Document
Step 4: Click Open Choose the location where you have already saved the file.
Step 5: Choose the desired file and Click Open.
Step 6: To do basic formatting You can use the Font Tab.
1
Result:
Hence the Create, Open and basic Formatting in a word document is done
successfully.
2
Modifying Font, Text Alignment, Paragraph Indentation and Bullets and
numbering in aWord.
EX NO:02 Name:
Date: Reg.no:
Aim
To do Modifying Font, Text Alignment, Paragraph Indentation and Bullets and
numbering in a Word.
Procedure:
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: To Modify the font go to Home, and then select the Font dialog box launcher at
the bottom right corner of the Font group.
Step 4: Place the insertion point anywhere in the paragraph, document, or table that you
want to align and the use Paragraph dialog box to do Left, Right, Center, Justify
alignment. You can also use the short cut keys Ctrl+L, Ctrl+R, Ctrl+E, Ctrl+J.
Step 5: To insert Bullets and Numbering slect the list to be numbered or bulleted and
click → Bullet Icon in Paragraph dialog box.
3
Result:
Hence the Modifying Font, Text Alignment, Paragraph Indentation and Bullets and
numbering in a Word is done successfully.
4
Creating an advertisement
pamphlet
EX NO:03 Name:
Date: Reg.no:
Aim
To do create an advertisement pamphlet using word.
Procedure:
Step 1: Open Word.
Step 2: Select any desired templet that suits the advertisement.
Step 3: Then add the necessary content.
Step 4: Save the advertisement pamphlet.
5
Result:
Hence the advertisement pamphlet using word has been created.
6
Inserting Header and Footer
EX NO:04 Name:
Date: Reg.no:
Aim
To insert header and footer in a word document.
Procedure:
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: Click → Insert → Header.
Step 4: Click → Insert → Footer.
Step 5: Save the Word document.
7
Result:
Hence the Header and Footer for the word document is inserted successfully.
8
Inserting Page Breaks and Line Breaks
EX NO:05 Name:
Date: Reg.no:
Aim
To insert page breaks and line breaks in a word document.
Procedure:
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: Click → Layout → Breaks.
Step 4: Insert the Line Breaks and Page Breaks wherever necessary.
Step 5: Save the word Document.
Result:
Hence the line break and page break has been inserted successfully.
9
Create your class time table
EX NO:06 Name:
Date: Reg.no:
Aim:
To Create Your Class Time table.
Procedure:
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: Click Insert → Tables.
Step 4: Insert the desired number of Rows and Column.
Step 5: Edit the subject details in the table.
Step 6: Save the word document.
10
Result:
Hence the class time table has been created.
11
Create an Employee salary slip table using table setting and border options.
EX NO:07 Name:
Date: Reg.no
Aim:
To Create an Employee salary slip table using table setting and border options.
Procedure:
Step 1: Open Word.
Step 2: Select Blank document.
Step 3: Click Insert → Tables.
Step 4: Insert the desired number of Rows and Column.
Step 5: Edit the table with the salary details such as Basic Pay, HRA, DA, Tax
deductions, LOP, Incentives.
Step 6: click Layout tab to set the table alignment and border.
Step 6: Save the word document.
Result:
Hence the Salary slip for the employee has been created with the table setting and
borders.
12
Chart Types
EX NO:08 Name:
Date: Reg.no:
Aim:
To Show types of charts in excel
Procedure:
Step 1: Open Excel.
Step 2: Enter the data.
Step 3: Select the data you have entered.
Step 4: Click → Insert → Bar Graph.
Step 5: Click → Insert → Pie Chart.
Step 6: Save the worksheet.
Result: Hence various charts are inserted in excel.
13
Number Conversion in excel.
EX NO:09 Name:
Date: Reg.no:
Aim:
To Show types of charts in excel
Procedure:
Step 1: Open Excel.
Step 2: Insert the relevant data.
Step 3: Click Home tab → Number Drop down List.
Step 4: Choose the format you want.
Step 5: Save the Excel Sheet.
Result:
Hence the number conversion is done in excel.
14
Working with function pivot table and pivot charts.
EX NO:10 Name:
Date: Reg.no:
Aim:
To Show types of charts in excel
Procedure:
Step 1: Open Excel.
Step 2: Create a work sheet with monthly expenses date wise.
Step 3: Select the data click Insert → Pivot Chart.
Step 4: Click Insert → Pivot Chart.
Step 5: Select any desired type of chart.
Step 6: Save the Worksheet.
15
16
Result:
Hence the Pivot table and Pivot chart has been created successfully.
17
Data Validation and Consolidating
EX NO:11 Name:
Date: Reg.no:
Aim:
To do data validation and consolidation.
Procedure:
Step 1: Open Excel.
Step 2: Create a work sheet with the data need to be validated and consolidated.
Step 3: Select the data need to be validated.
Step 4: Click → Data → Data Validation.
Step 5: Give the Range of validation.
Step 6: Select the data need to be consolidated.
Step 7: Select the cell reference for consolidation.
Step 8: Save the Worksheet.
18
Result:
Hence the Data validation and consolidation has been done successfully.
19
Sorting table in excel.
EX NO:12 Name:
Date: Reg.no:
Aim:
To sort a table in excel.
Procedure:
Step 1: Open Excel.
Step 2: Create a work sheet with the Employee Name List.
Step 3: Click Sort and Filter.
Step 4: Select custom sort and sort the list by E_NAME.
Step 5: Save the Worksheet.
20
Result:
Hence the Sorting an excel sheet is done successfully.
21
Preparing a power point presentation by inserting pictures, smart art and word art
EX NO:13 Name:
Date: Reg.no:
AIM: To create a power point presentation by applying various designs, images, shapes and
smart art and word art.
Procedure
INSERTING PICTURES
1. In an opening power point presentation, click File > New
2. From the design menu select a design for your PPT as per your choice.
3. Select insert menu from the tool bar.
4. Select the Picture option. Click pictures from insert menu.
5. Click the insert tab after selecting the picture.
6. Place the image at the desired location.
INSERTING WORD ART
1. Go to Insert > WordArt
2. Pick the WordArt style you want.
3. Type your text.
INSERTING SHAPES
1. Go to Insert > Shapes
2. Pick the Shape you want.
3. Draw the shape at the desired location.
22
INSERTING SMART ART
1. Go to Insert > SmartArt
2. Pick the WordArt style you want from the dialogue box and click OK button.
3. Type your text as per the requirement.
OUTPUT
RESULT: Thus the Power point presentation creation were performed successfully by inserting
images, word art, smart art, shapes and the output was verified.
23
Preparing a power point presentation using transitions and animations
EX NO:14 Name:
Date: Reg.no:
Procedure
AIM: To create a power point presentation by applying various transitions and animations.
APPLYING TRANSITION TO SLIDES
1. Open a blank presentation by selecting File -> new
2. From the design menu select a design for your PPT as per your choice.
3. Based on the given topic, create the contents of the slides.
4. Select the slide and on which you want to apply the transition.
5. Click on transition menu and select the desired transition style (ex – cut, fade, push,
wipe)
APPLYING ANIMATIONS TO THE TEXTS
1. Select the text on which you want to apply the animation.
2. Click on the animation menu and select the desired animation style (ex- fade, fly in, split,
wipe).
OUTPUT
Result - Thus the power point presentation were performed successfully by applying various
transition and animations to the slides and the output was verified.
24
Preparing a power point presentation by inserting charts of various types
EX NO:15 Name:
Date: Reg.no:
Procedure
AIM: To create a power point presentation by inserting charts of various types
INSERTING PICTURES
1. In an opening power point presentation, click File > New
2. From the design menu select a design for your PPT as per your choice.
3. Go to Insert > Chart
4. Pick the chart style you want.
5. Type your data in the excel sheet.
25
OUTPUT
RESULT - Thus the power point presentation for creating charts were performed successfully
by applying the data into the excel sheet and the output was verified.
26
27
