Excel Skills for Year 9 Students

Front

SUM function

Back

Front

AVERAGE function

Back

Front

Sorting data A to Z

Back

data in ascending order (smallest to largest or A to Z)

Front

Sorting data Z to A

Back

data in descending order (largest to smallest or Z to A)

Front

IF function

Back

Front

Filtering data

Back

only rows that meet specific criteria

Front

COUNT function

Back

Front

Formula bar

Back

to enter or edit formulas in Excel

Front

Relative cell reference

Back

reference that changes when formula is copied, e.g. A1

Front

Absolute cell reference

Back