Excel 2019 Terms MOS Certification

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

• Absolute Reference

• Relative Reference

• Active Cell

• Referencing

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.

• Absolute Reference Cell

• Cell

• Active Cell

• Equation

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

• Active Cell

• Autofill

• Cell

• Absolute Reference

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

• Cell Range

• Worksheet

• Workbook

• Relative Referencing

A series of cells arranged vertically within an Excel worksheet.

• Rows

• Page Break

• Columns

• Cells

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

• Conditional Formatting

• Formatting Cells

• Relative Referencing

• Formulas

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

• Delimiter

• Commas

• Cell

• Space

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

• Cells

• Active Cell

• Delimiter

• Duplicate Records

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

• Access

• Excel

• Spreadsheet

• Word

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

• Import

• Excel

• Export

• File