Excel - Chapter 2 - Working with Formulas and Functions

These flashcards cover key terms and definitions from Chapter 2 of Excel, focusing on formulas and functions.

Formula

A calculation that uses arithmetic operators, worksheet cells, and constant values.

Arithmetic Operators

Symbols used in formulas to denote operations such as addition (+), subtraction (-), multiplication (*), and division (/).

Formula AutoComplete

A feature that suggests ways to complete a formula as you type.

Order of Operations

The mathematical rules governing the sequence of calculations in a formula, often remembered with the acronym PEMDAS (Parentheses, Exponentiation, Multiplication, Division, Addition, Subtraction).

Relative Cell Reference

A cell address that updates when the formula is copied to a different location.

Absolute Cell Reference

A cell address that does not change when the formula is copied, denoted with dollar signs (e.g., $A$5).

Mixed Cell Reference

A cell address containing both relative and absolute components, such as $B5 or B$5.

3D Cell Reference

A reference to a cell in another worksheet within the same workbook, written as 'WorksheetName!CellAddress' (e.g., Inventory!B2).

Named Range

A defined name for a single cell or a group of cells, often used in formulas instead of cell addresses.

Formula Auditing Tools

Commands in Excel that help review and identify errors in formulas, such as Trace Precedents and Trace Dependents.

Circular Reference

An error in a formula that occurs when the formula refers to its own cell address.

Statistical Functions

Functions that perform statistical calculations, such as MEDIAN, MODE, and COUNT.

Date & Time Functions

Functions in Excel that deal with date and time data, like TODAY() and NOW().

PMT Function

A financial function that calculates the constant payment amount for a loan.

IF Function

A logical function that evaluates a condition and returns different results based on whether the condition is true or false.

XLOOKUP Function

A lookup function that searches for a value in one range and returns a matching value from another range.

TEXTJOIN Function

A text function that joins multiple strings of text with a specified delimiter.

ROUND Function

A math function that rounds a number to a specified number of decimal places.

SUMIF Function

A math function that sums cells based on a specified condition.

SUMPRODUCT Function

A math function that multiplies corresponding components in given arrays and returns the sum of those products.