excel 1

Chart

A graphical representation of data in a worksheet

Workbook

An Excel file with one or more worksheets.

cell address

Another name for a cell reference.

cell content

Anything typed into a cell.

number values

Constant values consisting of only numbers.

constant value

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

workbook.

On startup, Excel displays a new blank:

category axis

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

fill handle

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

select all box

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

active cell

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

quick analysis tool

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:

range finder

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

row

a horizontal group of cells in a worksheet

column

a vertical group of cells in a worksheet

formula bar

an element in the excel window that displays the value or formula contained in the active cell is the:

name box

an element of the excel window that displays the name of the selected cell, table, chart, or object

formula

an equation that performs mathematical calculations on values in a worksheet

autofit

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

spreadsheet

another name for a worksheet

value

another name for constant value

cell

intersection of a column and a row

sheet tab

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

underlying value

the data that displays in the formula bar is referred to as the:

general format

the default format that excel applies to numbers is the:

auto fill

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

operators

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

absolute

they type of cell reference that refers to cells by their fixed position in a worksheet is (fn, f4):

sparkline

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