The database Executives.xlsx contains salary and company data on 100 executives. For each of the following requirements, create a separate worksheet and extract the data from the original database.
a. Among the top five executives in terms of Salary, how many work in the oil industry?
b. What is the total compensation (salary, bonus, and other) for each of the executives who rank in the top 10 on this dimension?
c. How many executives work for companies in California or New York and have sales less than 4,000?
d. How many executives who work for companies in California or New York have sales less than 4,000 or assets above 10,000?