I think the interviewer (an Excel guru) ask this question to see how much I knew about Excel. If I had said something like "SUMIF" or another easy formula, it would seem like I don't use Excel enough. Definitely cite a more technical function, like PivotTables or VLOOKUP. If you don't know what those are, you may need to play around with Excel more...