The database Population.xlsx contains data on the populations of the 50 states from 1990 to 1999. For each of the following requirements, create a separate worksheet and extract the data from the original database.
a. Sort the states by population in 1999, from highest to lowest.
b. Were the 10 states with the highest population the same in 1999 as in 1990?
c. Which state had the largest percentage increase in population from 1990 to 1999?
d. Which states had populations of more than 2 million or less than 1 million in 1995?