Year 9 Keywords Definitions

foreign key

validation rule

Boolean data

integer

real number or float

between ... and ....

>

<

not ...

'print' keyword in Python

int()

str()

string

input()

variable

loop / iteration

if

cell reference

worksheet

formula

function

conditional formatting

macro

cell link

IF function

VLOOKUP

COUNTIF

relative cell reference

absolute cell reference

MAX function

MIN function

record

field

table

database form

report

query

relational database

primary key

+ - * /

==

!=

else

elif

# (hash)