Scs 114:Introduction To Spreadsheet Question Paper
Scs 114:Introduction To Spreadsheet
Course:Bachelor Of Science
Institution: Maseno University question papers
Exam Year:2010
MASENO UNIVERSITY
SCS 114:INTRODUCTION TO DATABASES AND SPREADSHEETS
Answer all questions
QUESTION 1
a)Explain the following data types used in access
i) Auto number
ii)Currency
iii)Date/Time
iv)Lookup wizard
b)Define the term normalization and explain the 1NF,2NF and the 3NF
c)Explain the following components of a DBMS
1.DML
2.DCL
3.Query language
4.Form Generator
5.Data Definition language
d)Explain what you understand by the term record
QUESTION 2
a)Differentiate between data sheet view and design view
b)Define a primary key and explain the procedure of inserting one in a table design view
c)Define a relationship and explain the four types
QUESTION THREE
a)State any three areas where spreadsheets are commonly used
b)List five advanages of electronic spreadsheets over worksheets
c)Define the following terms
i)Workbook
ii)Cell
iii)Row
iv) Columns
d)Explain the procedure of defining a range
e)Use the sample worksheet to find the answer to the following formulas
A B C D E
1MARK1MARK2MARK3MARK4MARK5
2 20 25 47 53 61
3 25 22 45 67 82
4 37 90 75 63 39
5 43 58 40 41 48
6 57 50 60 71 73
i)=SUM(A2:B3)
ii)=AVERAGE(B6:C6,E3)
iii)=Vlookup(33,A2:E6,5)
iv)=Countif(a3:c5.">40")
QUESTION THREE
a)Explain three ways in which you can print your work
b)List seven ways through which you can move around the worksheet
c)Discuss any typical DBMS Functions
More Question Papers