The Function Library is found on the Formulas tab of the Ribbon in Microsoft Excel.

Quick Scoop

  • The Formulas tab groups all tools related to creating and managing formulas, including the Function Library.
  • In the Function Library group, you can insert functions, browse by category (Math, Text, Logical, etc.), and access AutoSum and more functions.
  • Other common tabs like Home , Insert , or Page Layout do not contain the Function Library group; that group is specific to the Formulas tab.

So if you are asked, “Which tab on the Ribbon contains the Function Library?”, the correct answer is: Formulas tab.

TL;DR: The Function Library is on the Formulas tab of the Excel Ribbon.

Information gathered from public forums or data available on the internet and portrayed here.