Veer Narmad South Gujarat University 2010-4th Sem B.B.A Computer Application : - II, S.Y ( )- - Question Paper
RB-1731
Second Year B. B. A. (Sem. IV) Examination
April/May - 2010
Computer Application : Paper - II
Time : 2 Hours] Instruction :
M CnsLLnlcj.L{l [qoicu u? snqw <h>h41.
[Total Marks : 25
Seat No.:
Fillup strictly the details of signs on your answer book.
Name of the Examination :
S. Y. B. B. A. (Sem. IV)
Name of the Subject:
Computer Application - 2
-Subject Code No.: |
|
-Section No. (1,2,.....): Nil |
Answer the following question in brief. (1) = FIND ("Test", "Testing") = _
Student's Signature
A5 = "ABC", B5 = "XY" then output of = if (A5 > B5 >, FALSEQ, TRUEQ) is _
(2)
(3)
(4)
(5)
(a)
MID ("SWAMI VIVEKANANDA", 7, 8) = _
Differentiate Paste and Paste Special with example. Explain the Logical function AND.
Explain the following excel functions.
6
(i) VLOOKUP
(ii) MAXA
(iii) FALSE
Explain the difference between SUBSTITUTE and REPLACE function in detail with proper example.
(b)
(a)
(b)
6
6
6
OR
Explain conditional formatting in detail with proper example.
Explain sort and filter option of Ms-Excel in detail with proper example.
3 Attempt any two : 8
(1) Explain the following function with example.
(i) CONCATENATE and
(ii) VARP
(2) What is the importance of Chart? Explain the Chart options of Ms-Excel in detail with proper example.
(3) Explain filtering option of Sort Menu in Ms- Excel
(4) Explain any two Financial Functions.
RB-1731] 2 [ 2300 ]
Attachment: |
Earning: Approval pending. |