Terms in this set (28)
Allows data easily to be summarized and charted
Document which includes a needs statement, a source of data, and a summary of calculations
Place to enter data in an Excel worksheet
A blinking vertical line that shows where text will appear when you begin typing
A feature used to automate the correction of common typing errors.
In Excel, a number can contain the characters: 0123456789, +, -, (), /,$, %, E, e
A series of two or more adjacent cells in a column or row.
the range of cells receiving the copy (paste area)
The small green square in the lower right corner of a selected cell
auto fill options button
Allows you to choose whether you want to copy the values from the source area to the destination area with formatting, do so without formatting, or copy only the format.
combining of selected cells
A chart created on the same sheet as the data used in the chart.
identifies the colors assigned to each bar in the chart
status bar that displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet
A prewritten formula that makes it easy to perform common calculations
ALT + ENTER
Starts a new line in the same cell.
order of operations
The rules Excel follows to calculate any formula that contains two or more operators.
allows you to select cells for use in a formula by using the mouse
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
displays the highest value in a range
A function that determines the minimum value in a range of cells.
checks which cells are referenced in the formula assigned to the active cell
predefined set of colors, fonts, chart styles, cells styles, and fill effects
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.
A new feature in Excel that is similar to AutoFill.
When Excel recognizes a pattern based on other information in
your workbook, it uses the pattern to enter data into several cells
indirect circular reference
occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell
The width of the column will increase or decrease so the widest entry will fit