Office Automation Previous Paper 2015
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
1st Term Examination 2015
Paper: Office Automation (MS-Word/Excel/Power Point)
Time allowed: 3 hours
Max marks: 100
Note: Attempt any live questions. All questions carry equal marks. Mobile phone & Programmable calculators are not allowed.
Q2: What is page setup? Why it is important? Elaborate its components / options
Q3: What is the difference between thumbnail and document map. When these can
be useful for an user?
Q4: What is view? Explain Excel views in detail.
Q5: What is function? Write the syntax and purpose of the following sheet functions.
i) Sum ()
iii) Max ()
iv) Average ( )
Q6: What is presentation? Write steps to insert a slide. Write names of slide views.
Q7: Write short notes on any two of the following.
a) Master slide
b) Header and footer
c) Slide from files