AND narrows down the search by adding more keywords that need to appear in your results, eg
‘film’ AND ‘Manchester’. The results will contain both these keywords.
Expression Boolean equivalent
Equals = Greater than > Less than <
Greater than or equal to >= Less
than or equal to <= Does not
equal <> And AND Or OR Not NOT
A count-controlled loop is used when the number of iterations to occur is already known.
There are two ways in which programs can iterate or ‘loop’:
count-controlled loops condition-controlled loops Each type
of loop works in a slightly different way and produces
different results.
A variable is a location in memory that we use to store data.
The three types of data you can enter into a cell are data, labels and formulas.
Data – values, usually numbers but can be letters or a combination of both.
Labels – headings and descriptions to make the spreadsheet easier to understand.
Formulas – calculations that update automatically if referenced data changes.
algorithm
A sequence of logical instructions for carrying out a task. In computing, algorithms are needed to design computer programs.