Scribd
Upload
19 views9 pages

Practice - Rentalinfo

The document contains rental information for different car models - Rio, Sonet, and Sportage. It shows the rental fees by model, a table with customer names and details, totals by model, and analyzed data filtered by number of cars rented. A pivot table summarizes the total rental fees by each car model, with Sportage having the highest fees at $13,500.

Uploaded by

gabrielakistowdavis
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views9 pages

Practice - Rentalinfo

The document contains rental information for different car models - Rio, Sonet, and Sportage. It shows the rental fees by model, a table with customer names and details, totals by model, and analyzed data filtered by number of cars rented. A pivot table summarizes the total rental fees by each car model, with Sportage having the highest fees at $13,500.

Uploaded by

gabrielakistowdavis
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Model Rental Fee

Rio $2,100.00
Sonet $3,000.00
Sportage $4,500.00

First Name Last Name Car Model Rental Fee No. of Cars
Ben Jefferson Rio $2,100.00 4
Saidee Hudson Sonet $3,000.00 5
Norman Bill Sportage $4,500.00 1
Kai Wattson Rio $2,100.00 3
Will Quinn Rio $2,100.00 2
Richard Edwards Sonet $3,000.00 2
Lauren Daniels Sonet $3,000.00 2
Dana Valentine Sportage $4,500.00 4
Micheal Kennedy Sportage $4,500.00 3
Total

Greatest Least Number


Number of Cars Car Model of Cars Car Model
5 Sonet 1 Sportage
Total Rental Fees Incentives New Rental Fees
$8,400.00 $840.00 $1,260.00
$15,000.00 $1,500.00 $1,500.00
$4,500.00 N/A $4,500.00
$6,300.00 N/A $6,300.00
$4,200.00 N/A $4,200.00
$6,000.00 N/A $6,000.00
$6,000.00 N/A $6,000.00
$18,000.00 $1,800.00 $2,700.00
$13,500.00 N/A $13,500.00
$81,900.00 $4,140.00 $45,960.00
Rentalinfo Sorted by Model of Vehicle
First Name Last Name Car Model Rental Fee No. of Cars
Ben Jefferson Rio $2,100.00 4
Kai Wattson Rio $2,100.00 3
Will Quinn Rio $2,100.00 2
Saidee Hudson Sonet $3,000.00 5
Richard Edwards Sonet $3,000.00 2
Lauren Daniels Sonet $3,000.00 2
Norman Bill Sportage $4,500.00 1
Dana Valentine Sportage $4,500.00 4
Micheal Kennedy Sportage $4,500.00 3
Total
by Model of Vehicle
Total Rental Fees Incentives New Rental Fees
$8,400.00 $840.00 $1,260.00
$6,300.00 N/A $6,300.00
$4,200.00 N/A $4,200.00
$15,000.00 $1,500.00 $1,500.00
$6,000.00 N/A $6,000.00
$6,000.00 N/A $6,000.00
$4,500.00 N/A $4,500.00
$18,000.00 $1,800.00 $2,700.00
$13,500.00 N/A $13,500.00
$81,900.00 $4,140.00 $45,960.00
Filtered Data Showing Owners Who Are Renting Out More Than 3 Cars
First Name Last Name Car Model Rental Fee No. of Cars
Ben Jefferson Rio $2,100.00 4
Saidee Hudson Sonet $3,000.00 5
Dana Valentine Sportage $4,500.00 4
First Name Last Name Car Model Rental Fee No. of Cars
Dana Valentine Sportage $4,500.00 4
Filtered Data Showing Owners who are Renting Out more than 3 KIA Spotage Cars
First Name Last Name Car Model Rental Fee No. of Cars
Dana Valentine Sportage $4,500.00 4
Category and Rental Fee Pivot
Table
Car Model Sum of Rental Fee
Rio $6,300.00
Sonet $9,000.00
Sportage $13,500.00
Total Result $28,800.00

Total Rental Fee


35000

30000

25000

20000

15000

10000

5000

0
Rio Sonet Sportage
otal Rental Fee by Model

Sum of Rental Fee

Sonet Sportage Total Result

You might also like