Excel Chapter 2
Use this to practice learning the vocabulary terms for Microsoft Office Excel Chapter 2.
Terms in this set (31)
A way to assign a calculation to a cell and Excel will calculate it and show the result.
order of operations
The basic order that is involved when moving from left to right in a formula to solve an equation. (PEMDAS)
Allows you to select cells for use in a formula by using the mouse and is faster than using the keyboard method.
When Excel adjusts the cell references when a formula or cell is copied that corresponds to a new location and performs calculations that change based on the appropriate values.
When a formula is not copied because it was involved in a computation and has a numerical value of zero.
Prewritten formulas to help compute a value, perform an operation, and returns a result to a cell. Excel has more than 400 that it can perform.
The values that you use with a function. All begin with an = sign and include the arguments in ( ) after the function range. Example =average(d3:d10). The function name is average, and the argument range is d3:d10.
Sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range
Determines and displays the highest value in a range of cells.
Determines and displays the lowest value in a range of cells.
Used to check which cells are being referenced in the formula assigned to the active cell and can make immediate changes to the cells reference.
fixed dollar sign
Displayed to the far left in the cell, often with spaces between it and the first digit.
floating dollar sign
Displays immediately to the left of the first digit with no spaces. You must use the cells command from the Format or shortcut menus to display this.
comma style format
Inserts a comma every 3 positions to the left of the decimal point and displays numbers to the nearest hundredth.
Lets you apply formatting that appears only when the values in a cell meet conditions that you specify. This can be applied to a cell, range of cells. worksheet, or workbook.
Made up of 2 values and a relational operator and is true or false for each cell in the range. Example: if True, then apply format, if False, then suppress formatting for that cell
A dot on the screen that contains color and means picture element. The dot is based on your screen's resolution.
best fit or autofit
When the width of the column will be increased or decreased so the widest entry will fit in the column by double-clicking the right boundary of the column heading.
A technique you can use to hide data in columns or rows that might not be relevant to a report or data that you don't want others to see. These will not print.
Used to check the worksheet from the standard dictionary for spelling errors.
On a worksheet that shows the results of the formulas that you have entered, rather than the actual formulas.
The process of finding and correcting errors in the worksheet wherever formulas and functions have been entered.
Precedes a formula and is an important part of the formula's answer. It also alerts Excel that you are entering a formula or function and not text.
Used in following a cell reference (i.e. d4*) and is the arithmetic operator that directs Excel to perform the multiplication operation.
A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire worksheet. The default is called Office.
The default view that you have worked on when you turn the Excel application program on.
Displays the actual formulas that you have entered on a worksheet, rather than resulting values. Press CTRL & Accent mark (') keys at the same time.
accounting number format
A way Excel displays numbers with a dollar sign to the left of the number, a comma every 3 positions to the left of the decimal point, and displays numbers to the nearest cent.
A formula in a cell that contains a reference back to itself. Usually the result of an incorrect formula, and can be direct, i.e. =A1 in cell A1 or indirect is when a cell refers to another cell(s) that include a formula and refers back to the original cell.
A common content area that prints on every page of a worksheet.
page layout view
Shows the worksheet divided into pages. A gray background separates each page, and the white areas surrounding each page indicate the print margins. Headers and footers are also viewed, as well as a ruler at the top of the page.