Function
What is Function?
Definition
A function is a predefined calculation in a spreadsheet or application that performs a specific operation using supplied values. Each function is designed for a particular purpose, such as adding numbers, calculating averages, counting items, or evaluating conditions. This helps users perform common calculations accurately and efficiently without having to create every calculation manually.
Frayer Model Overview
Characteristics
Performs a predefined calculation or operation
Uses inputs called arguments to produce a result
Returns a value based on those inputs
Written using a specific name and structure
Updates automatically when input values change
Examples
Using the SUM function to add numbers in Excel
Using AVERAGE to calculate the mean of a set of values
Using COUNT to count filled cells
Using IF to return different results based on a condition
Using a function inside a formula cell
Non-Examples
A number typed directly into a cell
A formula built only with basic math symbols
Text entered into a spreadsheet
Formatting such as currency or bold
A chart created from calculated results