77-727 Excel 2016: Core Data Analysis - Manipulation - Presentation

Loading demo links...

Showing 4–5 of 5 questions

Question 4

SIMULATION

Project 6 of 7: Bike Tours

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).

Answer is in the explanation below.

Question 5

SIMULATION

Project 6 of 7: Bike Tours

Overview

You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.

On the “Summer Bookings” worksheet, remove the table functionality from the table. Retain the cell formatting and location of the data.

Answer is in the explanation below.