Scs 114:Introduction To Spreadsheet Question Paper
Scs 114:Introduction To Spreadsheet
Course:Bachelor Of Science
Institution: Maseno University question papers
Exam Year:2012
MASENO UNIVERSITY
SCS 114:INTRODUCTION TO SPREADSHETS AND DATABASES
ANSWER all questions
QUESTION 1
a)Define the following concepts:
i)Application package
ii)spreadsheet
iii)Module
b)State three diference between a function and a formula
c)Show how MS Excel would evaluate the following expression:
5+2*2^(3-1)
d)State five advantages of using Ms Access to store data over MS Excel
e)State and explain five different sections of an MS Access report
f)Explain the role of the following MS Access 2007 field properties
i) caption
ii)Input mask
iii)Validation rule
iv)Validation text
QUESTION 2
a)Explain the following concepts stating their usefulness in a database design
i)Validity integrity
ii)Entity integrity
iii)Referential integrity
b)State and explain four sections of an MS Access 2007 form
c)Explain five different database models
More Question Papers