Chapter 20 - Spreadsheets

Sum

Calculates the sum of a range of cells.

Multiply

Multiplies two cells together.

Division

Divides one cell by another.

Exponent

Raises a cell to a specified power.

Average

Calculates the average of a range of cells.

Maximum

Finds the maximum value in a range of cells.

Minimum

Finds the minimum value in a range of cells.

Int

Extracts the whole number part of a decimal number.

ROUND

Rounds a number to a specified number of decimal places.

Count

Counts the number of cells with numerical values.

Countif

Counts the number of cells that meet a specific criteria.

Counta

Counts the number of non-blank cells in a range.

Countblank

Counts the number of blank cells in a range.

Sumif

Calculates the sum of cells that meet a specific criteria.

IF

Performs a logical test and returns different values based on the result.

NestedIF

Uses multiple IF functions within each other to perform complex logical tests.

AND

Checks if multiple conditions are true.

OR

Checks if at least one condition is true.

Absolute Reference ($)

Locks the cell reference in a formula to prevent it from changing when copied.

Lookup

Searches for a value in a table and returns a corresponding value.

HLookup

Performs a horizontal lookup in a table.

VLookup

Performs a vertical lookup in a table.

Sorting

Arranging data in either ascending or descending order.

Contains

Filters data based on whether it contains a specific character or pattern.