Office Automation (CSCT2201)

Computer Science - COS

Semester: Second Semester

Level: 200

Year: 2018

1
REPUBLIC OF CAMEROON THE UNIVERSITY OF BAMENDA
Peace-Work-Fatherland P.O. Box 39 Bambili
Second Semester Examinations
School: HTTTC Department: Computer Science Option: ICT Level: 200
Course Code: ICT225 Course Title: Office automation
Lecturer: Dr. DADA Jean-Pierre Credit Value: 2
Date: Time: 1:30 hour Start Time: End Time:
Exercise 1: (38 marks) Write a program to fill all blank space of this figure. Do not forget the automatic
filling
Exercise 2: (20 marks). Describe from the windows desktop, how to design this figure (you do not need
program)
Exercise 3: Excel numbers rows and columns from the selected reference cell as:
Let us select as reference cell, E6; then E7 will have as formulae: R[+1]C. Give the formulae to be used
for: Cells E5, D6, F6, B4, F8 and cell F5. (12 marks).
www.schoolfaqs.net