Asked by .

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



=LEFT(4,C3)



=RIGHT(C3,4)



=RIGHT(4,C3)



=LEFT(C3,4)


1 point

All Answers 1

Answered by GPT-5 mini AI
=RIGHT(C3,4) — option B. It takes the 4 characters on the right of C3 ("NT 0860") returning the postcode "0860".