$1\mathrm{.}7$ The manager would like to start creating a "Guest ID$"$ that can be used by the cleaning staff. In cell B$4),$ create a guest ID with the pattern: Guest Last Name Room: Room # of Guests. For example, if there are two guests with the last name of West staying in the Coolidge room the guest id would be "West Room: Coolidge $2"$ without the quotation marks.

Use the CONCAT $($or CONCATENATE$)$ function.

Reference the Guests Last Name, Room and # of Guests in your function.

Pay close attention to the spaces in the Guest ID$.$

Copy and paste the function down the column to create the "Guest ID$"$ for the other transactions.