dictionary

Dictionary of terms and definitions in Excel.

Excel Glossary

Spreadsheet  is a software that allows the entry, calculation, and storage of data in columns and rows that offers the user a visual display.  Microsoft Excel is the most popular and widely used spreadsheet program, but there are also some alternatives such as OpenOffice or Google Sheets.

Workbook is a document created in an Excel spreadsheet.

Worksheet is a page or section of a workbook, usually in a spreadsheet application.

Template is a formatted workbook or worksheet designed to help users fulfil a specific need in Excel.

Cell reference is a set of coordinates that identifies a specific cell. It’s a combination of letters and numbers. A2, for example, would point to the cell located where column A and row 2 intersect.

Name

Formula

Function

Argument

Operator

Pivot Table

Slicer

Array formula – Excel formulas, to perform calculations that generate single or multiple results depending on selection during constructed. Created with one formula. Array formulas are confirmed with CTRL + SHIFT + ENTER therefore often called CSE. In the preview, these formulas are enclosed in braces {}.

Dynamic array formula – Excel formulas that can return arrays of variable size based on a single formula entered in one cell. Unlike Array Formula, is selected in one cell and confirm with ENTER only.

Spill – refers to a behaviour where dynamic array formulas that return multiple results “spill” these results into multiple cells automatically.

Spill array – refers to the range of values returned by a dynamic array formula that spills results onto a worksheet. Once you enter a spilled array formula, when you select any cell within the spill area, Excel will place a highlighted in blue border around the range. The border will disappear when you select a cell outside of the area.