Term
|
Definition
Collection of text and numbers laid out in a rectangular grid.
Often used in business for budgeting, inventory management, and decision making. |
|
|
Term
|
Definition
| When using Excel, you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. |
|
|
Term
|
Definition
| Contains a grid of rows and columns into which the user enters data values and formulas. |
|
|
Term
|
Definition
| Contains and Excel chart that provides a visual representation of worksheet data. |
|
|
Term
|
Definition
| Indicates a cells colum and row location. |
|
|
Term
|
Definition
What problems do I want to solve?
What data do I need?
What calculations do I need to enter?
What form should my solution take? |
|
|
Term
| What problems do I want to solve? |
|
Definition
| The answer defines the goal or purpose of the workbook. |
|
|
Term
|
Definition
| The answer defines the formulas you need to apply to the data you've collected and entered. |
|
|
Term
| What calculations do I need to enter? |
|
Definition
| The answer defines the formulas you need to apply to the data you've collected and entered. |
|
|
Term
| What form should my solution take? |
|
Definition
| The answer defines the appearance of the workbook content and how it should be presented to others. |
|
|
Term
|
Definition
| Any combination of letters, numbers, and symbols that form words and sentences. Often referred to as a text string. |
|
|
Term
|
Definition
| A cell containing a string of text characters. |
|
|
Term
|
Definition
| Any numerical value that can be used in a mathematical calculation. |
|
|
Term
|
Definition
| Commonly recognized formats for dates. |
|
|
Term
|
Definition
| Commonly recognized formats for time values. |
|
|
Term
|
Definition
| When text that is entered into a cell does not fit within the cell, only the text that fits is displayed. The rest of the text entry is hidden from view. |
|
|
Term
|
Definition
| As you type text into the active cell, Excel tries to anticipate the remaining characters by displaying text that begins with the same letters as a previous entry in the same column. |
|
|
Term
|
Definition
| A single point on a computer monitor or printout. A column width of 8.43 characters equals 64 pixels. |
|
|
Term
|
Definition
| Removes the data, leaving blank cells where the data had been. |
|
|
Term
|
Definition
| Removes both the data and the cells. |
|
|
Term
|
Definition
| Indicates the location and size of a cell range. |
|
|
Term
|
Definition
| Used to move a cell or range to a new location. |
|
|
Term
|
Definition
| Expresses a formula. Combines different values, resulting in a single value that is then displayed within the cell. |
|
|
Term
|
Definition
| Most commonly used operator. Perform addition, subtraction, multiplication, division, and exponentiation. |
|
|
Term
|
Definition
| A set of predefined rules used to determine the sequence in which operators are applied in a calculation. (P.E.M.D.A.S) |
|
|
Term
|
Definition
| A named operation that returns a value. Used to simiplify formulas. |
|
|
