LITTLE LONDON HIGH SCHOOL

Nurturing Rising Stars to the Utmost

INFORMATION TECHNOLOGY

Examination Booklet

Student’s Name _____________________________________________

Class: 11 Business

Date_______________________________________________________

Instructions:

1. This question paper consists of TWO sections:

Section A: Multiple Choice Questions [40 mks]

Section B: Short Answer Questions [60mks]
2. You have 11/2 hours to answer all questions
3. Number the answers correctly according to the numbering system used on this paper.

4. Do NOT write in the right-hand margin.

5. Read ALL the questions carefully

6. In general, a mark is allocated per fact. A 2-mark question would therefore require two
facts, etc.

7. Write neatly and legibly

For Official Use Only

Questions Score

Teacher’s Signature: ______________________________

DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO

DO SO

Section A Multiple Choice Questions 1 mk each

Answer all the following questions by CIRCLING the appropriate response that makes the
statement true.

1. Which of the following function is NOT a feature of a spreadsheet?

a. hold financial or accounting data
b. simulate a traditional physical spreadsheet

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 c. capture, manipulate and display data
d. perform advanced text processing
2. Which statement is true of a spreadsheet package?
a. Can be used as a modelling tool
b. Cannot handle graphics
c. Cannot handle data records
d. Does not have statistical function
3. Which of the following is not an underline option in the format cells dialog box?
a. Double
b. Single Accounting
c. Double Accounting
d. Single Engineering
4. Formulas in Excel start with:
a. %
b. =
c. +
d. –
5. The cell reference for cell range of G2 to M12 is _______
a. G2.M12
b. G2;M12
c. G2:M12
d. G2-M12
6. If you need a text to show vertically in a cell. How will you achieve this?
a. Choose Vertical on Text alignment in Format Cells dialog box
b. Choose 90 Degrees in Orientation of Format Cells dialog box
c. Choose Distributed from the Vertical drop down list of Format Cells dialog box
d. Choose Center Across Selection from Horizontal combo box in Format Cells
dialog box
7. You can automatically adjust the size of text in a cell if they do not fit in width by ..
a. Double clicking on the right border of column header
b. From Format choose Columns and then Auto-fit Selection
c. From Format Cells dialog box mark Shrink to fit check box
d. All of above

8. Formatting a cell in Currency, you can specify

a. Decimal Places
b. Currency Symbol
c. Both of above
d. None of above
9. Formatting a cell in Number format you can’t set
a. Decimal Places
b. Use 1000 separator
Prepared by Little London High School Business Education Department ©
Your Game is as Good as Your Practice
 c. Negative numbers
d. Currency Symbol
10. What is entered by the function =today()
a. The date value for the day according to system clock
b. The time value according to system clock
c. Today’s date as Text format
d. All of above
11. Which function will you use to enter current time in a worksheet cell?
a. =today()
b. =now()
c. =time()
d. =currentTime()
12. Long text can be broken down into many lines within a cell. You can do this through…
a. Wrap Text in Format >> Cells
b. Justify in Edit >> Cells
c. Text Wraping in Format >> Cells, Layout tab
d. All of above
13. Why is a spreadsheet seen as a table?
a. It processes lots of data.
b. It captures and display data.
c. It has cells (rows and columns.
d. It has space to handle calculations.
14. _______ are pre-existing forms that are pre-formatted and include standard text and
formula.
a. Charts
b. Functions
c. Templates
d. Worksheets

15. A cell is a ____________ that can hold or display data.

a. combination of a column and a row
b. a rectangular area in the table where a column and a row intersect
c. a horizontal area in a table
d. a vertical area in the table

16. Which definition of 'value' is correct?

a. An entry in a cell.
b. The result of a calculation.
c. An item on the formula bar.
d. An item of data that can be processed
17. What is a worksheet?
a. A line of cells (normally horizontal) with numerical related data.
b. The upper half of the rectangular area in the table in which data is placed.

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 c. A range of vertical cells in the table in which non-numeric data is placed.
d. The grid of rows and columns used by a spreadsheet program

18. What is a function?

a. A formula created by the user to handle complex operations but has to be used in
absolute referencing, only.
b. A predefined formula in the spreadsheet package that can automatically calculate
results.
c. An instruction to perform operations on numeric values which are in given
horizontal ranges, only.
d. A formula created by the user to handle complex operations but has to be used in
relative referencing, only.
19. D1:G6 is best described as a
a. Label
b. Formula
c. Value
d. Range
Questions 20 to 23 are based on the following spreadsheet.

20. Which expression will determine the number of numeric values in the range, B1:B4?
a. =COUNTA( B1:B4)
b. =COUNTN(B1:F4)
c. =COUNTIF( B1:B4)
d. (D) =COUNT(B1:B4)

21. Which expression will compute the total of the values in cells B1, B2, B3 & B4?
a. =SUM(B1:B4)
b. =SUM(B1+B4)
c. =SUM(B1_B4)
d. =SUM(B1-B4)
22. What would the function =RANK(C3,C1:C4,1), return based on the given list?
a. 1
b. 2

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 c. 3
d. 4

23. What would the function,=VLOOKUP(2,B1:C3 ,2,TRUE), return?

a. 5
b. 7
c. 8
d. 9
24. The text `Quarterly Sales' at the top of a column is best described as a
a. Label
b. Formula
c. Range
d. Value
25. In the formula , =A5 + D$26 , A5 is best described as a
a. Function
b. absolute value
c. mixed reference
d. relative reference
26. ###### is displayed in a cell when…
a. A negative date is entered in the cell
b. A negative time is entered in the cell
c. The column is not wide enough
d. All of the above

27. Which statement best describes a database?

a. A collection of tables
b. Tables that are in sequence
c. Tables of related information
d. A collection of related tables
28. A database may be correctly described as a…
a. Collection of related data on an entity
b. Flexible data file
c. Repository of information
d. Collection of entities
29. Little London High School maintains a database containing tables related to its students
and subjects offered. Which of the following represents a table within the database?
a. A student name
b. A student record
c. All the personal data on students
d. The age of the students
30. A student is an ________ in relation to a school’s database.
a. Entity
Prepared by Little London High School Business Education Department ©
Your Game is as Good as Your Practice
 b. Alternate key
c. Individual
d. Attribute
31. Which are entities of a patient database in a doctor’s office which has one doctor?
a. Patient, doctor
b. Patient, visit
c. Doctor, sickness
d. Patient, office
32. Which of the following item should be used as a primary key in a student database?
a. First name
b. Identification number
c. Last name
d. Age
33. Which statement correctly describes ‘candidate key’?
a. It uniquely identifies attributes in a table
b. It is a combined key
c. It uniquely identifies rows in a table
d. It can always be used as a secondary key
34. Which statement correctly describes an alternate key?
a. Any key that can be joined to another key in identifying a tuple in a table
b. Any of the set of attributes that may be used as key
c. Any key that uniquely identifies a tuple in a table
d. Any of the set of keys that may be used as a secondary key
35. Which statement correctly describes a foreign key?
a. A key for which a matching primary key column is found in all other tables of
the database
b. A key in a table that is duplicated to identify a tuple in another table.
c. A field in a relational table that matches the primary key column of another table.
d. A key that is replicated throughout all tables in a database.
36. Which statement indicates a limitation of databases?
a. Multiple view of database are not allowed
b. High volume of data cannot be handled
c. There are securities concerns
d. Queries are not allowed
Question 37 to are based on the following narrative
Caribbean Commercial Bank (CC(B) stopped using tables to store data for each
department and started using a database to serve the entire organization

37. Which statement is true?

a. Data entry should be more tedious.
b. Information will be more efficiently retrieved.
c. Information retrieval will be more tedious.
d. There will be no errors in the data
Prepared by Little London High School Business Education Department ©
Your Game is as Good as Your Practice
 38. Which statement is false?
a. Less queries will be allowed.
b. Queries will be more efficient.
c. There will be more security concerns.
d. There will be less data redundancy.
39. CBB will now be able to ______ the data.
a. Enter
b. Process
c. Query
d. Standardize
40. CBB will now be able to ____________
a. Enter data much faster
b. Prepare reports more efficiently
c. Store an unlimited amount of data
d. Prevent data entry errors

SECTION II
1. The accounts department of the beverage company has prepared a summary sheet
showing beverage sales for 2009. This summary is given in the spreadsheet listed below:

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 a. List TWO types of data that can be entered into a spreadsheet.
________________________________________________________________________
___________________________________________________________________2mks
b. Write the formula that was inserted into B7 to compute the total sales
______________________________________________________________ 1mk
c. What formatting feature was used on Sales figures?
___________________________________________________________1mk
d. All beverages with sales under 100 00.00 are given a status of ‘POOR’ while others are
given a status of ‘GOOD’. Write a function that should be entered into cell C2 to show
the status of the beverage ‘soda’.
_______________________________________________________________3mks
Total 7 marks

2. A beverage manufacturer uses a database that contains two tables to store information on
customers.
TABLE 1: CATEGORY

TABLE 2: CUSTOMER

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 a. List TWO properties of a field
________________________________________________________________________
_________________________________________________________________2mks
b. Explain how you would delete a field from a table
________________________________________________________________________
___________________________________________________________________2mks
c. Give the name of the primary key in the CUSTOMER TABLE
___________________________________________________________________1mk
d. Write a query to find ALL distributors with YTD SALES greater than50 000.00
________________________________________________________________________
________________________________________________________________________
________________________________________________________________3mks
Total 7 marks

3. The director of Emrock is creating a budget for the company's small response division,
and produces the following spreadsheet which has been sorted.

a. Write the formula to be inserted into cell D2 to calculate the total cost of the digital
forensic tool kit.
________________________________________________________________________
________________________________________________________________________
________________________________________________________________(3 marks)

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice
 b. Outline how to insert the formula in (a) into cell D3 to D8 in order to calculate the totals
of the remaining items without retyping the formula.
________________________________________________________________________
________________________________________________________________(2 marks)
c. State
i. the field that was used to sort the spreadsheet
__________________________________________________________
ii. the order used to sort the field.
____________________________________________________(2marks)
Total 7 marks
4. The Technical Council has created a database with one table named SKILL to store
information on persons certified as Assessors and Trainers. Part of the database is shown
below.

a. Name TWO data types used in the skill table.

_____________________________________________________________________
___________________________________________________________2 marks
b. If the data were sorted by the DOE(MM-DD-YYYY) field in ascending order, state
the last name of the person who would be at the top of the sorted table.
___________________________________________________________(1 mark)

c. Write a query to find all males (M) who are Assessors in the table below.

2 marks

d. How many records will be displayed in the result of the query? -

_____________________________________________________________(1 mark)
e. A report was created from the table and the records were grouped by a field. State the
names of TWO appropriate fields which could be used to group the records.
_____________________________________________________________________
____________________________________________________________ (2 marks)
Total 8 marks

END OF EXAMINATION

Prepared by Little London High School Business Education Department ©

Your Game is as Good as Your Practice