Bait and switch at an interview

I just need to vent. I had a third round interview today and was told there would be a skills test in Excel..cool... Surprise it was not it excel but Google sheets. I have not worked in sheets much so

I just need to vent. I had a third round interview today and was told there would be a skills test in Excel..cool... Surprise it was not it excel but Google sheets. I have not worked in sheets much so this threw me but I went to the help section to see if what the swap out would be formulas. What they wanted done could be done more accurately with other functions than formulas in Excel. I failed as I couldn't find any formulas that fell into what was being asked. I apologized and then explained how I would completed in Excel with the old formulas and with different functions and pivot tables. I also offered to complete the task at home in Excel. This was so embarrassing And frustrating... Does this happen often?