Goa Board Class 12 Question Paper June 2018 Computer Application

2018 VI 11 1430 Seat No. :

Time : 2 Hours COMPUTER APPLICATION

Subject Code

V 2 3 3

Total No. of Questions : 5 (Printed Pages : 3) Maximum Marks : 50

INSTRUCTIONS : i) Answer each question on a fresh page.
ii) Write the number of the question and the sub question
clearly.
iii) All questions are compulsory.
iv) Figures to the right indicate full marks.

1. A) Choose the correct alternative and rewrite the statement. [1]
i) In MS-Excel 2007 the division sign is represented by __________
a) / b) <
c) \ d) *

i) Name the vertical blocks of cells that runs through the entire worksheet.

C) Explain the following functions in MS-Excel 2007 [3]
i) Sum ( )
ii) Average ( )
iii) If ( )

D) Mention the steps to protect a worksheet in MS-Excel 2007. [5]
OR

D) Write the steps to create a Pivot table in MS-Excel 2007.

V-233 -1- P.T.O.

2. A) Choose the correct alternative and rewrite the statement. [1]
i) The default orientation of the slide in MS-PowerPoint 2007 is _______
a) Background b) Landscape
c) Portrait d) Template

B) Answer the following in a word or a phrase. [1]
i) Name the condition in MS-Access 2007 that connects two or more tables
by keeping one common field.

C) What is slide transition in MS-PowerPoint 2007 ? Mention any four transition
effects. [3]

D) Write down the steps to insert a picture from a file in MS-PowerPoint 2007. [5]

3. A) Choose the correct alternative and rewrite the statement. [1]
i) The full form of OLE with reference to MS-Access 2007 is _________
a) Ordered List Excluded
b) Object Linking Embedding
c) Object List Example
d) None of the above

i) If www.google.co.in is a web address. What does.in stand for ?

C) Mention the steps to display a ledger account in Tally. [3]

D) Write down the steps to create a new company in Tally. [5]
OR

D) Write down the steps to create a voucher in Tally.

V-233 -2-

4. A) Answer the following question in one sentence. [1]
i) What is a day book in Tally ?

B) Write any two disadvantages of MS-Excel 2007. [2]

C) What is the difference between Merge cell and Split cell in MS-Excel 2007 ? [2]

D) Name and explain any two types of Standard Charts in MS-Excel 2007. [2]

E) Write down the steps to create a table design view in MS-Access 2007. [3]

5. A) Answer the following question in one sentence. [1]
i) Name the function key used to change the date in Tally.

B) Name any four Sub Groups under Current assets in Tally. [2]

C) What are the Golden rules of Real account and Personal account with
reference to Tally ? [2]

D) What is the difference between Primary key and Foreign key in
MS-Access 2007 ? [2]

E) State and explain any 3 disadvantages of E-Commerce. [3]

_________________

V-233 -3-