Spreadsheets 1

Question 1

Spreadsheet

Answer 1

Application package used to process and display financial/statistical information

Contains one or more worksheets used to present/manipulate data.

Question 2

Data type

Answer 2

Defines the type of data associated with the field, e.g. string

Question 3

Cell reference

Answer 3

Address or location of a certain cell

Question 4

Conditional Formatting

Answer 4

Used to change the appearance/formatting of a cell based on conditions

Question 5

Data validation

Answer 5

Ensures that data entered is reasonable and within acceptable boundaries.

Question 6

Relative Cell Reference

Answer 6

Cell reference which is relative to the current cell.