DU SOL B.Com Question Paper 3rd Year 2018 Computer Applications in Business

This question paper contains I prinUd pages.
1272 Your Roll Ao. .... .......

B.Com. / III G-I

Papen Cone : C-IOZ

Paper XIII- COMPUTER APPLICATIONS
IN BUSINESS
(Admission of 2006 onwards)

Time :3 hours Maximum Marl<s: Parts A+B:40+35
(For S.O.L. Students)
Time :2 hours Maximum Marks: Part A 40
(For Regular Students)
(Write your Roll Na. on the top immediately on receipt of this question paper
)

Norn:- Answers may be written either in English or in
Hindi; but the same medium should be used
throughout the paper.
i?utt.- f,s rruqq" 6r ffi{ erf FA 4T fd ffi q-*,
qM t qffirg' Aff{ s,f rfl}' 6t wtqq qa d
alaT q,lfdq r
Nore:- The paper consists of two Parts, A and B- part A
is of 40 ma*s and Part B is of 35 marks. For
students of S.O.L. both Pans A and B are
compulsory.
fiqufr:- aii sva-ql E+ rn4i'' *' .l#r s C fflr rrqr t r

qrrl EF 40 ai6 6r d 3dr qm a 35 atd ar * I
s.o.L. F,# + @ qm 6 e#d @.d+' etffi
\t
6t PTO.

1272 z

Attempt all questions.
€rl? rfl+ # src <?&q I

Panr A (cTfrf eT)

1. State true or false with reasons:

TrFr qT sRfF[, 6pq qkd qcir{q:

(a) Operating System is application software.
ffiE?T Firsq qd+rffi ffiq{ t I

(b) An analog computer is faster than a digital
computer.
qi-dT.T *.'qg{ fsf.Tc-€ +uq3 +1 gvn C tqi +
q-rd qrar t r

(c) The ruler is used to move the document up and
down.

6-trr EFr Br+q deT{z +1 e;qt qii s{} tg fsqr
qrmtr
(d) Two or more cornputers in a network cannot have
the same IP address.
afs ffit q\ .Tr q} * sTfrr-d suqgn Eil sqFr
rP Gq rfr a] s+-m t r

(e) Routers connect similar networks.
{rs& Trrn;T W q} *E} t , 5x2=10

2. Attempt the following questions:

1)'t)

f{q rrrn t stn {fuq'
(u) Discuss the various types of computers according
to purpose.
stvdi t enm qt q.szlrr + q-sT'ii q1 Rq+r
sifqq r 5

(b) What is the difference between General Purpose
Software and Tailor Made Software?
tet-i-s M{r 3P w+ro q$RI d€aq{ t
wrsf,{rtz 5

Or (3ilercD
(u) Wirat is workbook? Explain features of workbook.
e-f.gs Hr i ? {d.,g-+ si ffiuiilrer} sT qrcqt
qifqq r s

(b) How can you add slide transition to a slide show?
ran{s $ q Rr{s qrctvn F*s q-sn frEi qrfr
tz
a
-f. Attempt the following questions:

f+gT vfltf * sm dtrrq,
(a) What is an operating system? Name five com-
monly used operating systems.
ffiErr R€q Rr t ? s1q-q6' sqdrr q ent
qrA qiq ffiEq Rsq * qrq FeFsq r s

P.TO.

1272 4

(b) What do you rnean by Internet? F{ow has the
growth of the internet impacted the society?
5-ii-c t enq €r €rrg} e 7 E€t}z si qk +
srnq q) N qsnfqf, fsqt t ? s
Or (8[ern)
(a) Explain absolute, relative and mixed cell re-
ferencing in MS Excel with example.
!go({ro qq+d C qq}qe, R-frf.q *p p+trs
+f, \qtFdT *1 sqr6{q sftn qq-flr{q I s
(b) Discuss all types of Alignment in a Word
Document. How do we create Bullets in a
Document?
*d *qiz C affiF{fz * qq1 r-*.rir *1 fq*+qT
sifqq r q+ *qTfu t ec gt{ N wn s€t
€z

4. (a) What is spreadsheet? Explain different steps of
printing worksheet in Excel.
FM-c €r t 2 qdd c Tt{fr-c fiF€?T * rql,{-*{
T{q qFflr{q I 5
(b) Write syntax for any two finantcial functions with
examples.

ffi A qr$f-q|qd r$+{rq qi H*l sErflur
sfdffi fdfuq I s
Or (aTeren)
(a) What do you'mean by system software? Explain its
components.

1212
5

nse:q €I€*{t t 3Trffil RT iltrd t z gq* il€
5
q{flr{q I

(b) Exptain internet protocols with examples'
szrtz ffif, * cqrd{sr qft( qn.{r{q t 5

Penr B (sTr{rE)

statistical functions in MS
5. Write the syntax of any fwo
Excel.
qaqrq qr fir€w
Ms Excel C d{ * €fsf@a
ffin{q , '
Frequency Distribution'
6. (a) Complete the table for
Writedowntheformulaintheappropriatecells.
sn-{fd fq-d{ur t ftq
qRrfr * Wi 61ffiq I sF{d

+€ i qa fefw' E
7

B C D
A
30 1s 69
1 50 40
80 95 99
2 t2
18
34
8
-
JL 54 76

4
) Lower Limit Upper Limit FrequencY
,l
6 0 20
,l
.7
20 40
60 ?
8 40
?
I 60 80
,l
10 '80 100
P.TO.

t2'72 6

(b) Explain any two financial functions in Excel giving
the syntax and examples.
q{+d fi TErerur sTh ffiw tt gq +t{ A
stEif{r€ q+vn qdr{q I

Or (3[e[er|l
(a) Explain ratio analysis and its types with syntax.
3r-flrd ffiqur eft Eq* q"ER Fs-€w sft-d
qrrfr{q | 7

(b) Complete the following tabie for Regression
Analysis. Write down the appropriate formula in
the relevant cells.
xfrqrrqq ffiqq t f€q Frq sRufr Wi +ifeq t

{r{Frs +d C sF+a ql lttfurq r

A B C D E
1 Year Outnut Estimatdd output Slooe
,|
2 2001 100 ? lnterceot
a ,|
J 2002 125
4 2003 190 ?

5 2004 2t0 ?

7. (a) How are COUNT, COUNTA and COUNTIF
functions different from each other?

COUNT, COUNTA 3{h COUNTTF I6'F{FI
q*-*rtt+*f'rqd? 7

(b) Complete the table for first year of the Loan and
Irase Statement. Write down the formula in the
appropriate cells.

7
1272
q?r'r qd + frq ailr $ilr
elE €at"e gf +ifeu r

sFqa +d t qr ftfuq r
7
A B C D E
L Loan 120000
Amounl
2 Rate of 12% P.A.
Interest
J Time 3 Years 36
Months
4 Effective I
Rate of
Interest
5 Instalment ?
6 PERIOD OPENING INTEREST INSTALMEN'T CLOSING
BALANCE BALAI{CE
7
,|
? ? 2

Or (3rerc[r1
(u) Explain how charts are inserted in an Excel
worksheet.
q4+d q-d;rnie t era +t {iC s{t
d'? eq-flr{q r

7
(b) Write the formula for the following generalizecl
Payroll Statement for M/S ABC Limitecl
to
calculate gross salary of each employee.
Employees are paid Basic Salary, Dearness pay
(DP), Travel Allowance (TA) and Bonus:
DP is paid ar lSVo af Basic
TA is paid at 10Vo of Basic if Basic < 15000
otherwise at IZVI of Basic
Bpnus is paid at .SVo of c.ompany profit
Company profit is Rs. 500000
p T O.

1272 8

(a) M,/S ABc fro * q-&s 6ffi + ss€ +m{ 6i
rrsm * f{rq fqE{ wr*_iTrg-ds Ra €eiz tg
wr{ar fmFsq r *.ffi *1 qd }6a' ffiq }
(Dp), ut={I lTiTr (TA) 'ark *+s * Srrdn {€
sq;n ft;qr sm t,
DP {€ qrt 15Vo srqT fEs,'qr urrcr €
TA {€ }6q 61 107, fgr qrar t qR q€
< 15000 sraTsrT ry tt 12Vo t r

#{€'q.q-fr eTq 6l s7o t I

6rr{i dTcI €o 5,oo,ooo A | 7

A B C D E
1
I EMPLOYEE BASIC DP TA BONUS GROSS
NAME SALARY ,|
,l o 'l
2 ABC 15000
? ? ?
a
-) DEF 13000 ?
,l
4 GHI 17000
,| , ,|

5
6 COMPANY 500000
PROFIT

30000