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

Office Applications(Dcis 107) (Dbit 126) Question Paper

Office Applications(Dcis 107) (Dbit 126)

Course:Computer Science & Business Information

Institution: Kenya Methodist University question papers

Exam Year:2012

TIME : 2 HOURS

Instructions:
Answer Question ONE and any other TWO Questions.
Question One (Compulsory)
(i) Define the term software.
(2 Marks)
(ii) State and explain the TWO types of softwares. (4 Marks)

Give any THREE examples of word processing software.
(3 Marks)
State any FIVE database functions in Excel.
(5 Marks)
Which category does Ms Point fall into, and what is it ideal for.
(3 Marks)
What is an electronic spreadsheet? Is it the same as Microsoft Excel?

(4 Marks)
Define the following terms.
Database.
(2 Marks)
Database management system
(2 Marks)
Primary Key
(1 Mark)

(i) which category does Ms Powerpoint fall into?.
(1 Mark)
(ii) Give any THREE examples of situations where power point can be
useful. (3 Marks)

Question Two
(i) List and explain any FIVE components of an EXCEL Workbook.
(10 Marks)
(ii) Explain what the formula below does = C6 +C7 + C8. (3 Marks)

How many sheets does an Excel workbook has by default, and what are their default names.
(2 Marks)

Question Three
Give the appropriate keyboard shortcuts for accomplishing each of the following tasks in Ms Word.
(6 Marks)
How to bold text.
How to copy text to the clipboard.
How to paste text.
Underlining text.
Double-underline text.
Explain the purpose of the following basic features of Ms Word.
(i) Cursor position
Menu Bar
Document Title
Ruler
Status Bar

Question Four
(i) What is the usefulness of Ms Access.
(2 Marks)
(ii) List any FIVE components of an Ms access Database. (5 Marks)

State FOUR benefits of using a database management system.
(4 Marks)
Explain the uses of the following field data types in Ms Access.
(4 Marks)
Date/Time.
Number.

Question Five
Define the following terms.
Internet
(2 Mark)
Computer Network
(2 Mark)

State FOUR advantages of Computer Networks.
(4 Marks)
Expand the following acronyms: LAN; MAN: WAN
(3 Marks)

(i) What is a WEB BROWSER?
(2 Marks)

(ii) What are the benefits of using email? (2 Marks)

Office Applications(Dcis 107) (Dbit 126) Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams