S3 CPA SLS SST 1 Quiz

What built-in-function in spreadsheet allows user to format the appearance of data in a cell or range of cells based on one or more criteria (conditions).

• conditions

• formatting

• conditional formatting

• automatic formatting

What is the name of the process of arranging data into a meaningful order in spreadsheet.

• arranging

• organizing

• sorting

• formatting

We can sort text data alphabetically, in ​ (a)   order (from ‘A’ to ‘Z’) or in ​ (b)   order (from ‘Z’ to ‘A’).

• ascending
• descending

Conditional formatting recalculates the data in the cell.

• True

• False

Conditional formatting helps us to better identify data.

• True

• False

Conditional formatting can change the font and fill colour of cells automatically based on their contents.

• True

• False

Sorting allows us to organize data systematically.

• True

• False

Sorting can only be done on cells containing numeric data.

• True

• False

We can sort data in ascending or descending order based on the contents of a column.

• True

• False

Refer to the spreadsheet below.

Conditional formatting will be applied to cell B5 to B8, where cells with values less than 10 are formatted with red-coloured text.

(a)