26 terms

Chapter 1 Key Terms-Excel 2016

STUDY
PLAY

Terms in this set (...)

Accounting Number Format
A number format that displays $ on the left side of a cell, formats a value with a comma for every three digits on the left side of the decimal point, and displays two digits to the right of the decimal point.
Border
A line that surrounds a cell or a range of cells to offset particular data from the rest of the data in a worksheet.
Cancel
An icon between the Name Box and Formula Bar. When you enter or edit data, click Cancel to cancel the data entry or edit, and revert back to the previous data in the cell, if any. Cancel changes from gray to red when you position the pointer over it.
Cell
The intersection of a column and row, such as the intersection of column B and row 5.
Cell address
The unique identifier of a cell, starting with the column letter and then the row number, such as C6.
Cell style
A set of formatting applied to a cell to produce a consistent appearance for similar cells within a worksheet.
Column heading
The alphabetical letter above a column in a worksheet. For example, B is the column heading for the second column.
Comma Style
A number format that formats a value with a comma for every three digits on the left side of the decimal point and displays two digits to the right of the decimal point.
Enter
An icon between the Name Box and Formula Bar. When you enter or edit data, click Enter to accept data typed in the active cell and keep the current cell active. Enter changes from gray to blue when you position the pointer over it.
Fill color
The background color that displays behind the data in a cell so that the data stands out.
Fill handle
A small green square at the bottom right corner of the active cell. You can position the pointer on the fill handle and drag it to repeat the contents of the cell to other cells or to copy a formula in the active cell to adjacent cells down the column or across the row.
Formula
A combination of cell references, operators, values, and/or functions used to perform a calculation.
Formula Bar
An element located below the Ribbon and to the right of the Insert Function command. It shows the contents of the active cell. You enter or edit cell contents in the Formula Bar for the active cell.
Insert Function
An icon between the Name Box and Formula Bar. Click Insert Function to open the Insert Function dialog box to search for and insert a particular function.
Name Box
An element located below the Ribbon, which displays the address of the active cell.
New sheet
An icon that, when clicked, inserts a new worksheet in the workbook.
Nonadjacent range
A collection of multiple ranges (such as D5:D10 and F5:F10) that are not positioned in a contiguous cluster in an Excel worksheet.
Normal view
The default view of a worksheet that shows worksheet data but not margins, headers, footers, or page breaks.
Number format
A setting that controls how a value appears in a cell.
Percent Style
A number format that displays a value as if it was multiplied by 100 and with the % symbol. The default number of decimal places is zero if you click Percent Style in the Number group or two decimal places if you use the Format Cells dialog box.
Range
A group of adjacent or contiguous cells in a worksheet. A range can be adjacent cells in a column (such as C5:C10), in a row (such as A6:H6), or a rectangular group of cells (such as G5:H10).
Row heading
A number to the left side of a row in a worksheet. For example, 3 is the row heading for the third row.
Sheet tab
A visual label that looks like a file folder tab. In Excel, a sheet tab shows the name of a worksheet contained in the workbook.
Spreadsheet
An electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.
Value
A number that represents a quantity or a measurable amount.
Zoom control
A control that enables you to increase or decrease the size of the worksheet data onscreen.