Chat with us, powered by LiveChat

Create and modify a PivotTable report and PivotChart report to analyze revenue from park concessions such as food, boat rentals, and golf fees.

You are to complete 3 GO 39-41 tasks.

39 Example:
Project Description:

In the following Mastering Excel project, you will help Lindsay Johnson, the Director of Parks and Recreation, create and modify a PivotTable report and PivotChart report to analyze revenue from park concessions such as food, boat rentals, and golf fees.

40 Example:
Project Description:

In this project, you will create a worksheet for Jacques Celestine, President of Jesse Jewelers, which analyzes loan options for a condo in Toronto that the company is considering purchasing. Jacques wants to provide a lodging facility for company visitors but would like to keep the monthly loan payment below $6,250. You will also define names for ranges of cells in a worksheet containing quarterly advertising costs.

41 Example:
Project Description:
In this project, you will add lookup functions to an order form. You will also use the Formula Auditing features and visual inspection to find and correct several types of errors.