CSEC ICT Specimen Paper 1 (2017) Part 3

Text entered into a spreadsheet is aligned towards the left by default. These entries are called

• labels

• values

• formulae

• functions

Which of the following formatting features is unique to numbers in spreadsheets?

• Bold

• Italics

• Custom

• Indent

To centre the title rows of a spreadsheet across the columns

• centre align the title rows

• centre align the title columns

• merge and centre the title rows

• merge and centre the title columns

Which of the following is an example of a spreadsheet function?

• function sum(A1, A2, A3)

• sum = A1 + A2 + A3

• = sum(A1:A3)

• = A1 + A2 + A3

Which type of application is BEST suited to prepare a budget?

• Database

• Spreadsheet

• Word processor

• Desktop publishing

Which of the following statements is NOT true of primary keys?

• They are unique identifiers

• They are always in text form

• They do not contain blank values

• They may be composed of one or more attributes

A field in a table that appears as a match of the primary key in another table is called a

• foreign key

• candidate key

• secondary key

• composite key

Which database feature can be used to list the names of the male students from a particular class?

• Table

• Form

• Query

• Report

What is the MOST appropriate database data type for a field holding the marks from a class test?

• Text

• Numeric

• Currency

• Date/Time

What is the name given to a collection of related fields in a database?

• Table

• Field

• Record

• Column