Home » Microsoft » 77-727 » SIMULATION
SIMULATION
Overview
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.
In cell C8 on the “Summer Bookings” worksheet, insert a function that joins the customer “Lastname” to the customer “Firstname” separated by a comma and space. (Example: Campbell, David).
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. In cell C8 on the “Summer Bookings” worksheet, insert the following CONCAT function: “=CONCAT(E6 “, “D6)” OR “=E6& “, “, D6”.
References: https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6