Excel chapter 1

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

Auto Fill

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

AutoFit

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

Quick Analysis Tool

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

Range Finder

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

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

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

name box

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

operators

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

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

underlying value

On startup, Excel displays a new blank:

workbook