Layer 1
Ask Questions

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 20201939 for the employee in row 4?

Correct
To create the ID 20201939 for the employee in row 4, the function is =CONCATENATE(A4,B4). CONCATENATE joins together two or more text strings. (A4,B4) are the locations of the strings to be joined.
 

Related Questions & Answers:

  1. You read an interesting article about data analytics in a magazine and want to share some ideas from the article in the discussion forum. In your post, you include the author and a link to the original article. This would be an inappropriate use of the forum. 8.You read an interesting article about data analytics in a magazine and want to share some ideas from the article ... Read more...
  2. The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal? 6.The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal? 1 / ... Read more...
  3. You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The column name for customer identification numbers is customer_id. What is the correct SQL clause? 6.You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The ... Read more...
  4. Fill in the blank: A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. To help solve this problem, a data analyst could investigate how many nurses are on staff at a given time compared to the number of _____. 2.Fill in the blank: A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than ... Read more...
  5. It’s time to create your presentation to stakeholders. It will include a data visualization that depicts the relationship between age and follow-up dental appointment attendance rates. For this, a doughnut chart will be most effective. 10. Scenario 2 continued The subject-matter experts are impressed by your analysis. The team agrees to move to the next ... Read more...
  6. If a cooking supply store wants to attract more customers, where can they advertise to better reach their target audience? Select all that apply. 1 / 1 point 3. If a cooking supply store wants to attract more customers, where can they advertise to better reach their target ... Read more...