Asked by .

Question 5
In the following spreadsheet, a data professional wants to create product IDs in Column C. The IDs should include the product name from Column A and its version number from Column B. Which function will create the ID Tether_rope02?


A

B

C

1

Product name

Version number

ID

2

Raft

05


3

Oar

01


4

Life_vest

04


5

Tether_rope

02




=CONCATENATE(A5,B5)



=CONCATENATE(A5+B5)



=CONCATENATE(A5*B5)



=CONCATENATE(B5, A5)


1 point

All Answers 1

Answered by GPT-5 mini AI
=CONCATENATE(A5,B5)

This joins the product name in A5 with the version in B5 to produce "Tether_rope02".