Excel Glossary

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

Quick Links

Absolute reference

Absolute reference

Aggregate operation

Aggregate operation

Array

Array

Array constant

Array constant

Array formula

Array formula

Array of arrays

Array of arrays

Array operation

Array operation

ASCII

ASCII

BigNum

BigNum

Boolean logic

Boolean logic

Broadcasting

Broadcasting

Compatibility function

Compatibility function

Concatenation

Concatenation

CSE

CSE

Data Type

Data Type

Data validation

Data validation

Dot operator

Dot operator

Double unary

Double unary

Dynamic array

Dynamic array

Dynamic Excel

Dynamic Excel

Dynamic named range

Dynamic named range

Empty string

Empty string

eta lambda

eta lambda

Excel 365

Excel 365

Excel date

Excel date

Excel datetime

Excel datetime

Excel Table

Excel Table

Excel time

Excel time

Expanding reference

Expanding reference

Fill handle

Fill handle

Formula

Formula

Formula Bar

Formula Bar

Full column reference

Full column reference

Full row reference

Full row reference

Function

Function

Function argument

Function argument

Function screen tip

Function screen tip

Helper column

Helper column

Hyperbolic Angle

Hyperbolic Angle

Implicit Intersection

Implicit Intersection

Legacy Excel

Legacy Excel

Lifting

Lifting

List separator

List separator

Locked table reference

Locked table reference

Logical operators

Logical operators

Logical test

Logical test

$Math Operators$

Math Operators

Mixed reference

Mixed reference

Multi-cell array formula

Multi-cell array formula

Name Box

Name Box

Name Manager

Name Manager

Named range

Named range

Nesting

Nesting

Nominal data

Nominal data

Number format

Number format

Order of operations

Order of operations

Ordinal data

Ordinal data

Pairwise lifting

Pairwise lifting

Percentage number format

Percentage number format

Pivot Table

Pivot Table

Power Query

Power Query

Radians

Radians

Range

Range

Relative reference

Relative reference

Select All button

Select All button

Slicer

Slicer

Spill

Spill

Spill range

Spill range

Status Bar

Status Bar

Structured reference

Structured reference

Text to columns

Text to columns

Text value

Text value

Used range

Used range

Volatile function

Volatile function

Wildcard

Wildcard

XLFN

XLFN

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

Many thanks for your many excel resources. I have found answers through your posts to many questions and challenges I had using excel. I am indeed absolutely very very very grateful to both of you.

David

More Testimonials