Explore $11.$ Create a PivotTable to display the number of rentals and rental $ by rental month.

Rename the worksheet as Monthly Rentals. $($Hint: Select any Rental Date in the PivotTable, and

then on the PivotTable Tools Analyze tab, in the Group group, click the Group Field button to

open the Grouping dialog box. Use Months as the grouping field.$)$

Save the workbook, and then close it$.$Row Labels $|grad$ Number of Rentals

$\backslash$table$[[$Jul$,14],[$Aug$,16],[$Sep$,11],[$Grand Total,$41]]$

FIELD NAME

Renter

Furniture

Rental Date

Rental Period

Inc$$urance

Filters

Rows

: Months $($Rental$...$

: Rental Date

Search fields

Columns

Values

: Number of Rent..