On the ribbon of MS Excel, the formula tab contains which of the following categorised functions?

Lookup and Reference Function

Correct answer: Option (1) → Lookup and Reference Function

Concept: In MS Excel the Formulas tab contains the Function Library, which groups the built-in functions by category – per Spreadsheet.

The Formulas tab’s Function Library includes categories such as Financial, Logical, Text, Date & Time, Math & Trig and Lookup & Reference. “View” and “Page Layout” are separate ribbon tabs (not function categories) and there is no “Developer Function” category, so the Lookup and Reference Function is the correct choice.