Ex.No:1.
Date :
CREATING ADVERTISEMENT
AIM:
To prepare an advertisement for a company with some specifications.
Attractive page border.
Use at least one Clip Art.
Design name using Word Art.
Use bullets.
ALGORITHM:
Step 1: Open a blank document.
Step 2: Go to Page LayoutPage BordersSelect Attractive Page
BorderOk
Step 3: Go to InsertText box click it and draw it in a document. Then type
text.
Step 4: Go to InsertShapesSelect a shape and draw it. Then Right Click
select
Add Text to add a text into the shapes.
Step 5: Type a name and selectgo to insertWord ArtSelect a Word Art &
Click.
Step 3: Go to InsertClip ArtSelect Attractive Clip ArtOk.
Step 5: Type a brief college details & Right ClickSelect the Bullets Ok.
Step 6: Save the document.
RESULT:
Thus the advertisement has been created with some specifications in
Microsoft word successfully and verified.
Ex.No:1.2
Date :
CREATING TIME TABLE & CONVERSION
AIM:
To prepare a class timetable using Merge rows, Split row, Insert rows -
columns etc and convert the table into text format.
ALGORITHM:
Step1: Open a blank document.
Step 2: InsertTableInsert TableSelect No of rows & columnsOk.
Step 3: Select two cells Right click Merge Cells.
Select one cell Right clickSplit Cell
Select one row Right click InsertInsert One row above or below
Select one column Right click InsertInsert One column left or right
Step 4: Type a Class Timetable with Headings
Step 5: Go to LayoutConvert to textSelect Tabs Ok
Step 6: Save the document as Table and Text Format
RESULT:
Thus the class time table has been created & table is converted into text in
Microsoft word successfully and verified.
Ex.No:1.3
Date :
SCIENTIFIC NOTATIONS
AIM:
To create a MS-WORD document for the following scientific notation
i. A= + + +
ii. +
iii.
iv.
v. +7 4 +6 o
ALGORITHM:
Step 1: Open a blank document.
Step 2: Go to InsertEquationInsert EquationSelect the specific format.
For eg , for , ..
Step 3: Select for
Step 4: Select for
Step 5: Save the document.
RESULT:
Thus the scientific notations has been created in Microsoft word
successfully and verified.
Ex.No:1.4
Date :
MAIL MERGE & LETTER PREPARATION
AIM:-
To create a WORD document to call letters for an interview using Mail
Merge send to10 candidates
ALGORITHM:-
STEP 1: Open a blank document
STEP 2: Goto Mailings in Menu Start Mail merge Letters
STEP 3: Type a interview call letter with FROM address and leave
some
Space for TO address
STEP 4: Goto Select recipients Type a new list Customize the
Columns Ok
STEP 5: Type a 10 address new some fieldsOksave it
STEP 6: Goto Select recipients Use Existing list open a
fileOk
STEP 7: Under the TO Address insert the Merge fields & preview the
results
STEP 8: Goto Finish MergeEdit individual Documents All
Ok
STEP 9: Save the document
RESULT:
Thus the Mail Merge has been created in Microsoft word successfully and
verified.
Ex.No:1.5
Date : DRAWING FLOW CHART
AIM:-
To create a flowchart in WORD to find the greatest of three numbers
ALGORITHM:-
STEP 1: Open a blank document
STEP 2: Go to Insert shapesFlowchart
STEP 3: Insert the Correct shapes for Input box, decision box
Calculation box and Output box
STEP 4: Select the box and Right Click Add Text
STEP 5: Use Arrows for Link
STEP 6: Save the document
RESULT:
Thus the flowchart in WORD to find the greatest of three numbers has
been created in Microsoft word successfully and verified.
PRESENTATION AND VISUALIZATION-GRAPHS,CHARTS,2D,3D
EX.NO:2.1
Date :
AIM:
To create difference charts in MS-Excel for the given data
PROCEDURE:
Step1: click start Program MS-Excel
Step2: Enter the data in the worksheet as shown choose chart option from insert menu or
choose the chart wizard button from the standard tool bar.
Step3: Choose the appropriate chart from the chart type list box and then click next.
Step4: Select the chart sources from the worksheet and then click next.
Step5: Give the suitable title and select the location of chart and then the chart is displayed on
screen.
RESULT:
Thus the presentation and visualization for graphs, charts in 2D and 3D in
EXCEL has been created in Microsoft word successfully and verified.
EX.NO: 2.2
Date :
FORMULA EDITOR
AIM:
To analyse the marks, total, average and result of students using formula editor.
PROCEDURE:
Step1: Click start, go to All Programs, select MS-office and choose MS-Excel.
Step2: Enter the students name and marks.
Step3: Place the cursor in G2 and type =sum (B2+C2+D2+E2+F2)
Step4: Place the cursor in H2 and type =Average (B2:F2)
Step5: Place the cursor in I2 and type =IF/AND (B2>40, C2>40, D2>40, E2>40, F2>40),
PASS, FAIL)
Step6: Now drag the formula for other students to know their total, average and result.
RESULT:
Thus the analyse the marks, total, average and result of students using formula editor
in EXCEL has been created in Microsoft word successfully and verified.
EX.NO.2.3 SORTING, IMPORT AND EXPORT DATA
Date :
AIM:
To sort the given data, to import and to export the data.
PROCEDURE:
Step1: Open MS-Excel, go to data menu
Step2: Choose Form option.
Step2: Click the new button in the Form option to add the rows to list.
Step3: After adding the rows place the cursor in the list in worksheet.
Step4: Click Data and then Sort, the Sort dialog box will appear on the screen.
Step5: In the Sort by drop down list box, select the category and click ok.
Step6: Again in Sort, click the next column from the list box.
Step7: Click Data menu, then go to Filter option and select Auto filter, it shows an arrow at
each field.
Step8: The list of rows which belong to each category is displayed.
IMPORT THE DATA:
Step1: Open MS-Access, create a blank database and save it.
Step2: Type the necessary data in the column by clicking the option.
Step2: In the database open file, go to External data and then choose Import.
Step3: Change the file type to MS-excel.
Step4: Enter the file name.
Step5: Thus, the data will be imported.
EXPORT THE DATA:
Step1: Click Start, go to All Programs, Select MS Access.
Step2: Open MS-Access, create a blank database and save it.
Step3: Type the necessary data in the column by clicking the option.
Step4: Add data to the table and save it.
Step5: Go to file menu, choose export and give file name to which the data must be exported
and check whether the save as type is in MS-Excel.
Step 6: Click Export all and check whether the data is exported.
RESULT:
Thus the sort the given data, to import and to export the data in EXCEL has been
created in Microsoft word successfully and verified.
EX.NO:3.1 POWERPOINT PRESENTATION
Date :
AIM:
To create a presentation in MS-PowerPoint.
PROCEDURE:
Step1: Click start, go to Program, then select MS-office, and choose MS-PowerPoint.
Step2: Open a new PowerPoint (PPT) Presentation and Save the file as your-name.pptx.
Step3: To Insert text box Click on Insert Tab and then choose Text Box option in Link Tab.
Step4: Add the text PowerPoint Lab Exercises in the inserted text box and change the font
size, fill color , change text color, font style, click insert and go to picture, then choose
Clip Art
Step5: Insert a new slide and then insert a picture from insert menu, choose picture and go to
From file option and choose any picture from Sample Picture.
Step6: To change Background color, go to Format menu, select Background, choose Fill
Effects and then add effect by clicking Apply button.
Step7: Insert a new slide and then choose Insert tab and go to Chart option, choose any kind
of chart and display it on slide.
Step8: Add color and effect to the chart and display the presentation.
RESULT:
Thus the create a presentation in MS-PowerPoint has been created in
Microsoft word successfully and verified.
