Excel tests for analyst, finance and operations jobs come back to the same handful of tasks: look something up, total or count with conditions, handle dates, survive a missing value, and turn a total into a percentage.
Each question below is one of those tasks on a single employee table. Answer in column J, next to the question, using the input in column I where there's one. Interviewers care that the formula still works when the input changes, so refer to the input cell rather than typing the value into the formula.