5. A data analyst in a human resources department is working with the following selection of a spreadsheet:
| A | B | C | D | |
| 1 | Year Hired | Last 4 of SS# | Department | Employee ID |
| 2 | 2019 | 1192 | Marketing | |
| 3 | 2014 | 2683 | Operations | |
| 4 | 2020 | 1939 | Strategy | |
| 5 | 2009 | 3208 | Graphics |
They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 20142683 for the employee in row 3?
1 / 1 point
Correct
To create the ID 20142683 for the employee in row 3, the function is =CONCATENATE(A3,B3). CONCATENATE joins together two or more text strings. (A3,B3) are the locations of the strings to be joined.
Related Questions & Answers:
- You read an interesting article in a magazine and want to share it in the discussion forum. What should you do when posting? Select all that apply. 8.You read an interesting article in a magazine and want to share it in the discussion forum. What should you ... Read more...
- A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit. 8.A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit. 1 / 1 ... Read more...
- In the following query, FROM is telling the database to filter out data from the Orders table. 5.In the following query, FROM is telling the database to filter out data from the Orders table. 1 / 1 ... Read more...
- You’ve reached the share phase of the data analysis process. It involves which of the following? Select all that apply. 5. Scenario 1 continued You’ve reached the share phase of the data analysis process. It involves which of the following? ... Read more...
- While creating data visualizations for a slideshow, a data analyst considers, “What would help a stakeholder understand this data better?” The analyst is in the analyze step of the data analysis process. 2. While creating data visualizations for a slideshow, a data analyst considers, “What would help a stakeholder understand this data ... Read more...
- What do data analysts use to label the type of data contained in each column in a spreadsheet? 2. What do data analysts use to label the type of data contained in each column in a spreadsheet? 1 / 1 ... Read more...
