ICT mock test

A _________ identifies the location of a cell or group of cells in the spreadsheet.

• Cell wall

• Cell reference

• Cell membrane

__________ has an absolute column and a relative row, or an absolute row and a relative.

• Relative cell references

• Absolute reference

• Mixed reference

It shows data you wish to see while temporarily hiding the rest.

Is the physical rearrangement of data in ascending or descending order.

It is used to format cells using different colors, borders and font.

Cell reference is also known as ________.

What are the 2 types of sorting?

___________is arranging data in decreasing order.

This application is a spreadsheet/worksheet application.

• MS Word

• MS Excel

• MS PowerPoint

___________ is arranging data in increasing order.