Array function A formula that calculates more than one variable at the same time. You must use Ctrl+Shift+Enter to complete an array function; the completed formula will be contained with braces ….

Column index number The position of the column within the table array. The row index number refers to the position of the row within the table array.

A mathematical term; for example, =200 (greater than or equal to 200) or 100 (less than 100).

Function Arguments The dialog box that helps you build a formula.

The repeated recalculation of a worksheet until a specific value is reached.

Refers to the value you want to find.

The table, range, or list of cells that contains the value you want to find.

The formatted appearance of cells associated with specified criteria.

Excel functions and parameters used to perform calculations.

An outline of data that users can expand or collapse to quickly display summary rows or columns.

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map