Excel Chapter 1A Part 1
Context sensitive
A command associated with activities in which you are engaged; often activated by right-clicking a screen item.
Cell style
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
AutoComplete (Excel)
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 performs calculations by using specific values in a particular order.
Column
A vertical group of cells in a worksheet.
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.
Horizontal window split box (Excel)
An Excel window element with which you can split the worksheet into two horizontal views of the same worksheet.
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 performs mathematical calculations on values in a worksheet.
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.
Format (Excel)
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.
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.
Data (Excel)
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.
Comma Style
The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; It also leaves space at the right to accommodate a parenthesis when negative numbers are present.
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 is 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.
Displayed value
The data that displays in a cell.
General format
The default format that 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 a decimal point will not display.
Cell reference
The identification of a specific cell by 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.