Categories
Excel glossary
A comprehensive glossary of Excel-related terms is an invaluable resource for users at all levels, from beginners to advanced professionals. Excel, with its extensive array of functions, features, and terminology, can sometimes be overwhelming. This glossary aims to demystify the language of Excel by providing clear, concise definitions of common terms and concepts.
Formula range
A formula range is usually a reference to a range of cells, within which a formula persists consistently throughout the full range.
Formula breakdown
A formula breakdown refers to the disentanglement of the items in a formula. In Excel, most of these components will be clear at a glance, like constants, values, functions and operator signs.
Formula
A formula is a type of equation. An equation says that two things are equal, that is why in Excel a formula always starts with ‘=’.
Cell reference
A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.
Pivot table
A pivot table in Excel is an extraction or recap of your original table with source data. A pivot table can provide quick answers to questions about your table that can otherwise only be answered by complicated formulas.
Cell range
A cell range in an Excel file is a selection of cells. This range is usually symmetrical (square), but can exist of separate cells just the same. You can refer to a cell range in a formula as well.