Excel Quiz

column

A vertical stack of cells in a worksheet.

cell address

Another name for a cell reference.

spreadsheet

Another name for a worksheet.

cell content

Anything typed into a cell.

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:

Auto Fill

number values

Constant values consisting of only numbers.

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:

Merge & Center

constant value

Numbers, text, dates, or times of day that you type into a cell.

cell

The intersection of a column and a row

fill handle

The small black square in the lower right corner of a selected cell

row

a horizontal group of cells in a worksheet

The type of cell reference that refers to cells by their fixed position in a worksheet is:

absolute

A cell surrounded by a black border and ready to receive data is the:

active cell

workbook

an Excel file that contains one or more worksheets

formula

an equation that performs mathematical calculations on values in a worksheet

value

another name for a constant value

An Excel feature that adjusts the width of a column to fit the cells content of the widest cell in the column is:

autofit

The area along the bottom of a chart that identifies the categories of data is the:

category axis

An element in the Excel window that displays the value or formula contained in the active cell is the:

formula bar

The default format that Excel applies to numbers is the:

general format

The symbols with which you can specify the type of calculations you want to perform in an Excel formula are:

operators

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel for such as charts, color-coding, and formulas is called:

quick analysis tool

A feature that outlines cells in color to indicate which cells are use in a formula is called:

range finder

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

select all box

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

sparklines

data

text or numbers in a cell

chart

the graphic representation of data in a worksheet

sheet tabs

the labels along the lower border of the Excel window that identify each worksheet

The data that displays in the Formula Bar is referred to as the:

underlying value