$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 lafst 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