UNIVERSITY OF COLOMBO

1
UNIVERSITY OF COLOMBO SCHOOL OF
COMPUTING
IT1301 Fundamentals of Computer Systems and PC
Applications
DEGREE OF BACHELOR OF INFORMATION TECHNOLOGY
2
Past Paper Model Papers 2001-2002 Available at
www.bit.lk

• Computer Systems PC Applications
• MS-DOS Q50
• MS-Word Q40
• MS-Excel Q44, Q49
• MS-Access Q42

3
3 4 4 4
cd\
4
WASANA
2
3 4 4 4
md WASANA
cd WASANA
COPY \USERS\SAMANTHA\DOCS\P.
5
WASANA
2
3 4 4 4
cd ..
cd DAMMIKA\LEARN
COPY . \WASANA
6
WASANA
2
X
3 4 4 4
X
cd \USERS\SAMANTHA
del GAMES
rd GAMES
7
WASANA
2
4 4 4
cd ..\DAMMIKA\PERSONAL
del PERSONEL
rd PERSONEL
8
WASANA
2
4 4 4
cd \USERS
rd SAMANTHA
9
cd ..
WASANA
2
4 4 4
ANSWERS Total No. of files remaining is 13.
14 The sub directories SAMANTHA and DAMMIKA are
still remaining. The sub directories SAMANTHA,
GAMES, PERSONAL have been removed. No. of the
directories/sub directories remaining is 8.
9 There are 2 directories with the name WASANA
remaining in the diskette.
10
Convert Table in Left ? Table in Right
40)
(i) Insert table (ii) Split cells (iii) Select
cells (iv) Merge cells (v) Borders and
shading (vi) Distribute columns
evenly (vii) Decrease the column
width (viii) Select columns (ix) Delete
Cells (x) Bullets and numbering
11
Convert Table in Left ? Table in Right
(i) Insert table (ii) Split cells (iii) Select
cells (iv) Merge cells (v) Borders and
shading (vi) Distribute columns
evenly (vii) Decrease the column
width (viii) Select columns (ix) Delete
Cells (x) Bullets and numbering
(i), (ii), (iii), (iv), (vi), (vii), (x) (iii),
(iv), (v), (vi), (vii), (viii), (x) (ii), (iv),
(v), (vi), (vii), (ix) (iii), (iv), (vi), (vii),
(ix), (x) (iii), (iv), (vi), (vii), (viii), (ix)
12
44)
formula J26 is SUM(J21J25). formula K24 is
J21K23. formula L27 is AVERAGE(J23K26). formu
la M25 is COUNT(J21L26). formula N27 is
SUM(J24M27,N23,-35).
13
A B C D
E 1 1 SUMIF(A1A4,gt2) 2 2
MIN(A1A4) 3 MAX(A1A4) 4 D
COUNTA(A1A4)
49)
0 1 2 3
3 0 3 4
10 0 4 4
18 0 10 4
Value 1 in each of the cells C2, D2 and E2. Value
4 in each of the cells C4, D4 and E4. Values 3,
0, 3 in cells C1, C2 and C3 respectively. Values
0, 4, 4 in cells D2, D3 and D4 respectively. Value
s 18, 0, 0 in cells E1, E2 and E3 respectively.
14
Students registering the university Most suitable
data type
42)

• (i) Student Number (e.g. S-737) Text, Numbers?
• (ii) Students name Text
• (iii) Students address Text
• (iv) Students Age Text, Numbers?
• Students sex (male/female)
• Text, Yes/No, Lookup?
• (vi) Students faculty (Science/Arts/Law/Medicine)
  
• Text, Yes/No, Lookup?
• (vii) Students course Name (e.g. PC
  Applications)
• Text, Numbers?

15
Thank you