Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
80 Cards in this Set
- Front
- Back
3-D reference
|
The same cell or range in multiple worksheets in the same workbook.
|
|
absolute reference
|
Cell reference that points to a specific cell and does not change when copied;appears with a $.
|
|
add-in
|
a customized program that adds commands and features to Microsoft Office Programs
|
|
argument
|
Specifies the numbers, text or a cell reference used by the function to calculate a value.
|
|
AutoFill
|
an Excel tool that enables you to copy the contents of the selected cell by dragging the fill handle over another adjacent cell or range rather than using the copy and paste commands.
|
|
AutoSum
|
A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic.
|
|
Binding Constraint
|
A constraint in which Solver was forced to include the constraint as part of the final solution.
|
|
Break-even point
|
The point where revenue equals expenses.
|
|
Cell Range
|
A group of worksheet cells, which can be adjacent or nonadjacent;also called a range.
|
|
Cell Reference
|
The address of a cell indicating its column and row location.
|
|
Chart
|
A graph that provides a visual reprsentation of the workbook data.
|
|
Chart Sheet
|
a new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.
|
|
Code Window
|
The window that displays the VBA macro code associated with any item in the Project Explorer
|
|
Common field
|
A field that appears in more than one table in a database; used to relate tables.
|
|
Conditional format
|
A setting that applies formatting only when a cell's value meets a specified condition.
|
|
Constraint
|
A limit that is placed on the problem's solution
|
|
Control Structure
|
A series of commands that evaluates conditions in your program and then directs Excel to perform certain actions based on the status of those conditions.
|
|
Cost-Volume-Profit (CVP)Analysis
|
The relationship between a company's expenses, it's volume of business, and the resulting profit or net income; sometimes called break-even analysis.
|
|
Ctrl Key
|
Used to select nonadjacent range of cells; select a cell, press CTRL as you select each additional cell, then release the CTRL key
|
|
Data Table
|
A table that organizes the results of several what-if analysis within a single table.
|
|
Data validation
|
A set of rules that determine what users can enter in a specific cell or range.
|
|
Database
|
A collection of related tables stored in the same file.
|
|
Delimiter
|
A symbol usually a space, comma, or a tab that separates one column of data from another in a text file.
|
|
Documentation sheet
|
Reminds you why you created the workbook, it contains the name of the workbook, author, date created and description.
|
|
Embedded Chart
|
A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.
|
|
Excel Application
|
A spreadsheet written or tailored to meet the user's specific need's; usually includes specially designed reportsan/or charts data entry cells, custom interface and documation.
|
|
Excel Table
|
A range of data you can treat as a distinct object in a worksheet.
|
|
External Reference
|
A reference to a cell or range in a worksheet in another workbook.
|
|
Fill Handle
|
A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents.
|
|
Fixed Expense
|
An expense that must be paid regaurdless of slaes volume.
|
|
Fixed-Width text file
|
A file in which each column starts at the same location in the file.
|
|
Format Painter
|
A button on the ribbon that, when selected, copies a format from one cell range to another.
|
|
Formatting
|
To change the appearance, not the data, of your workbook.
|
|
Formula
|
A mathematical expression that calculates a value; all Excel formulas always begin with an Equal sign followed by an expression that describes
|
|
Freeze
|
The process of keeping rows/or columns you select visible in the workbook window as you scroll the worksheet.
|
|
Function
|
A predefined formula that performs calculations using specific values called arguments.
|
|
Function Procedure
|
A procedure that returns a value.
|
|
Goal Seek
|
An Excel analysis tool that automates the trial-and-error process by specifying a value for a calculated item and then returning the input value needed to reach that goal
|
|
IF function
|
A logical function that returns one value if the statement is true and returns a different value if the statement is false.
|
|
Insert Function Button
|
Organizes all of the functions by category and allows you to search for functions that perform particular calculations.
|
|
Landscape orientation
|
A type of page orientation in which the page is wider than it is tall; so that the text spands the widest part of the page.
|
|
Location
|
also called a path. Example:
='C:\ticketsales\domestic sales\[new mexico.xlsx]summary'!B6 |
|
Logical operator
|
An operator that combines expressions within a condition; used when writing conditions for control structures.
|
|
Lookup function
|
function returns a value from a range.
|
|
Lookup table
|
A table that organizes data you want to retrieve into different categories.
|
|
Macro
|
A series of stored commands that can be run whenever you need to perform the recorded tasks.
|
|
Method
|
A action that can be performed on an object, such as closing a workbook or printing the contents of a worksheet.
|
|
Mixed expense
|
An expense that is part variable and part fixed
|
|
Module
|
In VBA, a collection of sub procedures.
|
|
Name
|
A word or string of characters associated with a single cell or range.
|
|
Nonadjacent range
|
Cell range that is comprised of two or more seperate adjacent ranges.
|
|
Not binding contsraint
|
A consraint that was not a limiting factor in Solver arriving at the solution.
|
|
Object
|
Anything that can be manipulated independently as a whole, such as a chart, table picture, video or sound clip.
|
|
object-oriented programming
|
A programming language, such as VBA, in which tasks are performed by manipulating objects.
|
|
One-variable data table
|
A data table used in What-if-Analysis that includes one input cell and any number of result cells.
|
|
PivotTable
|
An interactive table that enables you to group and summarize either a range of data or an Excel table into concise, tabular format for easier reporting and analysis.
|
|
Portrait orientation
|
A type of page orientation in which the page is taller than it is wide.
|
|
Project
|
A collection of macros, worksheets, data-entry forms, and other items that make up the customized application you're trying to create.
|
|
Project Explorer
|
The window in the Visual Basic Editor that displays a hierarchial list of all currently open projects and their content
|
|
Properties window
|
The window that shows a list of properties for an object.
|
|
Query
|
A question you ask about the data in a database.
|
|
Relative reference
|
In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. When copied and pasted it will reflect the new location.
|
|
Scenario
|
a defined set of input values used to perform a What-if-analysis.
|
|
Scenario manager
|
An Excel feature used to create multiple scenarios, save them, and then switch between them to display the results of several What-if-analysis.
|
|
Scenario summary report
|
A report generated by the Scenario Manager that lists the values for the changing cells and result cells under each scenario.
|
|
Slack
|
The difference between the value in the cell and the value at the limit of the constraint
|
|
Solver
|
An Excel add-in program that searches for the optimal solution of a problem involving several variables.
|
|
Solver answer report
|
A report created by Solver that summarizes the results of a successful solution by displaying information about the target cell, changing cells and constraints.
|
|
Spreadsheet
|
A tool used in business for budgeting, inventory management, and decision making for analyzing and reporting information.
|
|
Sub procedure
|
In VBA, a macro procedure that performs an action on a project or workbook, such as formatting a cell or displaying a chart.
|
|
Query Wizard
|
An application included with microsoft to write database queries.
|
|
Subtotals command
|
Inserts a subtotal row into a range for each group of data and adds a grand total row below the last row of data.
|
|
Sum function
|
Adds a collection of numbers, where number1, number2, and so forth are either numbers or cell references.
|
|
Syntax
|
Rules that specify how a function or command should be written so that Excel or VBA interprets them correctly; the general syntax of all Excel functions is FUNCTION(argument1, argument1,...)
|
|
Table
|
A collection of data arranged in rows and columns.
|
|
Target cell
|
The cell that you want to maximize, minimize, or change to a specific value.
|
|
Template
|
A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.
|
|
Text file
|
A file type that contains only text and numbers without any formulas, graphics, special fonts, or formatted text.
|
|
Text Import Wizard
|
Determines whether the data is in a fixed-width format or a delimited format- and if it's delimited, what delimiter is used.
|
|
Two-variable data table
|
A data table used in a what-if analysis that uses two input cells, but displays only the value of a single result cell.
|