Term
|
Definition
| an Excel file with one or more worksheets |
|
|
Term
|
Definition
the work area for entering and calculating data made up of columns and rows separated by gridlines
also called a spreadsheet |
|
|
Term
|
Definition
| the intersection of a column and a row on a worksheet that you enter data into to create a worksheet |
|
|
Term
|
Definition
| contains cell pointer; there is a dark outline around it |
|
|
Term
|
Definition
- as you enter data into a cell, it simultaneously appears here
- located above the worksheet
|
|
|
Term
|
Definition
| the location of a cell in a worksheet as identified by the column letter and row number; also known as the cell's address |
|
|
Term
|
Definition
| a way to view locations on the worksheet without chaniging to active cell |
|
|
Term
|
Definition
| tabs that appear at the bottom of the workbook window, which display the name of each worksheet |
|
|
Term
|
Definition
| buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view |
|
|
Term
|
Definition
| a new, empty workbook that contains 3 worksheets |
|
|
Term
|
Definition
| a workbook with certain labels, formulas, & formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets |
|
|
Term
|
Definition
| text in the first row or column of a worksheet that identifies the type of data contained there |
|
|
Term
|
Definition
| the standard settings Excel uses in its software, such as column width or number of worksheets in a workbook |
|
|
Term
|
Definition
| the command used to reverse one or a series of editing actions |
|
|
Term
|
Definition
| the command used to redo an action you have undone |
|
|
Term
|
Definition
| a feature used to complete an entry based on previous entries made in the column containing the active cell |
|
|
Term
|
Definition
| a shortcut used ot insert repeated information |
|
|
Term
|
Definition
| a feature used to automate the correction of common typing errors |
|
|
Term
|
Definition
| a tool used to assist you in finding and correcting typographical or spelling errors |
|
|
Term
|
Definition
| a number entered in the worksheet |
|
|
Term
|
Definition
| a number entered in the worksheet as a label, not as a value-such as the year 2010 used as a column label |
|
|
Term
|
Definition
| an apostrophe used to indicate that a number is a label and not a value |
|
|
Term
|
Definition
| a list of sequential numbers, dates, times, or text |
|
|
Term
|
Definition
| the default number of characters that display in a column based on the default font |
|
|
Term
|
Definition
| an instruction Excel uses to calculate a number |
|
|
Term
|
Definition
| symbols used in math operations: + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentiation |
|
|
Term
| order of mathematical operation |
|
Definition
| the order in which Excel performs the calculation specified in a formula |
|
|
