Setting range_lookup to FALSE in VLOOKUP instructs Excel to find an exact match only.

Line charts are designed to display data points connected by lines, making them ideal for showing trends over time.

The standard syntax for an IF function is IF(logical_test, value_if_true, value_if_false).

#DIV/0! occurs when a number is divided by zero or an empty cell.

The AVERAGE function returns the arithmetic mean of its arguments.

Pie charts show the size of items in a data series, proportional to the sum of the items.

VLOOKUP (Vertical Lookup) searches for a value in the first column of a table array and returns a value in the same row.

The SUM function ignores text entries within the range and only adds the numeric values.

The COUNT function counts cells containing numerical values, whereas COUNTA counts all non-empty cells.

A nested IF allows for multiple conditions by placing one IF function within the argument of another.

Scatter charts are used to show relationships or correlations between two different sets of numerical data.

The col_index_num tells Excel which column in the selected range contains the data you wish to return.

Pressing F11 creates a default chart on a new sheet based on the selected range.

Excel evaluates missing logical tests as FALSE.

The MAX function returns the maximum value in a given range.

The SUM function ignores cells containing text and only adds the numerical values (10+5=15).

Data Bars, found under Conditional Formatting, allow for in-cell visualization of relative values.

The orientation is the key difference: Column charts use vertical bars and Bar charts use horizontal bars.

The Slide Master is the top slide in a hierarchy that stores information about the theme and slide layouts of a presentation, including the background, color, fonts, effects, placeholder sizes, and positioning.