GUG/W/18/11731 1 P.T.O
Post Graduate Diploma In Computer Commercial Applications (PGDCCA-CBCS)
First Semester CBCS
PCCCAT103.1-Elective-I-Paper-III Office Automation
P. Pages 2 GUG/W/18/11731
Time Three Hours Max. Marks 80

Notes 1. All questions are compulsory and carry equal marks.
2. Draw neat and labelled diagram and use supporting data wherever necessary.
3. Avoid vague answers and write specific answers related to Questions.
1.
Either
What is office Automation? Explain the need of office Automation.
8
Explain following in detail:
E-mail Voice-Mail.
8
OR
Explain, how to use the internet for Business conferencing?
8
Explain following in detail:
E-commerce E-governance
8
2.
Either
What is office Automation? List and explain various parts of a Word Window?
8
What is the purpose of page setup option? What are the various options provided in page setup dialog box.
8
OR
What is Insert Menu? List the various options provided in Insert Menu in MS-Word.
8
What is mail merge? Write down the steps to perform mail merge in MS-Word.
8
3.
Either
List and explain the elements of formatting tool bar supported by MS-Excel.
8
Write a procedure to print worksheet, also specify various printing options provided by MS-Excel.
8
OR
List and explain any 4 functions of following categories.
Mathematical Statistical
8
*3871*
GUG/W/18/11731 2
What is database? Write a procedure to sort the data list by giving suitable database structure.
8
4.
Either
What do you mean by presentation graphics? Explain power point slides.
8
Explain how to run slides in power point. Also explain the purpose of slide shorter.
8
OR
Explain following in detail:
Design template Drawing toolbar.
8
Explain organization chart. Write a procedure to add an organization chart.
8
5.
Solve all the Questions.
Write note on Fax Machine in terms of office Automation.
4
Write a procedure to drop cap a letter.
4
What is Goal seek? Explain, how it works?
4
Explain Auto content Wizard.
4