Computer Apps!
About this set
Created by:
adidasx311 on October 19, 2011
Subjects:
Log in to favorite or report as inappropriate.
Order by
20 terms
Terms | Definitions |
|---|---|
 What-if Anaylsis | Type of analysis you can perform in Excel where you can change the formula input numbers and instantly see the effect on the formula result. |
| Cell References | The address of a cell in an Excel worksheet that defines its location in the worksheet by column, letter, and row numbers. And that can be used in formulas and functions. |
| Labels | Descriptive text used to identify worksheet data in Excel. |
| Values | In excel, data entered into a cell, such as a number or a date. |
| Name Box | In Excel, displays the name or address of the currently selected cell in the worksheet. |
| Cell Address | In Excel, a column letter followed by a row number that specifies the location of a cell. |
| Chart Style | A predefined set of chart colors and fills that can be applied to any chart. |
| Row | a long continuous strip (usually running horizontally) |
| Cell | The intersection of a row and a column in an Excel worksheet or Word table. |
| Formula Bar | A floating element below the menu bar in which users enter, edit, or display a formula or data in the selected cell. |
| Spreadsheet | Another word for a workbook or worksheet. |
| Workbook | A collection of related worksheets saved in a single Excel file. |
| Worksheet | An Excel spreadsheet comprised of rows and columns of information that is used for performing numeric calculations, displaying business data, presenting information on the Web, and other purposes. |
| Functions | A prewritten formula you can use instead of typing a formula for scratch. Each function includes the function name, a set of parentheses, and function arguments separated by commas and enclosed in parentheses. |
| Sort | A command that organizes columns in an Excel spreadsheet or a Word table numerically or alphabetically, and in ascending or descending order. |
| Filter | A command that displays only the data that you want to see in an Excel worksheet based on criteria you set. |
| Arguments | A value, cell reference, or text used in an Excel function. Commas or a color seperate arguments and parentheses enclose them. For example, AVERAGE(A1,10,5) or SUM(A1:A5) |
| Formula Builder | A tab on the Excel Toolbox that helps users create mathematical calculations. |
| AutoFilter arrows | In Excel, arrows to the right of each column heading that appear when AutoFilter is selected for a list; click the arrows to open a menu containing options for filtering and sorting the list data. |
| Criteria | in Excel, conditions or qualifications that determine whether data is chosen for a filter. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.