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

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

Office Application(Dbit 123) (Dcis 017)

Course:Computer Science & Business

Institution: Kenya Methodist University question papers

Exam Year:2012

TIME : 2 HOURS

Instructions:
Answer question one (compulsory) and any other two.
SECTION A
Question one
Distinguish between:
System software and application software.
(2mks)
Function name and argument, and explain where they are applied.
(6mks)
What is the main difference between Microsoft word and:
Note pad
WordPad
(3mks)
Describe the process of sending an e-mail message to several recipients, with each recipient receiving e-mails that are individually addressed by their first name.
(5mks)
Give the meaning of the following keyboard shortcuts.
(8mks)
Ctrl +B
Ctrl +I
Ctrl + U
Ctrl +S
Ctrl +Z
Ctrl +C
Ctrl + V
Ctrl + X
Describe how to insert a header in Ms Word.
(2mks)
List three areas of application of spreadsheets.
(2mks)
List three disadvantages of the use of spreadsheets.
(2mks)

SECTION B
Question Two
State three categories of functions found in excel.
(3mks)
If you want to apply the same formula across neighbouring cells in an excel. Workbook, how do you duplicate the formula?
(3mks)
State five methods of graphical representation of numeric data that can be used in an excel worksheets.
(5mks)
Describe the procedure of creating a chart or a graph in excels. (9mks)

Question Three
List five programs found in the Microsoft office suite and describe their applications.
(10mks)
List five components of a Ms access database.
(5mks)
List five benefits of using a database.
(5mks)

Question Four
Discuss the two options that can be used to create a form in MS access.
(4mks)
Discuss the two options that can be used to create a report in MS access.
Give five examples of real-life situations in which a PowerPoint presentation would be used.
(5mks)

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

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams