4948353826

5-

QŁ (B)

(b)

Ar-tv.Tr thc follcwing usiiin MS-EXCEL Clven thc workshecf.

I jT" a	e	C 1
1 flte&Nsae	Jantar/	Febrcary
2 JMouSe	(£050	73CO
3 iMoafeor	50000	45000
•i i Keyboard	61 CC	5300
5 iPiito	65000	SOCCO
6 'Pen Dnve	1250	3100
2 iTotal
$ |AvCUgC
I c>
10 [Lowcst

QP Codę : 13915

/

o°

Write thc stępi to obuin thc fota:. Avcrage. Hlgheit an-J Lowest (<>& thc ntottth of January and for tbe mor.th of Februaiy in coluir.ns J^rrd C reipcctiycly.    '    s?T

Answer ur.yone lub^uestton frem (c). (d) ir. MS-EXC0tr.'

CO

Write tlie iteps to obtaintha year wise ceprcciation ar.d WDV Jr. columns C and D whejedeprwiatlon is computcd using redurirg balanca raethod. /5>.'

.sy

<d)

ExpUln thc folidwing bu lit Ir. fuoetionr in MS-EXCEL 1.PMT0 2.R0UND0 3.FVQ 4. COUNTO

7.INT0

5.CEOTNC0 6.NPER0

:>ll-Con. 2731-15.