1.3 Spreadsheets

Question 1

Spreadsheet

Answer 1

A piece of software used to work out calculations. It can include both text and numbers.

Question 2

Formula

Answer 2

This is used to do every single calculation in the spreadsheet eg. A1*B2.

Question 3

Function

Answer 3

This is used to do a very specific job within the spreadsheet eg. SUM, MAX.

Question 4

Conditional formatting

Answer 4

This allows the user to include aspects like cell shading or font colour to cells if they follow a specified condition.

Question 5

Validation

Answer 5

A way of ensuring that data entered is of the correct range type, length or is present.