Unit I Words
Electronic grid in which you can perform numeric calculations.
Excel file that contains one or more worksheets.
References to both worksheets and workbooks.
The intersection of a row and a column in an Excel worksheet of a Word table.
In an Excel worksheet, the current location of the cell pointer.
Blue border surrounding the active cell.
Specific location of a cell in a worksheet where a column and a row intersect.
Shows address of selected cell.
Shows content of selected cell, and is located right above the column headings.
Group of cells that share boundaries.
Text that describes data in a worksheet.
Numeric data that can be used in calculations.
In Excel, the boxes containing letters that appear in every column.
In Excel, the boxes containing numbers that appear to the left of each row.
A feature that automatically adjusts the width of a column or the height of a row to accommodate its widest or tallest entry.
An equation that calculates a new value from existing values. Formulas can contain numbers, mathematical operators, cell references, and built-in equations called functions.
The address of a cell in an Excel worksheet that defines its location in the worksheet by column letter and row number (for example, A1), and that can be used in formulas and functions.
Order of Operations (Order of Precedence for Arithmetic Operations)
The order in which Excel calculates a formula; the order of precedence is exponents, multiplication and division, addition and subtraction. Calculations in parentheses are evaluated first.
Relative Cell Referencing
In Excel, a cell reference that changes when copied to refer to cells relative to the new location. For example, the formula "=B5*C5" in cell D5 changes to "=B6*C6" when you copy the formula to cell D6.
Prewritten formulas you can use instead of typing a formula from scratch. Each function includes the function name, a set of parentheses, and function arguments separated by commas and enclosed in parentheses.
In Excel, the function used to calculate the total of the arguments.
A value, cell reference, or text used in an Excel function. Commas or a colon separate arguments and parentheses enclose them; for example, AVERAGE(A1,10,5) or SUM(A1:A5).
A print setting that positions the document on the page so the page is taller than it is wide.
A layout orientation for a document that specifies to print the page so it is wider than it is tall.