Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?(n/a)ABCD1CustomerStreetTerritoryCountry2Terry Stewart707 Collins St, Docklands VIC 3008Australia3Che Price177 William St, Tennant Creek NT 0860Australia4Stanley Moss430 Little Collins St, CXI 6798Australia5Clay Casey250 Queen St, Sydney NSW 3000Australia1 point=RIGHT(4,C5)=LEFT(4,C5)=RIGHT(C5,4)=LEFT(C5,4)
Question
Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?(n/a)ABCD1CustomerStreetTerritoryCountry2Terry Stewart707 Collins St, Docklands VIC 3008Australia3Che Price177 William St, Tennant Creek NT 0860Australia4Stanley Moss430 Little Collins St, CXI 6798Australia5Clay Casey250 Queen St, Sydney NSW 3000Australia1 point=RIGHT(4,C5)=LEFT(4,C5)=RIGHT(C5,4)=LEFT(C5,4)
Solution
The correct function to extract Clay Casey’s four-digit postcode from the spreadsheet is =RIGHT(C5,4). This function will take the rightmost 4 characters from the cell C5, which is the postcode for Clay Casey.
Similar Questions
Select the correct answerThe result for the Postfix Expression ab+cd/- where a=5, b=4, c=9, d=3 isOptions2312645
What is the value of the postfix expression 6 3 2 4 + – *?*2 points7422-1840
The result for the Postfix Expression ab*cd*+ where a=2, b=2, c=3, d=4 isOptions12162215
The result for the Postfix Expression ab*cd*+ where a=2, b=2, c=3, d=4 isOptions15121622
The result for the Postfix Expression ab*cd*+ where a=2, b=2, c=3, d=4 isOptions22151216
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.