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!

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

Scs 114:Introduction To Spreadsheet Question Paper

More Question Papers

Popular Exams