In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective columns.
b. In row 34, the next blank row after the data, in the revenue and number of cars columns, calculate the sum of that column by adding the contents of the addresses of the cells resulting from the filter action (should be two values for Revenue and two values for NumCars).
c. Format the two values to match the data above in the particular respective column.
Year Quarter Location CarClass Revenue NumCars
2019 Q2 Airport Economy $368,286 2153
2019 Q4 Downtown Premium $431,761 2562
2019 Q4 Downtown Hybrid $431,140 2620
2019 Q1 Downtown Premium $424,833 2661
2019 Q4 Downtown SUV $431,029 2708
2019 Q1 Downtown Hybrid $425,127 2729
2019 Q1 Downtown SUV $424,718 2799
2019 Q3 Downtown Premium $494,587 3006
2019 Q3 Downtown Hybrid $494,669 3065
2019 Q4 Airport Premium $540,411 3082
2019 Q2 Downtown Premium $500,347 3101
2019 Q4 Airport Hybrid $541,112 3115
2019 Q2 Downtown Hybrid $500,601 3172
2019 Q3 Downtown SUV $495,372 3197
2019 Q4 Airport SUV $540,599 3231
2019 Q2 Downtown SUV $500,494 3251
2019 Q1 Airport Economy $499,117 3296
2019 Q1 Airport Premium $565,965 3418
2019 Q1 Airport Hybrid $565,721 3515
2019 Q3 Airport Economy $593,981 3555
2019 Q2 Airport Premium $599,690 3556
2019 Q1 Airport SUV $565,749 3623
2019 Q2 Airport Hybrid $599,005 3650
2019 Q2 Airport SUV $599,382 3783
2019 Q3 Airport Premium $658,374 3883
2019 Q3 Airport Hybrid $658,702 3927
2019 Q3 Airport SUV $658,241 4097
2019 Q2 Downtown Economy $641,168 4302
2019 Q3 Downtown Economy $681,155 4540
2019 Q4 Downtown Economy $704,556 4620
2019 Q1 Downtown Economy $718,651 4898
2019 Q4 Airport Economy $918,045 5224