Veer Narmad South Gujarat University 2010-2nd Year B.B.A Computer application - 2 ( sem 4 ) . - Question Paper
Second Year B. B. A. (Sem. IV) Examination
April/May - 2010
Computer Application : Paper - II
RB-1731
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. |
