Question $3$

In this spreadsheet, which function will extract Che Price$$s four$-$digit postcode?

A

B

C

D

$1$

Customer

Street

Territory

Country

$2$

Terry Stewart

$707$ Collins St$,$ Docklands

VIC $3008$

Australia

$3$

Che Price

$177$ William St$,$ Tennant Creek

NT $0860$

Australia

$4$

Stanley Moss

$430$ Little Collins St$,$

CXI $6798$

Australia

$5$

Clay Casey

$250$ Queen St$,$ Sydney

NSW $3000$

Australia

$1$ point

$=$LEFT$($C$3,4)$

$=$RIGHT$($C$3,4)$

$=$RIGHT$(4,$C$3)$

$=$LEFT$(4,$C$3)$