CIE A-Level Spreadsheet Vocabulary Test

These are examples of what spreadsheet feature?

used to navigate from one sheet to another and are usually at the bottom of a spreadsheet.

cells that are adjacent to each other and go from top to bottom or bottom to top vertically.

this is data used for testing the boundaries of a range or limit check.

Mathematical operations carried out using cell data that feature operators like * + - / .

Which of these is an example of a totally relative cell reference?

A spreadsheet can have many of these, like pages in a book.

'age of child' has an acceptable range of 5-17. Which of these show extreme abnormal test data.

Data that should be accepted by a model or system being tested;

A group of cells, usually contiguous, e.g. A1:D11

A function inside another function is called a....

Very specific operations carried out on cells, using a keyword, e.g. AVERAGE or SUM

the small rectangular sections used to enter data such as text, numbers or symbols

Which of these is a totally absolute cell reference?

cells that are adjacent to each other and go from left to right or right to left horizontally

this is data that should not be accepted when testing or using a system.