Veer Narmad South Gujarat University 2011-2nd Year B.B.A SB-1378 Computer Application : - 2 ( Sem - 4 ) - Question Paper
SB-1378
Second Year B.B.A. (Sem. IV) Examination
March/April - 2011 Computer Application : Paper - II
(Advanced Office Automation Tools)
[Total Marks : 30
Time : Hours]
Instructions
Seat No.:
M CnsLLnlcj.L{l [qoicu u? snqw <h>h41.
Fillup strictly the details of signs on your answer book.
Name of the Examination :
S. Y. B.B.A. (Sem. - 4)
Name of the Subject:
Computer Application - 2
Student's Signature
-Subject Code No. |
|
-Section No. (1,2,.....): NIL |
(2) All questions are compulsory.
(3) Figures to the right indicate marks.
1 Answer folio wine questions : (any ten) 10
(i) Differentiate between INT () and TRUNC () function.
(ii) MID (SWAMI VIVEKANAND, 7,8) =_
(iii) What is Conditional Formatting ?
(iv) What is filtering ?
(v) Explain functions IRR and DDB.
(vi) Explain with example primary key in reference to ACCESS.
(vii) Output of = MOD (Power (-3,2),2) is_.
(viii) What is the use of Merge Cell option ?
(ix) Explain Data consolidation.
(x) What is criteria range ?
(xi) Output of = ROUNDDOWN (12.23, 1) is_
(xii) Explain ODD and EVEN function.
2 (a) What is the importance of Chart ? Explain the chart 5
option of MS-Excel in detail with example.
(b) Explain with examples : (any two) 6
(i) Sorting of data in a database
(ii) Text Functions in Excel
(iii) Statistical functions
3 Write short notes (any three) 9
(i) Data Validation
(ii) Explain Macro
(iii) Sharing Excel workbook
(iv) Generating Report in MS Excess.
SB-1378] 2 [2000]
Attachment: |
Earning: Approval pending. |