Chapter 1 Key Terms-Excel 2016
Terms in this set (26)
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.
A line that surrounds a cell or a range of cells to offset particular data from the rest of the data in a worksheet.
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.
The intersection of a column and row, such as the intersection of column B and row 5.
The unique identifier of a cell, starting with the column letter and then the row number, such as C6.
A set of formatting applied to a cell to produce a consistent appearance for similar cells within a worksheet.
The alphabetical letter above a column in a worksheet. For example, B is the column heading for the second column.
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.
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.
The background color that displays behind the data in a cell so that the data stands out.
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.
A combination of cell references, operators, values, and/or functions used to perform a calculation.
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.
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.
An element located below the Ribbon, which displays the address of the active cell.
An icon that, when clicked, inserts a new worksheet in the workbook.
A collection of multiple ranges (such as D5:D10 and F5:F10) that are not positioned in a contiguous cluster in an Excel worksheet.
The default view of a worksheet that shows worksheet data but not margins, headers, footers, or page breaks.
A setting that controls how a value appears in a cell.
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.
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).
A number to the left side of a row in a worksheet. For example, 3 is the row heading for the third row.
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.
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.
A number that represents a quantity or a measurable amount.
A control that enables you to increase or decrease the size of the worksheet data onscreen.
YOU MIGHT ALSO LIKE...
Combo with Excel Chapter 1 Key Terms Part 6 and 5 others
Excel 2010 Vocabulary
CSCI 190 excel Chapter 1
OTHER SETS BY THIS CREATOR
Coding Vocabulary (Code.org)
Basic Minecraft Commands
Name That App!