MS excel chapter 1
context sensitive
A command associated with the currently selected or active object; often activated by right-clicking a screen item.
merge and center
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the new cell
AutoComplete
A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.
function
A predefined formula- a formula that Excel has already built for you-that preforms calculations by using specific values in a particular order
auto fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Expand Formula Bar button
An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content.
Expand horizontal scroll bar button
An Excel window element with which you can increase the width of the horizontal scroll bar.
formula bar
An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas.
formula
An equation that preforms mathematical calculations on values or formulas
cell address
Another name for a cell reference.
labels
Another name for a text value, and which usually provides information about number values.
AutoSum
Another name for the SUM function.
cell content
Anything typed into a cell.
insert worksheet button
Located on the row of sheet tabs, a sheet tab that, when clicked, inserts an additional worksheet into the workbook.
constant value
Numbers, text, dates, or times of day that you type into a cell.
displayed value
The data that displays in a cell.
cell style
a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading
column
a vertical group of cells in a worksheet
format
changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read
data
text or numbers in a cell
Accounting Number Format
the Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.
lettered column headings
the area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters
left alignment
the cell format in which characters align at the left edge of the cell; this the the default for text entries and is an example of formatting information stored in a cell
active cell
the cell, surrounded by a black border, ready to receive data or be affected by the next Excel command
general format
the default format the Excel applies to numbers; this format has no specific characteristics-whatever you type in the cell will display, with the exception that trailing zeros to the right of the decimal point will not display
comma style
the excel number format that inserts thousand comma separators where appropriate and applies two decimal places; comma style also leaves space at the top right to accommodate a parenthesis when negative numbers are present
cell reference
the identification of a specific cell and its intersecting column letter and row number
cell
the intersection of a column and a row
column heading
the letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column
fill handle
the small black square in the lower right corner of a selected cell
