Excel Chapter 4 Assessment - Express
abparsley
Parsley_Excel_Ch04_Assessment_Express.xlsxAnnualData
| Express Car Rental | ||||||||||||||
| Annual National Rental Data/ Vehicles Rented by Type | ||||||||||||||
| Created by Thomas Reynolds | ||||||||||||||
| Auto Type | Jan | Feb | Mar | Apr | May | Jun | Semi-Annual Total | Jul | Aug | Sep | Oct | Nov | Dec | Annual Total |
| Green Collection | 298 | 250 | 366 | 522 | 477 | 699 | 2,612 | 899 | 862 | 566 | 855 | 588 | 288 | 6,670 |
| Compact/Midsize | 500 | 700 | 890 | 755 | 899 | 788 | 4,532 | 566 | 425 | 655 | 547 | 689 | 588 | 8,002 |
| Full-size/Standard | 250 | 355 | 652 | 553 | 650 | 800 | 3,260 | 788 | 1,056 | 852 | 544 | 455 | 977 | 7,932 |
| SUV/Minivan | 150 | 260 | 555 | 456 | 556 | 652 | 2,629 | 1,230 | 1,855 | 658 | 578 | 355 | 1,155 | 8,460 |
| Sports car | 200 | 350 | 355 | 233 | 155 | 132 | 1,425 | 355 | 523 | 458 | 598 | 168 | 198 | 3,725 |
| Relic | 54 | 122 | 224 | 126 | 98 | 155 | 779 | 119 | 166 | 137 | 169 | 99 | 66 | 1,535 |
Oct Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 855 547 544 578 598 169 Nov Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 588 689 455 355 168 99 Dec Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 288 588 977 1155 198 66
