Digital Information Technology (DIT) Practice Exam

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.