What term describes a preset formula used in Excel to perform calculations and prevent common syntax errors?

• A. Macro
• B. Script
• C. Formula
• D. Function

Answer: (D)

Functions are built-in, predefined calculations in Excel. They’re designed for a specific operation and require arguments in a defined way, so Excel enforces the proper syntax and input types. This standardization makes them less prone to syntax errors than building a calculation from scratch with a custom formula. A formula is any calculation you type yourself, which can be more error-prone if you mishandle operators or references. Macros automate sequences of actions, and scripts are code that runs tasks—neither is intended as the standard, reusable calculation you call by name in a cell.