Saradha Gangadharan College Page No.

TEXT MANIPULATION & FORMATTING

1.0 AIM:
To Format the text and to manipulate the following in a document.
•Moving and copying the text.
•Insert and delete the text.
•Align the text.
•Change the font style and size.

2.0 PROCEDURE:
Step 1: Click on File -> New from the Menu Box.
Step 2: A Blank Document opens with the insertion pointers in the work area.
Step 3: Type the required text in the New Document.
TEXT MANIPULATION:
Step 4: First select the text which is to be moved then.
Step 5: Place the insertion point in the specific place and select Edit -> Paste or click the Paste icon from Standard Toolbar press CTRL+V
TO COPY TEXT:
Step 6: First select the text, which has to be copied, then select Edit  Copy or click on the Copy icon from the Standard Tool Bar press CT
Step 7: Place the insertion point in the specific place and select Edit  Paste or click on the Paste icon from the Standard Toolbar press CTR
TO INSERT AND DELETE TEXT:
Step 8: Move the insertion pointers where it has table inserted press Insert Key and type the required text.
Step 9: Place the insertion pointer on which the text has to be erased press Backspace or Delete key.
TEXT FORMATTING:
Change Font Style and Size of the text:

* Department of Commerce *
 Saradha Gangadharan College Page No.

t the text to change. To change the font style on format font in the font Dialog Box selected the desired Font Size and Style.
ck on the down arrow next to the first drop down box and font size drop down box. Then click on the desired font and desired font size.
AND ITALIC:
old face select the text and press CTRL+B or click B icon.
alic select the text and press CTRL+I or click I icon.
nderline select the text and press CTRL+U or click U icon.

ct the Text or Paragraph click on Format Paragraph select Indent and Space Tabs.
on the alignment drop down list, choose the application table, Justification, Style, from the list and click Ok.
se the keyboard shortcut follows:
lect the text press CTRL+V.
select the text or paragraph press CTRL+C.
lect the text or paragraph CTRL+I.
n Format or Paragraph, select Indent and spacing tabs to change the Margins.
t a Margin, select on File Page Setup. In the page set up dialogue box. Change the top button left, and right margins.
ve the document select File -> Save.

rotected and so is agriculture and its giving a peaceful life but such cases it will be acting very rude, because our careless and indiscipline a
ION:
use our careless and indiscipline activities of nature):
ust be protected and so is agriculture and its giving a peaceful life but such cases it will be acting very rude.

* Department of Commerce *
 Saradha Gangadharan College Page No.

AFTER COPY:
Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will
be acting very rude, because our careless and indiscipline activities of nature.
AFTER PASTE:
Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will be
acting very rude.

TEXT FORMATING:
BOLD:
Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will be
acting very rude.
ITALIC:
Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will be
acting very rude.
UNDERLINE:
Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will be
acting very rude.

CHANGING FONT STYLE AND SIZE:

Nature must be protected and so is agriculture and its giving a peaceful life but such cases it will be
acting very rude.
ALIGNMENT:
With an internet connection and Internet Explorer, you can find and view information about
Anything on the web. Just click the topics below to get started. You’ll find more information
To help you browse the Internet in the Help Contents.
RIGHT ALIGNMENT:
With an internet connection and Internet Explorer, you can find and view information about
Anything on the web. Just click the topics below to get started. You’ll find more information
to help you browse the Internet in the Help Contents

* Department of Commerce *
 Saradha Gangadharan College Page No.

LEFT ALIGNMENT:
With an internet connection and Internet Explorer, you can find and view information about
Anything on the web. Just click the topics below to get started. You’ll find more information
to help you browse the Internet in the Help Contents.
CENTER ALIGNMENT:
With an internet connection and Internet Explorer, you can find and view information about
Anything on the web. Just click the topics below to get started. You’ll find more information
to help you browse the Internet in the Help Contents.
JUSTIFY:
With an internet connection and Internet Explorer, you can find and view information about
Anything on the web. Just click the topics below to get started. You’ll find more information
to help you browse the Internet in the Help Contents.

4.0. RESULT:
The above procedure has been executed successfully and output was verified.

* Department of Commerce *
 Saradha Gangadharan College Page No.

TABLE MANIPULATION
1.0 AIM:
To Prepare a Student Mark List in Table format using MS-WORD.
2.0 PROCEDURE:

Step 1: From File menu, select New to create a New Document.

Step 2: Move the insertion point where you want the table.
Step 3: Select Table Insert Table, the insert table dialog box appears.
Step 4: In the numbers of row and columns boxes click on the arrows or enter the no of rows and column the table should have.
he insert, table button and drag the mouse pointer out and down until you have selected the desire number of rows and column. After you re
Step 6: Enter the heading, Name of the student and their marks.
Step 7: To move to the next cell, press TAB, to move to the previous cell, press SHIFT+TAB
Step 8: To find the total and average marks of the student, select the table formula and enter the formula.
Step 9: To apply different style for a table, click Table Auto Format from the dialogue box chooses any style and click OK.

* Department of Commerce *
 Saradha Gangadharan College Page No.

3.0 OUTPUT: STUDENT MARK LIST

To apply different style for the table: by using Table Auto Format
NAME TAMIL ENGLISH MATHS SCIENCE SOCIAL TOTAL AVERAGE
ANUMAN 96 97 100 96 100 489 97.5
HEMA 56 65 85 98 78 382 76.4
RAM 92 87 65 67 98 409 81.8
SITA 97 54 82 72 84 389 77.8
VINAYAK 61 64 97 92 64 378 75.6

NAME TAMIL ENGLISH MATHS SCIENCE SOCIAL TOTAL AVERAGE

ANUMAN 96 97 100 96 100 489 97.5

HEMA 56 65 85 98 78 382 76.4

M 92 87 65 67 98 409 81.8
SITA 97 54 82 72 84 389 77.8
VINAYAK 61 64 97 92 64 378 75.6

4.0. RESULT:
The above procedure has been executed successfully and output was verified.

* Department of Commerce *
 Saradha Gangadharan College Page No.

MAIL MERGE

1.0 AIM:
To Create a Mail Merge document in MS-WORD.
2.0 PROCEDURE:
Step 1: Enter the message that you want to send for many persons and leave blank space for
TO Address and Save the document.
Step 2: Select Tool  Mail Merge, the Mail Merge helper Dialogue box appears.
Step 3: Click the Create button word. Open a list chosen from letters.
Step 4: In the information box choose active window if you have already opened the letter
that you want merge.
Step 5: Click on the get data button and select data source from the list.
Step 6: In create data source dialog box remove any Field Name that you want to use in Field
Name in Headers row and List box.
Step 7: Type a appropriate name in the File Name, type in the field.
Step 8: Type a appropriate name in the File Name text box click OK.
Step 9: In the mail merge dialog box choose Edit  Data, source in data from dialog box,
Enter record and click and New after finished click OK.
Step 10: Place the insertion point where to Insert the Merge.
Step 11: Select and click the merge field from the list that appears, Save the document.
Step 12: Click Mail Merge icon, that merged document appears on the screen.

* Department of Commerce *
 Saradha Gangadharan College Page No.

3.0 OUTPUT:

CREATION OF ADDRESS LIST:

* Department of Commerce *
 Saradha Gangadharan College Page No.

BEFORE MERGING:

FROM
The Principal,
Saradha Gangadharan College,
Lake Road, Velrampet,
Puducherry-605004.

TO
«Name»
«Address»
«City»

Dear,
You have been called for an Interview for the Post of Assistant Professor
on (04/06/2020) at 11.30A.M, Venue: SGC.

Principal

* Department of Commerce *
 Saradha Gangadharan College Page No.

AFTER MERGING:

FROM
The Principal,
Saradha Gangadharan College,
Lake Road, Velrampet,
Puducherry-605004.

TO
Veena
No. 34, Nehru Nagar
Chennai

Dear,
You have been called for an Interview for the Post of Assistant Professor
On (04/06/2020) at 11.30A.M, Venue: SGC.

Principal

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
 Saradha Gangadharan College Page No.

DATA SORTING & GRAPH

1.0 AIM:
To Create a Worksheet and to Sort the records by both Ascending and Descending Order and
Creating Graph and Chart in a Worksheet and to Display Data on it.

2.0 PROCEDURE:
Step 1: To Create New Worksheet using File  New or by clicking on CTRL+N and enter the
Records.
Step 2: Select the Range of cells, which are to be arranged.
Step 3: Click Sort Ascending icon in the Standard toolbar to arrange the records from the lowest to
highest order
Step 4: Click Sort Descending icon in the Standard toolbar to arrange the records from the Highest
to lowest order.
Step 5: To Sort Multiple records at a time click Data Sort from the menu bar and choose either
Ascending or descending and enter the Records.
CREATING GRAPH:
Step 6 : Create a Data that is required to draw a Graph in new worksheet.
Step 7 : To create a Chart click Insert and choose Chart Wizard Button.
Step 8 : Select the Type Chart that you needed.
Step 9 : Choose the data range to be displayed in the chart.
Step 10: You can also create title and logos.
Step 11: Click Finish to Apply the new format to your chart data.

* Department of Commerce *
 Saradha Gangadharan College Page No.

OUTPUT:
DATA BEFORE SORTING

DATA AFTER SORTING

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
 Saradha Gangadharan College Page No.

DATA FILTERING, VALIDATION & SUBTOTALS

1.0 AIM:
To Filter Records, apply Validation and create Subtotals in a worksheet.

2.0 PROCEDURE:

FILTERING
Step 1: Create a New Worksheet using File New menu and enter the data.
Step 2: Filters are used to list of only the data, which meet certain condition.
Step 3: Select the entire table including column heading and rows.
Step 4: Choose Auto Filter Command from the Filter option from the Data menu.
Step 5: The drop column list button begins show again each column heading.
Step 6: Using these button we can apply various condition and get the desired output.
Step 7: We can get back the original record by selecting “All” option from the list.

VALIDATION
Step 8: This option defines what data is valid for individual cells or cells range.
Step 9: To apply Validation in your table, choose Validation from the Data menu.
Step 10: It restricts the data entry for to a particular type such as whole number decimal number
or text.
Step 11: You can limits on your text length or values entries.
Step 12: If you enter an invalid type or data, error message will be displayed.

SUBTOTALS
Step 13: This option calculates Subtotals and Grand total value for the able column we selected.
Step 14: Select cells, which we want to, create Subtotals.
Step 15: Click Data Subtotals to display the subtotals dialog box.
Step 16: Specify a column for each range using the drop down arrow button and click OK
Step 17: Subtotal will be inserted into your worksheet for the rest of the column each time this
Value Changes.

* Department of Commerce *
Saradha Gangadharan College Page No.

3.0. OUTPUT:
FILTERING
ORIGINAL TABLE

FILTERING BY “PRICE LESS THAN 25,000”

FILTERING”MORE SOLD ITEMS THAN 50”

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
 Saradha Gangadharan College Page No.

MARKSHEET PREPARATION

1.0 AIM:
To Prepare a Mark List using Built In Function in MS-EXCEL.

2.0 PROCEDURE:
Step 1: Enter into Ms-excel, select File menu and click New to create a New Worksheet.
Step 2: Enter the Data such as Sl.No, Names, and Marks of 5 Subjects.
Step 3: Click Insert Function and select if from legal category to display the result.
Step 4: Enter the condition and minimum marks.

FORMULA:
To Calculate Total:
H8=sum (C8:G8)
To Calculate Average:
I8=H8/5
To Calculate Result:
J8 = If (AND((C8>=40), (D8>=40), (E8>=40), (F8>=40), (G8>=40)),”PASS”,”FAIL”)
To Calculate Rank:
K8= IF (j8=”pass”, RANK (h8,h$8:h$13,0),”No Rank”)
To Calculate Grade:
L8=If (J8=”Pass”, if(I8>=80,”Distinction”,if(I8>=60,”First Class”, if(I8>=50,”Second Class”, if(I8>=40,”Third Class”, “Fail”)))),”Fail”)

* Department of Commerce *
 Saradha Gangadharan College Page No.

3.0. OUTPUT:

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
 Saradha Gangadharan College Page No.

ELECTRICITY BILL PREPARATION

01. AIM:
To Prepare an Electricity Bill using MS-Excel.

2.0 PROCEDURE:
Step 1: Enter in MS-Excel select File  Menu and click on New to create a New Worksheet.
Step 2: Enter the data as Name, Address and number of units.
Step 3: Calculate the changes click Insert function and select if from logical category.
Step 4: Enter the condition and rate of charges per unit to calculate charges per unit.

To calculate charges
Below 80 Units - 75Paise
80-90 - 80Paise
100-120 - 100Paise
121-150 - 120Paise
Above 150 unit - 200paise

FORMULA:
E4=if(d4<80,d4*0.75,if(and(d4>=80,d4<=99),d4*0.80,if(and(d4>=100,d4<=120),
d4*1.00,if(and( d4>=120,d4<=150),d4*1.20,if(and(d4>150),d4*2.00) ))))

* Department of Commerce *
 Saradha Gangadharan College Page No.

3.0. OUTPUT:

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
 Saradha Gangadharan College Page No.

SLIDE TRANSITION & ANIMATION

1.0 AIM:
To Apply Impressive Slide Transition and Animation in MS-POWER POINT

2.0 PROCEDURE:

SLIDE TRANSITION

Step 1: Open the Presentation and click Slide Sorter view from the View menu
Step 2: Select the Slide or Slides you want to add transition
Step 3: On the Slide Show menu, click Slide Transition
Step 4: In the dialog box, chose the type of effect from the effect box
Step 5: We can modify the speed of the transition from slow to medium to fast by clicking the
corresponding option buttoN.
Step 6: The transition effects can be seen in the preview box of the Slide Transition dialogue box.
Step 7: To apply the Transition to the selected slide click Apply. To apply the Transition to all the
Slides, click apply to All.
Step 8: Repeat the process for each slide you want to add a transition.
Step 9: To view the Transition, click ViewSlide Slide Show or press F5
Step 10: To Return to the presentation, click End Show Option.

ANIMATION

Step 11: Open the slide you want to Animate and select the item, be it a block of text or an
object.
Step 12: In the order and timing tab, specify whether the animation will be set off by mouse click
or it will happen automatically after a creation amount of time.
Step 13: In the effect tab, select your choices from the DropDown list boxes.
Step 14: We can preview by the work before applying it by clicking the preview button.
Step 15: Click the OK button, to Save the settings.

* Department of Commerce *
 Saradha Gangadharan College Page No.

3.0. OUTPUT:

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
 Saradha Gangadharan College Page No.

PREPARATION OF ORGANIZATION CHART

1.0 AIM:
To Create an Organization Charts in MS-POWER POINT.

2.0 PROCEDURE:

Step 1: To Open a Blank Presentation click File  New.

Step 2: Click Insert  Picture and Organizational Chart.
Step 3: Organizational Chart Toolbar Provide various shape layout and also sum auto format.
Step 4: Choose any one from the list and add the content of the chart by setting sub-ordinate
courses.
Step 5: Finally type the related text.
Step 6: Press F5 or Slide Show from the view menu to view the presentation.

3.0. OUTPUT:

* Department of Commerce *
 Saradha Gangadharan College Page No.

4.0. RESULT:
The above procedure has been executed successfully and output was verified

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
 Saradha Gangadharan College Page No.

4.0. RESULT: The above procedure has been executed successfully and output was verified

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
 Saradha Gangadharan College Page No.

Ledger Entry

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.

Balance Sheet

* Department of Commerce *
Saradha Gangadharan College Page No.

Trial Balance

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
 Saradha Gangadharan College Page No.

Profit & Loss A/c

* Department of Commerce *
Saradha Gangadharan College Page No.

PREPARATION OF TRIAL BALANCE, BALANCE SHEET &

PROFIT
Journalize the following & LOSS A/C
transactions

Kumar started business with a capital of 5,00,000

Deposited into Indian Bank 2,00,000
Purchase Goods for cash 1,00,000
Purchase goods from Ram 2,00,000
Purchase Machinery for Rs. 50,000
Sold goods for cash 2,00,000
Sold goods to Rajesh 3,00,000
Withdraw a cash of Rs.50,000 from Bank
Salary Paid 25,000
Commission received 10,000
Step 1 : Create the ledgers under the below mentioned groups.

Step 1: Create Company named Kumar & Co.

Step 2: Create the Ledgers under the above given groups.
Step 3: Use Voucher Keys to enter the cash transactions in Cr/Dr.

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.
Saradha Gangadharan College Page No.

* Department of Commerce *
* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *
Saradha Gangadharan College Page No.

* Department of Commerce *