COMPUTER LITERACY PRACTICAL

TUTORIAL MANUAL
MS Word • MS Excel • MS PowerPoint

Institution: ______________________
Student: ______________________
Registration No.: ________________
Date: __________________
Table of Contents
1. MS Word
2. MS Excel
3. MS PowerPoint
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
AssignmentlOMoARcPSD|12389556 MS-WORD Microsoft Word is a word
processor developed by Microsoft. It was first released in 1983 under the name
Multi-Tool Word for Xenix systems. MS Word is a popular word-processing
program used primarily for creating documents such as letters, brochures,
learning activities, tests, quizzes and students' homework assignments. There
are many simple but useful features available in Microsoft Word to make it
easier for study and work. That's why so many people would prefer to convert
the read-only PDF to editable Word and edit PDF in Word. PRACTICAL-1 ▪Type
the paragraph above as it is using "Calibri font" , font size 12. ▪Change the font
type to "Lucida Calligraphy" and size to 14 ▪Alignment to your paragraph to
right margin. ▪Save this file as [Link] in "my documents" folder using
save as option. ▪Edit some part of your document and save again using save
option. ▪Close the file. ▪Open this file again using open option from office
button. ▪View the file you have created using print preview option. ▪Take a
print out of this document through print option. ▪Create a new file using new
option. ▪Select some part of your document of PRACTICAL -1 and copy it to new
file created in bullet 1. Use shortcut keys for copy and paste. ▪Highlight
"Microsoft Word is a word processor developed by Microsoft." ▪Search for
word "document" using find option. ▪Replace the word "Microsoft" with "MS".

lOMoARcPSD|12389556 CS - Computer Literacy Practice and

AssignmentPRACTICAL-2 ▪Select your document by using select all option and
change the font size of your document. ▪Underline the "Microsoft -word" using
underline option. ▪Draw a line through the middle of the selected text using
strikethrough option. ▪Create small number below the text baseline of the word
"Multi-Tool" using subscript ( ctrl+=) as shown below Multi-Tool 1 ▪Create small
number above the text baseline using superscript ( ctrl+shift++) as shown
below. Multi-Tool2
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
AssignmentPRACTICAL-4 Microsoft office package includes MS word,
PowerPoint, Excel, Outlook, OneNote and Access. ▪View your document in
portrait and landscape view using orientation option in page layout menu.
▪Change the color of the text using font color option. ▪Create a bulleted list
like : MS word Powerpoint Excel Access PRACTICAL-5 ▪Using the insert >
break option insert a page break in your document. ▪Insert page number at the
bottom of the page using page number option. ▪Insert a table like this:
[Link] [Link] [Link]
[Link] [Link].C ▪Draw the borders of the table using
draw table option. ▪Select the last row of the table and delete the entire row.
▪Insert some more columns to the right in the table. PRACTICAL-6 ▪Insert a
picture in the file like this:

lOMoARcPSD|12389556 CS - Computer Literacy Practice and Assignment▪Place

the picture into the center of the page. ▪Add a thick red border around the
picture. ▪Crop the picture 0.5 inches from the left. ▪Change the size of the
picture by pressing right click of the mouse on the picture . ▪Insert caption to
the picture. PRACTICAL-7 ▪Insert a clip art of computer in the file using clip art
option . ▪Draw a star using shapes option . ▪Draw a figure like this using
SmartArt option and add some text in the figure. : ▪Insert date & time and
symbol date option &symbol option. ▪Using WordArt ,write the following
"THANK YOU" .Use any style you wish and give it a font size of 20 points.
PRACTICAL-8 ▪Insert header &footer using the header and footer option. ▪Draw
a text box and insert the following text in the textbox: "Computer is an
electronic device that performs complex calculations easily."
lOMoARcPSD|12389556 CS - Computer Literacy Practice and Assignment▪Insert
Excel worksheet using object option in insert menu. ▪Create a hyperlink &
attach a file to the hyperlink. ▪Insert Bookmark using bookmark option in insert
menu. PRACTICAL-9 ▪Choose the paper size for the document using size option.
▪Split the text in three columns by using columns option. ▪Type the following
lines and give numbers to that lines using line numbers option: Computer is a
device. Computer is a machine Computer is an electronic device Computer is
very useful. PRACTICAL-10 ▪Make the word "MS-WORD" as the watermark of
the document. ▪Set the background color of the document as RED using page
color option. ▪Change the border of the page using page border option. ▪Choose
the indents tab. ▪Change the spacing between paragraphs by adding space
above the paragraph. PRACTICAL-11 ▪Add a table of contents to the document.
▪Update the table of contents. ▪Insert footnote to the document. ▪Insert an
endnote to the document. ▪Insert an index into the document. ▪Create labels to
the document. PRACTICAL-12 ▪Type this paragraph &checks the spelling
&grammer using spelling &grammar tool. Microsoft Word is a word processor
developed by Microsoft. It was first released in 1983 under the name Multi-Tool
Word for Xenix systems. MS Word is a popular word-processing
programusedprimarilyforcreatingdocumentssuchasletters,
brochures,learningactivities, tests, quizzes and students' homework
assignments. There are many simple but useful
[Link]'swhyso

lOMoARcPSD|12389556 CS - Computer Literacy Practice and

Assignmentmanypeoplewouldprefertoconverttheread-
onlyPDFtoeditableWordandeditPDFin Word. ▪View the document in full screen
using full screen reading option. ▪View the document as draft using draft tool.
▪View the screen in full mode and zoom mode. ▪Add a bibliography of the
document. MSExcel-Assignment Practical-1 Create a database Club and table
Member. The following are the details of the table.
NumberFnameLnameAddressHome phoneJoining date
S1465TJoneJohnson1234 Country ClubTexas (713)-555-789001-02-04
J1050SBillSmith1112 Peter Avenue Texas (713)-556-655630-11-04
S1300TLisaStanley985 Venton Circle Texas (713)-558-122711-11-04 Do the
following: 1)Create Business table by using Design Wizard with year own data
(atleast 6 fields and 10 records) 2)Create Personal table by using Design Wizard
with your own data (atleast 6 fields and 10 records) Create a employee
database and table 'emp'. [Link] prom
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
Assignment101AjyaClerk17-12-01600020Male 102ArvindSalesmen20-02-
02500030Male 103RahulSalesmen22-03-01550020Male
104RehmanManager01-04-011200040Male 105SahilManager20-09-
021150010Male Create a database 'Library' and create a table as 'Books' and
execute the queries given below: Author LnameAuthor FnameBook titleBook
typeYear of publication GuptaSharmaManagementAccounting Accounting2002
NainPatelFinancialAccounting2000 ReddyRamCorporate accounting
Accounting1990 a)Display Book title, Book type, author name where author =
Ram and book type = Accounting. b)Display Author Fname, Book type year of
publication where year above 2000 Practical-2 Create a database 'Student'.
Also Create table 'stdtable'& execute the following. SRoll
noSnameClassStateDOBMarksGrade 101RajBCAAP21-09-8280A
105RamBCAMP31-08-8170B 104RakeshBCAUP30-06-8090A
103RameshBCAAP25-07-8238C 105RajeshBCAMP02-02-8345C a)Sort the data
by SRoll no. b)Display SRoll no., Sname, State and Marks where marks > 80.
c)Display SRoll no., Sname, State and Marks where Grade = A.

lOMoARcPSD|12389556 CS - Computer Literacy Practice and Assignment

Create 'employee database and table 'emp' create a Report.
[Link] 101AjyaClerk17-12-01600020Male
102ArvindSalesmen20-02-02500030Male 103RahulSalesmen22-03-
01550020Male 104RehmanManager01-04-011200040Male 105SahilManager20-
09-021150010Male Create 'Student database table 'and also create a Report .
SRoll noSnameClassStateDOBMarksGrade [Link]-IAP21-09-8280A
[Link]-IIMP31-08-8170B [Link]-IIIUP30-06-8090A
[Link]-IIAP25-07-8238C [Link]-IMP02-02-8345C Practical-
3 Create a employee database and Create a Report .
[Link] 101AjyaClerk17-12-01600020Male
102ArvindSalesmen20-02-02500030Male 103RahulSalesmen22-03-
01550020Male 104RehmanManager01-04-011200040Male 105SahilManager20-
09-021150010Male Apply Auto formatting for the following Table and find
total by using Auto Sum option
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
AssignmentROLLNONAMEQTFITIOM 101Radhika509080 102Sarika608060
103Geethika507075 104Bhoomika806080 105Karthika845784 The following
are the marks obtained by the students in three subjects
ROLLNONAMEQTFITIOM 101Pravalika509080 102Aryaman408060
103Akosh387075 104Prajaktha806080 105Trisha845784 Using Conditional
Formatting list out students who secured ( a) Less than 50 in QT, ( b ) More than
65 in FIT, ( c ) Between 60 and 80 in Accounts . Practical-4 The following are
the marks obtained by the students in three subjects Draw a Bar Diagram.
ROLLNONAMEQTFITIOM 101Pravalika509080 102Aryaman408060
103Akosh387075 104Prajaktha806080 105Trisha845784

lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentType

the following table and find out the total marks average obtained by each
student. ROLLNONAMEECONOMICSBANKINGMARKETING 1Ajay509080
2Vijay408060 3Arnay387075 4Prathista806080 5Bhoomi845784  From the
table given below reduce the total expenditure to RS.16000 by reducing sales
department's Expenditure by applying Goal Seek . DepartmentExpenditure Rs.
Production4000 Sales6000 Marketing3000 Finance`5000 Total
Expenditure18000 Principal Amount2,00,000 Rate of Interest5% Time
Period10 Years Amount to be Paid? From the above , Calculate the amount
payable per annum and also show the effect on amount by changing : a)Rate of
Interest to 3% and 8% b)Time Period to 5 Years and 3 Years. Practical-5
EmployeeNameDepartmentSalaryRs.
lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentASales3000
BAccounts4000 CMarketing5000 DSales6000 EAccounts4000 FMarketing8000 Obtain
Department wise Sub Totals . Employee NameDepartmentSalaryRs. ASales3000
BAccounts4000 CMarketing5000 DSales6000 EAccounts4000 FMarketing8000 Prepare
Pivot Table . Create the following table: Pay ROLLNONameSalary Rs .Part Time [Link]
1011Prasanna120009001800 1012Anitha140008001600 1013Ravi180007001700
1014Saritha150006001600
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
Assignment1015Mallika170005001800 Using Conditional Formatting list out
employees who got (a ) Less than Rs. 15000 as Salary ( b ) More than Rs. 700 as
Part Time ( c ) Between Rs.1600 and Rs.1800 as Arrears . Practical-6 The
following are the marks obtained by the students in three different subjects
Draw a Pie Diagram. ROLLNONAMEQTFITIOM 101Radhika509080
102Sarika608060 103Geethika507075 104Bhoomika806080 105Karthika845784
Create a pie graph for the following data of sales of XYZ co.
YEAR19981999200020012002 SALES50001000025000300020000 Show a Pie
graph for the following data with different colors for each category Total
PopulationDistribution (in crores) 0 - 520

lOMoARcPSD|12389556 CS - Computer Literacy Practice and Assignment6 -

1210 13 - 2015 21 - 3525 36 - 6015 60 & above15 Total100 Draw a multiple bar
diagram from the following data: YEARSALESGROSS PROFITNET PROFIT ('000
Rs.)('000 Rs.)('000 Rs.) 20051204020 20061354530 20071405535 2008Practical-7
1506040 Create a file in Excel that describes a grading system for a class. 1)
One Excel workbook file with 3 separate, appropriately labeled worksheets. 2)
Tables, a graph, and a list of descriptive statistics. 3) For this exercise, the
correct values in each cell are important and will be graded. 4) The graph will be
graded on appropriate content, appropriate axis scaling, and clear labeling.
Content You should form a table on a worksheet titled "class list" that includes
the names and test scores of your students. You have 7 students in your class,
their names are: Allen, Borlin, Catlin, Dorsey, Eugene, Finneran, and Greco.
Their scores on the first 3 tests are as follows: Test 1Test 2Test 3
lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentAllenTest 89Test
78Test 89 BorlinTest 67Test 56Test 66 CatlinTest 78Test 76Test 76 DorseyTest 56Test
34Test 45 EugeneTest 26Test 100Test 99 FinerranTest 99Test 98Test 97 GrecoTest 78Test
87Test 88 I. Using an Excel function, show each student's average in an additional column
labeled "Average" II. Using an Excel function, show each student's rounded average in an
additional column labeled "Rounded Average" III. If a student's rounded average is above
"95", he/she has received "honors" in the class. In an additional column titled "Honors",
insert a function that will return the word "Yes" if they have received honors, otherwise
would return the word "No" IV. If a student's rounded average is 90 or greater, they receive
an "A". Between 80 and 90 is a "B", between 70 and 80 is a "C", between 60 and 70 is a "D",
and lower than 60 is an "F". Somewhere on your sheet, enter this information in cells.
Create an additional column titled "Grade" and insert a nested IF function that returns the
appropriate grade for each student. Use an absolute cell references in your nested IF
function to indicate cut-off points between grades. Hint: You will need to place the "cut-off
grade" values in cells somewhere on your worksheet... V. Below your table, create a graph
showing the students' rounded averages. Be sure to include appropriate labeling and
spacing, so that the graph is non-repetitive and the scale is appropriate. Hint: A score of 100
is the highest possible... VI. Insert a new worksheet. Use the Goal Seek feature to find the
value that Eugene needed on Test 1 in order to earn honors for the course. Show your work
by displaying an updated table. Title the worksheet "Eugene's dream." Hint: Do not worry
about rounding Eugene's new "score" for Test 1. If done properly, the rest of your table
should update accordingly.
lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentVII.
From the data on your "class list" worksheet, provide the Descriptive Statistics
of your students' rounded averages. For the output, create a new worksheet
and choose to display "summary statistics". Rename this worksheet
"Descriptive Statistics". Practical-8 Type the following data in excel worksheet
and save it as [Link] Type the following data in excel worksheet and save it as
[Link] ABCDE 513 501 504 513 511 516 532 504 432 501 510 517 479 494 498
Do the following (a) Highlight column A and copy it to column C (b) Sort the
data in column C in ascending order (c) What is the lowest number in the list
(use a function) (d) Copy the data in column A to column E and sort it in
descending order (e) What is the highest number in the list (use a function) (f)
How many numbers in this list are bigger than 500 (use a database function) (g)
How many numbers in column A are between 520 and 540 inclusive (use a
database function) Practical-9 Type the following data in excel worksheet and
save it as [Link]. ABCD People per physicianLife Expectancy

lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentXYX * Y

37070.5 616653.5 68465 44976.5 64370 155171 61660.5 40351.5 Do the
following (a) Complete column C for finding product x * y (b) Find sum of x
column at the end of data (c) Find sum of y column at the end of data (d) Find
sum of x * y column at the end of data (e) Find sum of x^2 (f) Find sum of y^2
Practical-10 Enter the following data and save it in grade .xls
NameMarks1Marks2Marks3TotalPercentageGrade Amit807080 Renu706090
Rajeev605080 Manish503090 Sanjeev404080 Anita707090 Do the following (a)
Compute the total marks and percentage of each student by entering
appropriate formula. (b) Compute the grades based on following criteria If
percentage >= 90 then grade = A If percentage >= 80 and <90 then grade = B If
percentage >= 70 and <80 then grade = C If percentage >= 60 and <70 then
grade = D If percentage < 60 then grade = E Using [Link] to perform the
following formatting operations (a) Draw a border around the worksheet (b)
Change the font size of heading to 14 points and underline it and hide column c
(c) Increase the width of column A to 15 characters (d) Right Align the values in
column B, C, F Practical-11 A university maintains a year wise result for four
courses and then generates an average report as given below
lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentSr
no.YearCourse1Course2Course3Course4Average 12002356300300400
22003200400200450 32004256500400600 42005400600500550
52006456450550450 6Total (a) Complete the report to calculate the course
wise average in row 6 (b) Provide formula to calculate year wise average in
column G (c) Generate a column chart to compare data Practical-12 A person
wants to start a business and he has four schemes to invest money according to
profit and years. Find out which scheme is the most profitable. Investment
AmountPercentage for ProfitNo of years 2000010%6 years 4000020%5 years
1400030%4 years 1200015%5 years 2) A company records the details of total
sales (in Rs. ) sector wise and month wise in the following format
JanFebMarchApril Sector 3012000170001400015000 Sector
2214000180001500016000 Sector 2315000190001600017000 Sector
1516000120001700018000 (a) Enter the data in a worksheet and save it as
[Link] (b) Using appropriate formula, calculate total sale for each sector (c)
Create a 3-D column chart to show sector wise data for all four months (d)
Create a 3-D pie chart to show sales in Jan in all sectors

lOMoARcPSD|12389556 CS - Computer Literacy Practice and AssignmentMS-

POWERPOINT PRACTICAL-1 Make a PowerPoint presentation of at least 5
slides. Add a new slide in the presentation using new slide option. Copy &
paste the 2ndslide after 5thslide. Delete the 2ndslide using delete option.
Make the selected text bold using "B" option. Save this presentation as ms-
[Link] in "my documents" folder using save as option. PRACTICAL-2 Edit
some part of your document and save again using save option . Close the
presentation. Open this presentation again using open option from office
button. View the file you have created using print preview option. Take a
print out of this document through print option. PRACTICAL-3 ▪Search for some
word using find option. ▪Replace the word "Microsoft" with "MS". ▪Select your
document by using select all option and change the font size of your document.
▪Underline the "Microsoft -word" using underline option. ▪Select the text and
draw a line through the middle of the selected text. PRACTICAL-4 Create the
small letters below the text line Create the small letters above the base line
Change the selected text to uppercase or lowercase. Select the text and
highlight it with BLUE. Change the color of the selected text. PRACTICAL-5
Insert bullets to the text. Create a numbered list having 10 items in the list.
Select the text and align the text to the centre of the slide.
lOMoARcPSD|12389556 CS - Computer Literacy Practice and
AssignmentChange the spacing between the lines of the text. Increase the
indent level of the paragraph. Change the background color behind the
selected text.. PRACTICAL-6 Draw an e-r diagram using shapes tool. Fill the
shapes used in e-r diagram with appropriate color using shape fill option. Give
the outline with black color to every shape using shape outline option. Use
any shape effect in the diagram. PRACTICAL-7 Insert a table like this:
[Link] [Link] [Link]
[Link] [Link].C ▪Draw the borders of the table using
draw table option. ▪Select the last row of the table and delete the entire row.
Insert some more columns to the right in the table. Put a picture on the slide.
PRACTICAL-8 ▪Insert a clip art of computer in the file using clip art option .
▪Draw a star using shapes option . ▪Draw a figure using SmartArt option and
add some text in the figure. ▪Insert date & time using date & time option..
▪Using WordArt ,write the following "THANK YOU" .Use any style you wish and
give it a font size of 20 points. PRACTICAL-9 ▪Insert header &footer using the
header and footer option. ▪Draw a text box and insert the following text in the
textbox:

lOMoARcPSD|12389556 CS - Computer Literacy Practice and

Assignment"Computer is an electronic device that performs complex
calculations easily." Insert Excel worksheet using object option in insert menu.
▪Create a hyperlink & attach a file to the hyperlink. ▪Insert slide number at the
bottom of the slide using slide number option. PRACTICAL-10 Set the slide
orientation as landscape. Apply the civic theme to the all slides of the
presentation. Set the background style for the theme. Animate the slides as
wipe using animate option. PRACTICAL-11 Check the spelling of the text using
spelling option. View the presentation in black and white using pure black and
white option. View the presentation in grayscale. View the screen in full
mode and zoom mode. PRACTICAL-12 Insert a column chart to the
presentation using chart tool. Create an organization chart in smart art.
Insert slides from another presentation. Save the presentation again using
save option(ctrl+S). View the slide show of the presentation using slide show
option.