Infotech computer institute
Annual Examination July 2012
PGDCPA & DCPA
(Microsoft word,excel.,ppt,fpe,internet,networking, tally)
Paper second
Time Allowed Three Hours
Maximum Mark: 175
Note: Question No. 1 Is Compulsory Series with three
Section A, B, C, D, E, and F .
Section “A” MS word
1. What are balloons?
2. Which part of word document displays the page number?
3. If you want to send cursor at the page number 5 which
Command is used.
4. What are application a template in msword ?
5. If working in insert mode or overtype mode how can Identify it?
6. How can insert a comment in a document?
7. How can define watermark?
8. What is mail merge of document?
Section “B” Ms Excel
1. What is a workbook made up of?
a. group of worksheet cells is called a _________.
b. are you cell series value arrange in descending order by …..
2. Draw a label diagram of ribbon button.
3- Sort type answer question.
(a) What is the different cell and cell range?
(b) Explain the following in function
1. PMT 2. HYPERLINK 3. MAX 4. UPPER 5. ROUND
4- How can rename the worksheet?
5. Give the name of same comparison operator in excels.
6. What is difference between sorting and filtering?
7. When we select a number with content press function
F11 --- chart prepare automatically?
Section “C” Internet & networking
1. What is server computer a network?
2. How can sharing folder on a network?
3. How can determine the printer sharing ?
4. What do you mean by broadband internet connection?
5. How can change the default home page?
6. What is cracking?
7. What is computer virus?
Section “D” Power Point 1. Write a short note on components of presentation. 2. How can change the color schemes of slide presentation 3. If a presentation have a animation, but we do not show in Presentation , how can define? 4. What is a slid master? 5. What is compare and merge presentations? 1. What are two methods for web publishing? 2. How you can create a web site in project view. 3. Give list of web site whose provide free email id. 4. What is hyperlink, how can define it 5. Write the function and syntax of following tags- a. font b. img c. i d. font size e. P 6. Where is my webs folder?
1. When charged VAT Company? 2. How many character TIN number? 3. How can activate the interest calculation. 4. What is a account master? 5. Give the voucher name where returns goods from branch office. 6. Define the term of a. budgets b. voucher type c. unit of measure 7. What is ageing analysis of a inventory books? 8. How can display outstanding account books. Explain about (a). TDS (b). Form- 27A (c) Service tax 9. What is work in following short keys (a). alt + s (b)Ctrl + F7 (c). ctrl+p (d). alt +d 10. How can display trial balance of company? 11. Explain about following groups also primary or secondary a. cash in hand b. sundry creditors c. provision d. branch division 12. Give the hot keys for to c. To duplicate a voucher d. selects the Credit Note voucher d. To delete a voucher e. To select the Functions and Features screen
Section “E” Front Page(HTML) Section “F”
Tally 9.0,ERP