Excel 2019 Terms MOS Certification

A term used to describe how formulas remain constant and do not change when they are copied in Excel.

The cell inside of Excel which is currently selected and ready to receive data. The active cell in Excel is displayed with a black border around it.

An Excel feature that automatically enters contextual numbers and text into a specified cell range.

A group of at least two or more cells on an Excel worksheet.

A series of cells arranged vertically within an Excel worksheet.

A type of formatting Excel executes on cells automatically if certain conditions are met

A character or group of characters used in computer applications to set apart individual items in a program or data set. Some of the commonly used characters are commas

Data found inside an Excel table that is considered repetitive. It is left to the user to decide what is considered repetitive data

A Microsoft Office application which acts as a spreadsheet application that provides intricate mathematical formatting and data analysis.

The act of sending or transferring a saved file or document to another application.