Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Microsoft Question Paper

Microsoft

Course:Microsoft Certified System Engineering

Institution: Hi Tech Computer Diploma question papers

Exam Year:2011

NAME……………………………………………………ADM No ………………………………..
SIGNATURE…………………..DATE…….......
HI-TECH 1ST SEMESTER EXAM
INSTRUCTION TO CANDIDITE:
? Indicate your name and ADM No. number on top of each printout
? Write your name and index number on the diskette or CD-R
? Write the name version of the software used for each question attempted in the answer sheet
? Passwords should not be used which saving
? Answer all questions
? All answers must be saved in the storage medium
? Hand in all the printouts and the storage medium

b) i.) Create a copy of the document and save it as A:\HIV2 (2mks)
ii.) Drop cap the first letter in the passage (2mks)
c) Select the second paragraph of column 1 and set the line spacing to 2, (2mks)
d) Indent the first line of the second paragraph by 1.2cm(or 0.47’’) (2mks)
e) Change the character spacing for the heading to expanded. Save the changes as A;\HIV 3 (2mks)
2. a) The table below display the analysis of computer studies examination create a worksheet to appear as it is and store the information.
Save it as HI-TECH (10mks)
HI-TECH COLLEGE
COMPUTER STUDIES EXAMINATION ANALYSIS
ADM. NO NAME PART 1 PART 2 PART3
BC001
BC002
BC003
BC004
BC005
BC006
BC007
BC008
BC009
BC010
BC011
BC012 Catherine Muraa
Kibet Langatt
Jane Kariuki
Kariuki Chege
Odoung Anadate
Kunes Gilbert
Ngeno Kipkemoi
Tenket Bete
Gegonge Beatrice
Gilbert Sainra
Carotime Maina
Sarah Cherop 76
56
42
80
56
40
60
72
74
84
56
20 77
60
86
59
72
74
68
68
75
76
26
30 60
61
52
85
97
56
92
95
94
86
24
42
b) (i) Copy HI-TECH 1 and paste in sheet 2 of your work book and rename the sheet as HI-TECH 2
(ii) Add three columns and label them as total, mean score and remark. 2mks)
(iii) Compute the total marks and average for each student (4mks)
c) (i) input a validation rule that allows entry of whole number ranging from 0 to 100 only and a validation message that read “input data between ‘0’ and ‘100’ only “ when the validation rule is violated (4mks)
(ii) One student was left out in the list and you are asked to insert a row and enter date as follows: (3mks)
ADM NO Name part 1 part2 part3
BC013 Janeth chybet 70 60 85
d) (i) In the remark column, use a formula that can give remarks as follows. Student with a mean score above 80% “distinction”, above 60% “credit” above 40% “pass” and below 39% “fail”. Write the formula used in the space provided below. (8mks)

(ii) Save you work as HI-TECH 2 (2mks)
e) (i) HI-TECH education board (EEB) offer scholarship to a student who has ‘credit’ and has the best positive trend in three ‘part’ examination .Extract the data from HI-TECH 1 and use it to draw an appropriate graph that can be used to get a successful student to be offered scholarship.
Write the name of the student in the space provided below. (10mks)

(ii) Save the graph as scholarship. (2mks)
(iii) Print HI-TECH 1, HI-TECH 2, and the graph. (3mks)

Microsoft Question Paper

More Question Papers

Popular Exams