Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?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=LEFT(4,C5)=LEFT(C5,4)=RIGHT(4,C5)=RIGHT(C5,4)4.Question 4
Question
Question 3In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?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=LEFT(4,C5)=LEFT(C5,4)=RIGHT(4,C5)=RIGHT(C5,4)4.Question 4
Solution
Para extraer el código postal de cuatro dígitos de Clay Casey en la celda C5, se debe utilizar la función que toma los últimos cuatro caracteres de la cadena de texto. La función correcta es:
=RIGHT(C5,4)
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 isOptions15121622
The result for the Postfix Expression ab*cd*+ where a=2, b=2, c=3, d=4 isOptions22151216
Which function (or combination of functions) can be used to extract the first four characters of a string in MS Excel, the length of which doesnt vary?AFIND and SUBSTITUTEBFINDCLEFTDLEN and LEFT
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.