CSEC ICT June 2020 Paper 1 Part 3

Which part of the central processing unit (CPU) coordinates its activities?

• Register

• Control unit

• Main memory

• Arithmetic logic unit

Before purchasing a computer, James was given a sheet with the following hardware specifications.

Intel Pentium IV, 3.6 GHz, 64 bit

2 GB, 533 MHZ, 50 RAM , HDD, 160 GB, 7200 rpm, SATA

The word use of the computer is

• 2 GB

• 64 bit

• 7200 rpm

• 533 MHz

Which type of interface allows the user to communicate with the computer system by keying in instructions?

• Menu driven

• Graphical user

• Touch sensitive

• Command-driven

A webmaster is important to the company because he/she

• is responsible for the company's website

• assigns web addresses to all users in a company

• backs up files and stores the disks at another location

• monitors the shutting down of competitors' websites

Which of the following is an example of a correctly formatted e-mail address?

• Lana.happy@net

• @lana.happynet

• [e-mail]

• Lana@happy@net

Which of the following types of software should be used for applications that involve repetitive numerical calculations?

• Database

• Presentation

• Spreadsheet

• Word processing

Selecting or highlighting a paragraph creates a

• file

• block

• merge

• document

The following formula is located in position B6 of a spreadsheet.

= B3 + B4 + $B$5

What would be the resulting formula if the initial formula was copied to the position located immediately on the left?

• C3 + C4 + C5

• A3 + A4 + A5

• A3 + A4 + $B$5

• C3 + C4 + $B$5

In creating a query, a student entered the following criteria for the date field.

>= 05/11/2017 and <= 05/14/2017

The output will show days

• after 14 May 2017 only

• from 11 to 14 May 2017

• before 11 May and after 14 May 2017

• between 14 May and 5 November 2017

Spreadsheet formulae use

• values or labels

• labels or cell addresses

• values, ranges or cell addresses

• values, labels or cell addresses