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

Office Application(Dcis 107) (Dbit 123) Question Paper

Office Application(Dcis 107) (Dbit 123)

Course:Computer Science & Business

Institution: Kenya Methodist University question papers

Exam Year:2013

TIME : 2 HOURS

Instructions:
Answer question one and any other two questions.
Question One
Define the term software.
(2mks)
State and explain the two types of software’s.
(4mks)
Give any three examples of wired processing software.
(3mks)
State any five database functions in Excel.
(5mks)
Explain the functions of the formula shown =D4 + D5 + D6.
(3mks)
What is an electronic spreadsheet? Is it the same as Microsoft excel? (4mks)
Define the following terms
Database.
(2mks)
Database management system.
(2mks)
Binary key.
(1mk)
Which category does Ms PowerPoint fall into?
(1mk)
Give any three examples of situation where power point can be useful.
(3mks)

Question Two
List and explain any five components of an excel workbook.
(10mks)
Explain what the formula below does = C6 + C7 + C8.
(3mks)
How many sheets does an excel workbook has by default and what are their default names.
(2mks)

Question Three
Give the appropriate keyboard shortcuts for accomplishing each of the following tasks in Ms Word.
(6mks)
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. (9mks)
Menu bar
Document title
Ruler
Status bar

Question Four
What is the usefulness of Ms Access?
(2mks)
List any five components of an Ms Access database.
(5mks)
State four benefits of using database management system.
(4mks)
Explain the uses of the following field data types in Ms Access. (4mks)
Date/time
Number

Question Five
Define the following terms
Internet.
(2mks)
Computer network.
(2mks)
State four advantages of computer networks.
(4mks)
Explain the following acronyms. LAN, MAN, WAN.
(3mks)
What is a WEB browser?
(2mks)
What are the benefits of using email?
(2mks)

Office Application(Dcis 107) (Dbit 123) Question Paper

More Question Papers

Popular Exams