A calculation that displays a single value for a specific field is:

🧠 Explanation:

In databases and spreadsheet programs, a calculation that returns a single value for a specific field is called an aggregate function. These functions take multiple rows of data and combine them into one summarized result. Common examples include SUM, COUNT, AVERAGE, MIN, and MAX. The key term “aggregate” is used here because it means “to gather or combine into a whole,” which matches the function’s purpose. Grammatically, “aggregate” is an adjective describing the type of function, while “function” is a noun referring to a defined operation in software. Alternative terms that could fit in the same context are summary function, total function, or statistical function—but “aggregate function” is the standard technical term, especially in SQL and Excel contexts. This concept is essential for quickly analyzing large datasets and producing meaningful summaries.