Excel Functions and Features

Front

Paste Special

Back

A function that allows you to paste special attributes of a cell, rather than just the contents of a cell.

Front

Office Clipboard

Back

The place where copied data can be stored for future pasting purposes. It can hold up to 24 copied items from any Microsoft application.

Front

Quick Access Toolbar

Back

The Quick Access Toolbar appears above the ribbon by default and holds the AutoSave, Save, Undo, and Redo commands. It can be customized to suit your needs.

Front

Quick Access Toolbar button

Back

The drop-down arrow on the Quick Access Toolbar.

Front

Freeze panes

Back

The function that freezes worksheet titles on screen, meaning if you move down or across to the right, the titles will remain on screen.

Front

Arrange all

Back

The function that allows you to display more than one workbook/worksheet on screen at the same time.

Front

Split

Back

The function that splits your screen into halves or quarters to help you move around huge spreadsheets.

Front

Array function

Back

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 {…}.

Front

Column index number

Back

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

Front

Expression

Back

A mathematical term; for example, >=200 (greater than or equal to 200) or Formula Options, you can control the maximum number of iterations and the amount of acceptable change.