PRACTICAL FILE OF INTRODUCTION
TO INFORMATION TECHNOLOGY
BACHELOR OF BUSINESS ADMINISTRATION (2019-
22) MERI COLLEGE OF ENGINEERING AND
TECHNOLOGY, (SAMPLA) (AFFILIATED TO
MAlHLARISHI DAYANAND UNIVRSITY, ROHTAK)
SUBMITTED TO - SUBMITTED BY -
Ms. NIDHI PRUTHI ARJUN
(ASSISTANT PROFESSOR ) BBA 3rd
SEMESTER
Roll No.- 9
1). Type a paragraph on “ Effects of Pandemic –Covid
2019 in our society”and perform following operations:
1. Select the Comic Sans MS Font
2.Center the heading
3.Bold a phrase
4.Italicize a word
5.Underline a phrase
6.Double space the lines your paper
7.Add page numbers to your document
8.Create a header and footer
9.Create a hyperlink in your docs
10.Try find and replace option
11.Add watermark
12.Save your file
1) select the comic sans ms font
2) Center the heading
3) Bold a phrase
4) Italicize a word
5) Underline a phrase
6) Double space the lines paper
7) Add page numbers to document
8) Headers
8) Footers
9) Hyperlink in document
10) Find option
Replace option
11) Add watermark
12) Save file
2) Mail Merge Exercise
1) Save the letter as course letter
2) table of Recipient
3) Steps of mail merge
First open ms word then tap mailing and click start mail
merge and then go to step by step mail merge wizard
Step 1 select the document type like letter and then click
Next:starting document
Step 2 Next: select recipient from the list of recipient
wich is save as cours participant data
Step 4 Next: write your letter
To add recipient information in letter click location in the
document and then click one of the item like address
block, greeting line, first name, surname ect
Step 4 Next: to preview your letter one of the mereged
letter is preview another letter, click one of the recipient
Step 5 Next: complete the merge male merge is ready to
produce your letter
3) MS Excel exercise
1. Open a new workbook and save the file with the name
“Payroll”.
2. Enter the labels and values in the exact cells locations
as desired.
3. Use AutoFill to put the Employee Numbers into cells
A6:A8.
4. Set the columns width and rows height appropriately.
5. Set labels alignment appropriately.
6. Use warp text and merge cells as desired.
7. Apply borders, gridlines and shading to the table as
desired.
8. Format cell B2 to Short Date format.
9. Format cells E4:G8 to include dollar sign with two
decimal places.
10. Calculate the Gross Pay for employee; enter a
formula in cell E4 to multiply Hourly Rate by Hours
Worked.
11. Calculate the Social Security Tax (S.S Tax),which is 6%
of the Gross Pay; enter a formula in cell F4 to multiply
Gross Pay by 6%.
12. Calculate the Net Pay; enter a formula in cell G4 to
subtract Social Security Tax from Gross Pay.
1) the labels and values in the exact cells locations as
desired.
2) Use AutoFill to put the Employee Numbers into cells
A6:A8.
3) Set the columns width appropriately.
4) Set labels alignment appropriately.
5) Use warp text and merge cells as desired.
6) Apply borders, gridlines and shading to the table as
desired.
7) Format cell B2 to Short Date format
8) .Calculate the Gross Pay for employee; enter a formula
in cell E4 to multiply Hourly Rateby Hours Worked.
9) Calculate the Social Security Tax (S.S Tax), which is 6%
of the Gross Pay; enter a formula in cell F4 to multiply
Gross Pay by 6%
10) Calculate the Net Pay; enter a formula in cell G4 to
subtract Social Security Tax from Gross Pay.
4) MS Excel exercise
1. Create the worksheet shown above.
2. Set the column widths as follows: Column A: 8,
Column B: 14, Columns C & D: 15, Columns E & F: 14.
3. Enter the formula to find COMMISSION for the first
employee. The commission rate is 2% of sales,
COMMISSION = SALES * 2% Copy the formula to the
remaining employees.
4. Enter the formula to find TOTAL SALARY for the first
employee where:
TOTAL SALARY = SALARY + COMMISSION
Copy the formula to the remaining employees.
5. Enter formula to find TOTALS, AVERAGE, HIGHEST,
LOWEST, and COUNT values. Copy the formula to each
column.
6. Format numeric data to include commas and two
decimal places.
7. Align all column title labels horizontally and vertically
at the center.
8. Create a Header that includes your name in the left
section, page number in the center section, and your ID
number in the right section.
9. Create footer with DATE in the left section and TIME in
the right section.
1) Set the column widths as follows: Column A: 8,
Column B: 14, Columns C & D: 15, Columns E & F: 14.
2) Enter the formula to find COMMISSION for the first
employee. The commission rate is 2% of sales,
COMMISSION = SALES * 2% Copy the formula to the
remaining employees.
3) Enter the formula to find TOTAL SALARY for the first
employee where:
TOTAL SALARY = SALARY + COMMISSION
Copy the formula to the remaining employees.
4) Enter formula to find TOTALS, AVERAGE, HIGHEST,
LOWEST, and COUNT values. Copy the formula to each
column.
Totals
Average
Highest
Lowest
Count
5) Format numeric data to include commas and two
decimal places.
6) Align all column title labels horizontally and vertically
at the center.
7) Create a Header that includes your name in the left
section, page number in the center section, and your ID
number in the right section.
8) Create footer with DATE in the left section and TIME in
the right section.
5) Explain the concept of charts with any
example.
To create a chart first we need to open Ms Word
then click insert and then go to the chart and click it
Click the chart type and then double click the chart
you wnat
In the spreedsheet that apears and make a chart to
put tha data in spreedsheet
When your chart is complete we can save the
document
6) MS-POWERPOINT EXERCISES
First we need to open Ms powerpoint and then click
to bank presentation
when we want to add a slide we need to click the
home tab and then click new slide and then slid
apears ne many type
For add theme in slide we need to go in degine
tab than click any option which you need to do
For add background color we need to go in
degine tab and then click format background
For add a pic we need to go in insert tab then click
the picture and tha apear 2 opetion and click any
wich you you want
For changing text color we need to go home tab
and and click theme colors
For add charts we need go in insert tab than click
chart and click we can use any type of charts
For add shapes we need to go in insert and than
click on shapes and then select shapes
For add word art we need to go in insert tab and
then wordart and select types
For smartart we need to go insert and then click
smart art then select the types which you want
For slide effects we need to go in transition and
select any type
7) Tally
1) Creating of voucher
2) Printing of vouchers
3) Deleting of vouchers
4) Cancellation of vouchers
