4. You are working with the following selection of a spreadsheet:
| A | B | |
| 1 | Customer | Address |
| 2 | Sally Stewart | 9912 School St. North Wales, PA 19454 |
| 3 | Lorenzo Price | 8621 Glendale Dr. Burlington, MA 01803 |
| 4 | Stella Moss | 372 W. Addison Street Brandon, FL 33510 |
| 5 | Paul Casey | 9069 E. Brickyard Road Chattanooga, TN 37421 |
In order to extract the five-digit postal code from North Wales, PA, what is the correct function?
1 / 1 point
Correct The correct syntax is =RIGHT(B2,5). The RIGHT function returns a set number of characters from the right side of a text string. B2 is the specified cell. And 5 is the number of characters to return.
Related Questions & Answers:
- Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data. 1.Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and ... Read more...
- Structured query language (SQL) enables data analysts to communicate with a database. 8.Structured query language (SQL) enables data analysts to communicate with a database. 1 / 1 point True ✓ False CorrectSQL allows ... Read more...
- If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? 3.If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they ... Read more...
- A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ways could a data analyst help solve this problem? Select all that apply. 2.A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ... Read more...
- A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe? 2. A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe? ... Read more...
- Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from that investment. 7. Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from ... Read more...
