Veer Narmad South Gujarat University 2011-2nd Year B.Com Computer Application-2, ,- , Veer Narmad South University - Question Paper
SB-0416
Second Year B. Com. Examination March / April - 2011 Computer Application - II
(Computer Programming & Accounting Tools)
Time : : Hours] 6silq<3i Puunki(l faaim SuwiA u* Fillup strictly the details of signs on your answer book. Name of the Examination : |
[Total Marks : 35 ""'N Seat No.: |
S.Y. B. COM.
Name of the Subject:
COMPUTER APPLICATION - 2
Student's Signature
-Subject Code No. |
|
-Section No. (1,2,.....): NIL |
SiHL (3tR HlHl : (IH d HR)
(*l) ExceHl q.M2Hl ke(l Hd ileiH Ah d ?
(0 Tally Hi iVgl HlMl *il il LLHl.
(3) Len (MID$ ("Where is Hongkong", 10)) =
(y) A=10, B=30 Ah dl AA2/B*3 = _
(h) y= + 4aCi HBhld LLHl.
2a
(?) Masters Hi HHl(3 %lHWiL.
(h) ExceHL -Mdi $MKl H%Hl :
(<l) SUMIF (0 ROUND
(3) SUBSTITUTE
(y) damx
(h) ExceHL (3HH>Ll WZ\i<$L. Y
(h) HTO *LlH=LL HlM UlLLH <HHl. H
H*l<U
* (*l) ExcelHL Goal Seek Validation HWil. H
3 (*{) BasicHi *iLH*a* *ld d4l 5HfelHdLdl H ttH&l<il. H
aH'Sftcil.
H*l<U
3 (*{) BasicHi Mh>SL $Md ttH&l<il. M
ENGLISH VERSION
Instruction : As per the instruction no. 1 of page no. 1.
1 Answer in brief : (any five) 5
(I) How many Rows and Columns are there in Excel worksheet ?
(2) State the short key of contra entry in Tally.
(3) Len (MID$ ("Where is Hongkong", 10)) = _
(4) A=10, B=30 then AA2/B*3 = _
ttt i i n -b + b2 -4ac
(5) Write the basic expression oi y =-
2 a
(6) Explain allow advanced entries in masters.
2 (a) Explain the following functions of Excel : 6
(1) SUMIF
(2) ROUND
(3) SUBSTITUTE
(4) DMAX
(b) Explain the uses of Excel. 4
(c) Write a program to find out a factorial of a given 5 number.
OR
2 (a) Explain Goal Seek and Validation in Excel. 5
(b) Explain Pivot table in Excel. 5
(c) Write a program to check whether the given string 5 is palindrom or not.
3 (a) Explain operator and operator precedence in BASIC. 5
(b) Differentiate between FLOOR and CEILING function 5 of Excel.
(c) State the types of accounting voucher in Tally and 5 explain any two.
3 (a) Explain any four string functions of BASIC. 5
(b) Explain cell address in Excel. 5
(c) State the inventory book option and explain any two. 5
SB-0416] 3 [ 500 ]
Attachment: |
Earning: Approval pending. |