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 aggregate operations in Excel

Aggregate operation

Arrays and ranges in Excel

Array

Example array formula in Excel

Example of array of arrays limitation in Excel formulas

Array of arrays

Array operation examples

Array operation

First 128 ASCII characters in Excel

ASCII

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

Excel Data Type examples

Data Type

Data validation in Excel

Data validation

Example of double unary in Excel formula

Example of dynamic array function in Excel

Example of Dynamic Array formula in Excel

Example of a simple dynamic named range in Excel

Dynamic named range

Empty string in Excel formula

Excel Subscription Information at File > Account

Excel 365

Excel dates are just serial numbers (example)

Excel date

Excel datetimes include both date and time values

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 full column references in a SUMIF function

Full column reference

Example of full row references in a SUM formula

Full row reference

Example of Excel formula based on a single function

Function

Excel function argument example

Function argument

Function screen tip window

Function screen tip

Excel implicit intersection example

Implicit Intersection

Legacy Excel does not include dynamic array formulas and functions

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

Lifting

Excel function list separator varies by region

Example of locked table reference in formula

Locked table reference

Logical operators in Excel formulas

Logical operators

Examples of logical tests with Excel formulas

$Math and Formula Operators in Excel$

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

Name Manager in Excel

Example of Named Range in Excel

Example of nesting in an Excel formula

Nesting

Example of nominal data in Excel bar chart

Examples of Excel number formats

Order of operations in Excel

Order of operations

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

Pairwise lifting

Percentage Number Format in Excel

Percentage number format

Example of Excel Pivot Table together with raw data

The Power Query interface

Excel use of Radians

Radians

Examples of ranges in Excel

Range

Example of Relative Address in Excel

Relative reference

Excel Select All button at upper left of all worksheets

Select All button

Excel Slicer

Slicer

Example of "spilling" in a dynamic array formula

Spill

Example spill range

Excel status bar

Status Bar

Excel structured reference example

Structured reference

Excel's Text to Columns feature

Text to columns

Text values in Excel

Text value

Excel used range example

Used range

Example of volatile function in Excel

Volatile function

Example of wildcard in COUNTIF function

Wildcard

Example of _xlfn with UNIQUE function

XLFN