In this project, you will use scenarios and a scenario summary to analyze car purchasing options. A large amount of data about car gas consumption was downloaded from https://explore.data.gov/d/9un4-5bz7 and are explained at this Web site: http://www.epa.gov/greenvehicles/Aboutratings.do. You will use custom filtering to find the data you are interested in and copy it from this very large data set to another worksheet. You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subset of data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solver to solve a business problem to help you pay for your new car.
