I was in the position of that candidate before, and the interviewer refused to (do the analog of) letting me set up the spreadsheet, then vetoed me from the rest of the interviews.