Free Printable ICT Worksheet Grade 8

1.

A field that stores data that is unique

a)

Key field

b)

Conditional formatting

c)

Absolute cell reference

d)

Cell reference

2.

The value of the cell will stay the same in every row of the table.

a)

Key field

b)

Conditional formatting

c)

Absolute cell reference

d)

Cell reference

3.

Means they take values from other cells in the spreadsheet

a)

Key field

b)

Conditional formatting

c)

Absolute cell reference

d)

Cell reference

4.

It is a format, such as cell colour, which is based on a logical test.

a)

Key field

b)

Conditional formatting

c)

Absolute cell reference

d)

Cell reference

5.

In Excel, rows are labeled by letters

a)

True

b)

False

6.

In Excel, columns are labeled by numbers

a)

True

b)

False

7.

Each ......................... stores one piece of data.

a)

Field

b)

Record

8.

The Auto-sum button will add up a group of numbers

a)

True

b)

False

9.

The columns of a table are called fields

a)

True

b)

False

10.

The rows of a table are called records

a)

True

b)

False

11.

The key field stores data that is unique

a)

True

b)

False

12.

The function is a cell content that starts with an equal sign and contains constants, cell references, and operations

a)

True

b)

False

13.

When inserting a formula, always start with (+)

a)

True

b)

False

14.

Conditional formatting is a format that is based on a logical test, such as cell color.

a)

True

b)

False

15.

The formula is a cell content that starts with an equal sign and contains constants, cell references, and operations

a)

True

b)

False

16.

We use the spreadsheet to organize data and make a data table

a)

True

b)

False

17.

Each ......................... stores all the data about one thing.

a)

Field

b)

Record

18.

............................. represent the columns of the table.

a)

Fields

b)

Records

19.

............................. represent the the rows of the table.

a)

Fields

b)

Records

20.

Select three advantages of organizing data as a table in a spreadsheet

a)

Sort and search the data

b)

Draw pictures

c)

Use formatting to pick out important facts.

d)

Use formulas to calculate new information

21.

Write the steps of making a data table in a spreadsheet.

(a)

22.

when the number in the cell is positive, it is considered as

a)

Surplus

b)

Shortfall

23.

when the number in the cell is negative, it is considered as

a)

Surplus

b)

Shortfall

ICT Worksheet Grade 8

Total questions: 23

Worksheet time: 12mins

Similar Resources on Wayground