excel ch 1 end of chapter quiz
an excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is
Auto fit
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 excel feature that generates and extends values into adjacent cells based on the values of the selected cells is
auto fill
the area along the bottom of a chart that identifies the categories of data is the
category axis
the intersection of a column and a row
cell
another name of r a cell reference
cell address
anything typed into a cell
cell content
the graphic representation of data in a worksheet
chart
a vertical group of cells in a worksheet
column
numbers, text, dates, or times of day that you type into a cell
constant value
text or numbers in a cell
data
the small black square in the lower right corner of a selected cell
fill handle
an equation that performs mathematical calculations on values in a worksheet
formula
an element in the excel window that displays the value or formula contained in the active cell is
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
constant values consisting of only numbers
number values
the symbols with which you can specify the type of calculation 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 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
a horizontal group of cells in a worksheet
row
a box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the
select all box
the labels along the lower border of the excel window that identify each worksheet
sheet tabs
tiny charts embedded in a cell that give visual trend summary alongside your data are
sparklines
another name for a worksheet
spreadsheet
the data that displays in the formula bar is referred to as the
underlying value
another name for a constant value
value
an excel file that contains one or more worksheets
workbook
on startup, excel displays a new blank
workbook