using the dataset from: https://data.world/govex/human-resources-training

What is the city's overall vacancy rate?

a. 5.3%

b. 4.1%

c. 2.7%

d. 1.1%

e. 0.5%

Which Department's vacancy rate is the highest?

a. Department of Public Libraries

b.Department of Police

c. FIre and Rescue Services

d. Department of Transportation

e. Ethics Commission

3. Which Department has the highest volume of hiring actions over time (maximum), and which department has one of the lowest (minimum)?

Maximum: Department of Health and Human Services, Minimum: Office of Human Resources

Maximum: Department of Permitting Services, Minimum: Office of Human Rights

Maximum: Fire and Rescue Services, Minimum: Department of Police

Maximum: Office of Public Information, Minimum: Department of Public Libraries

Maximum: Department of Police, Minimum: Board of Appeals Department

How can I use formulas in excel to find the answers in excel?