Metropolitan Transportation Authority Manager, Operations Strategies interview questions

The interview process started with a pre-screening test for your ability to use Excel and Access. Excel had you take information from an already created spreadsheet, then to create a new spreadsheet/workbook and put your answers on it. Questions included V-Lookups, sorting data, getting averages and totals, and understanding some of their vernacular. The access part asked you to create a query, rework some things in the query, and also create a cross-query. Next came a panel interview with the manager(s) and HR. This was a round robin type of interview where they had 14 pre-set questions that they took turns asking. There were times of pause where they would write down your answers to questions for documentation.