Information and Communication Technology

Question 1

1One kilobyte (KB) is commonly taken as

Easy

A. 1,024 bytes B. 1,000 bits C. 8 bytes D. 100 bytes

Question 2

2The Insert tab is used to add

Easy

A. only margins B. tables, pictures, shapes and page numbers C. only bold text D. only colours

Question 3

3Which formula gives "Distinction" for 75+, "Credit" for 60–74 and "Fail" otherwise when the mark is in B2?

Hard

A. =IF(B2,"Fail") B. =VLOOKUP("Distinction") C. =IF(B2>=75,"Distinction",IF(B2>=60,"Credit","Fail")) D. =IF(B2>=60,"Credit","Distinction")

Question 4

4An app is downloaded on Android phones mainly from the

Easy

A. Google Play Store B. Recycle Bin C. Microsoft Word D. Windows Explorer

Question 5

5A full backup

Medium

A. deletes old data B. copies only system files C. copies all selected data every time D. copies only changes since the last backup

Question 6

6In mail merge, placeholders such as «FirstName» are called

Medium

A. merge fields B. cells C. bullets D. footnotes

Question 7

7SUMIF adds cells that meet a condition.

Easy

A. True B. False

Question 8

8A man-in-the-middle attack

Hard

A. floods servers B. deletes files only C. repairs networks D. intercepts communication between two parties

Question 9

9A cell shows #DIV/0!. This means the formula

Easy

A. contains text B. tried to divide by zero or an empty cell C. has too many digits D. is correct

Question 10

10A biometric fingerprint scanner is an example of

Easy

A. a printer B. a storage device C. an output device D. an input device used for identification

Question 11

11Which of these is a utility program?

Easy

A. a game B. a word processor C. a web browser D. disk clean-up tool

Question 12

12The data type for True/False values in Access is ___.

Easy

Your answer (fill in the blank)

Question 13

13All spreadsheet formulas begin with

Easy

A. @ B. # C. $ D. =

Question 14

14Precision agriculture uses more fertiliser everywhere.

Medium

A. True B. False

Question 15

15The Ribbon in Microsoft Word is

Easy

A. the status bar B. the ruler C. the band of tabs and commands at the top of the window D. a type of font

Question 16

16A field that uniquely identifies each record in a database table is the

Easy

A. form B. index C. foreign key D. primary key

Question 17

17Before posting about a brand, influencers should

Medium

A. hide that they are paid B. post fake reviews C. delete comments D. clearly disclose paid partnerships

Question 18

18Cloud storage files can be accessed from any device with internet.

Easy

A. True B. False

Question 19

19The name of a Wi-Fi network is its ___ (four letters).

Medium

Your answer (fill in the blank)

Question 20

20To save a useful web page so you can return to it quickly, you

Easy

A. print the history B. delete it C. bookmark it D. clear cookies