Normal distribution table and IRR

Hi,

Given that we will be given BSOP calculator during the CBE exam (and the spreadsheet NORMSDIST function), will we need normal distribution table in any type of questions? If so, could you please specify a topic for such a question?

I also wonder if it is okay to calculate IRR/YTM using the spreadsheet IRR function or by solving by trial and error instead of interpolation.

Thanks,
Giga