Excel 1 MOS Quiz

A cell reference that refers to cells by their fixed position in a worksheet.

Absolute cell reference

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Auto Fill

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Cell style

The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Chart layout

An equation that performs mathematical calculations on values in a worksheet.

Formula

The command that joins selected cells into one larger cell and centers the contents in the merged cell.

Merge & Center

An element of the Excel window that displays the name of the selected cell, table, chart, or object.

Name Box

A specific way in which Excel displays number in a cell.

Number format

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

Sparkline

A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa.

Switch Row/Column