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

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Finance Computer Packages (Saturday) Question Paper

Finance Computer Packages (Saturday)

Course:Bachelor Of Commerce

Institution: Kca University question papers

Exam Year:2009

1
UNIVERSITY EXAMINATIONS: 2009/2010
SECOND YEAR STAGE 2 EXAMINATION FOR THE DEGREE OF
BACHELOR OF COMMERCE
CMS 205: FINANCE COMPUTER PACKAGES (SATURDAY)
DATE: DECEMBER 2009 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a) Elaborate on how you can utilize the following short cut keys while using a spreadsheet for
financial manipulations.
a [Ctrl]+[Home]
b [Ctrl]+[End]
c [Ctrl]+[Arrow]
d [Alt]+[Page Up]
e [Esc]
f [Ctrl]+[;]
g [Ctrl]+[Shift]+[;]
h [Ctrl]+[Z]
i [Ctrl]+[O]
j [Ctrl]+[W]
[10Marks]
b) Describe the actions that each of the following spreadsheet formulae would accomplish
i. =IF (B1<B2, “Reject”, “Accept”).
2
ii. =IF (B4>0, B4*2%, 0)
iii. =IF (B4>0, “CREDIT”, “O/D”) [9Marks]

QUESTION TWO
a) How would you recognize a computer that is infected by viruses? [8Marks]
b) What are the possible risk reduction and control procedures that can be adopted to enhance the security
of finance computer applications? [12Marks]
3
QUESTION THREE
a) Citing specific examples and their uses, describe five classes of packaged software that can be used
alongside financial packages. [10Marks]
b) What are the merits to a firm that opts to use proprietary software for its financial operations?
[10Marks]
QUESTION FOUR
a) Elaborate on the key tests of feasibility that you would emphasize upon when assessing the suitability of
a system for use within a finance department [10Marks]
b) Analyze five critical system development lifecycle stages that you would emphasize upon when
considering successful installation of a new finance system for an organization. [10Marks]
QUESTION FIVE
a) Discuss the role of financial forecasting as accomplished through finance packages. [10 Marks]
b) To achieve a solid model that generates confidence and produces desired results in the financial
decision making process, model developers should adhere to some critical guiding principles. Emphasizing
the three major stages of financial modeling describe the major points of consideration to ensure a
successful finance model. [10 Marks]

Finance Computer Packages (Saturday) Question Paper

More Question Papers

Popular Exams