Exceljet

Quick, clean, and to the point

Excel Glossary

Below is a list of useful Excel terminology. Contact us with suggestions.

Example of Absolute Reference in Excel

Absolute reference

Examples of arrays in Excel

Array

Example array formula in Excel

Example of bignum used in an Excel formula

BigNum

Example of formula using boolean logic

Excel formula broadcasting example

Example of Excel compatibility function

Compatibility function

Examples of concatenation formulas in Excel

Example of CSE array formula in Excel

CSE

Example of double unary in Excel formula

Example of dynamic array function in Excel

Dynamic array function

Example of a simple dynamic named range in Excel

Dynamic named range

Excel dates are just serial numbers (example)

Excel date

Excel Table example

$Excel times are fractional parts of a day (example)$

Excel time

Example of expanding reference in Excel

Expanding reference

Excel fill handle

Example of Excel formula

Formula

Example of Excel Formula Bar

Example of Excel formula based on a single function

Function

Excel function argument example

Function argument

Excel implicit intersection example

Implicit Intersection

Example of "lifting", an array calculation behavior in Excel

Lifting

Excel function list separator varies by region

Logical operators

Example of mixed reference in Excel

Mixed reference

Example of multi-cell array formula

Multi-cell array formula

The Name Box in an Excel worksheet

Name Box

Example of Named Range in Excel

Example of nominal data in Excel bar chart

Example of "pairwise lifting", an array calculation behavior in Excel

Pairwise lifting

Example of Excel Pivot Table together with raw data

Example of Relative Address in Excel

Relative reference

Excel Select All button at upper left of all worksheets

Select All button

Example of "spilling" in a dynamic array formula

Spill

Excel status bar

Status Bar

Excel structured reference example

Structured reference

Excel's Text to Columns feature

Text to columns

Example of volatile function in Excel

Volatile function

Example of wildcard in COUNTIF function

Wildcard