Question: Question 3 In this spreadsheet, which function will extract Che Price s four - digit postcode? A B C D 1 Customer Street Territory Country

Question 3
In this spreadsheet, which function will extract Che Prices 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(C3,4)
=RIGHT(C3,4)
=RIGHT(4,C3)
=LEFT(4,C3)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!