• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/80

Click to flip

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.