Spreadsheet Final Exam

Scenario

a defined set of input values used to perform a What-if-analysis.

Lookup function

function returns a value from a range.

Method

A action that can be performed on an object, such as closing a workbook or printing the contents of a worksheet.

Format Painter

A button on the ribbon that, when selected, copies a format from one cell range to another.

AutoSum

A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic.

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.

Table

A collection of data arranged in rows and columns.

Project

A collection of macros, worksheets, data-entry forms, and other items that make up the customized application you're trying to create.

Database

A collection of related tables stored in the same file.

Not binding contsraint

A consraint that was not a limiting factor in Solver arriving at the solution.

Binding Constraint

A constraint in which Solver was forced to include the constraint as part of the final solution.

One-variable data table

A data table used in What-if-Analysis that includes one input cell and any number of result cells.

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.

Common field

A field that appears in more than one table in a database; used to relate tables.

Fixed-Width text file

A file in which each column starts at the same location in the file.

Text file

A file type that contains only text and numbers without any formulas, graphics, special fonts, or formatted text.

Chart

A graph that provides a visual reprsentation of the workbook data.

Cell Range

A group of worksheet cells, which can be adjacent or nonadjacent;also called a range.

Constraint

A limit that is placed on the problem's solution

IF function

A logical function that returns one value if the statement is true and returns a different value if the statement is false.

Formula

A mathematical expression that calculates a value; all Excel formulas always begin with an Equal sign followed by an expression that describes

Function

A predefined formula that performs calculations using specific values called arguments.

Function Procedure

A procedure that returns a value.

object-oriented programming

A programming language, such as VBA, in which tasks are performed by manipulating objects.

Query

A question you ask about the data in a database.

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.

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.

Scenario summary report

A report generated by the Scenario Manager that lists the values for the changing cells and result cells under each scenario.

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.

Macro

A series of stored commands that can be run whenever you need to perform the recorded tasks.

Data validation

A set of rules that determine what users can enter in a specific cell or range.

Conditional format

A setting that applies formatting only when a cell's value meets a specified condition.

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.

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.

Delimiter

A symbol usually a space, comma, or a tab that separates one column of data from another in a text file.

Lookup table

A table that organizes data you want to retrieve into different categories.

Data Table

A table that organizes the results of several what-if analysis within a single table.

Spreadsheet

A tool used in business for budgeting, inventory management, and decision making for analyzing and reporting information.

Portrait orientation

A type of page orientation in which the page is taller than it is wide.

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.

Name

A word or string of characters associated with a single cell or range.

Template

A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.

Sum function

Adds a collection of numbers, where number1, number2, and so forth are either numbers or cell references.

Solver

An Excel add-in program that searches for the optimal solution of a problem involving several variables.

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

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.

Query Wizard

An application included with microsoft to write database queries.

Mixed expense

An expense that is part variable and part fixed

Fixed Expense

An expense that must be paid regaurdless of slaes volume.

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.

Logical operator

An operator that combines expressions within a condition; used when writing conditions for control structures.

Object

Anything that can be manipulated independently as a whole, such as a chart, table picture, video or sound clip.

Nonadjacent range

Cell range that is comprised of two or more seperate adjacent ranges.

absolute reference

Cell reference that points to a specific cell and does not change when copied;appears with a $.

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.

Module

In VBA, a collection of sub procedures.

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.

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.

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.

Insert Function Button

Organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Documentation sheet

Reminds you why you created the workbook, it contains the name of the workbook, author, date created and description.

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,...)

argument

Specifies the numbers, text or a cell reference used by the function to calculate a value.

Cell Reference

The address of a cell indicating its column and row location.

Target cell

The cell that you want to maximize, minimize, or change to a specific value.

Slack

The difference between the value in the cell and the value at the limit of the constraint

Break-even point

The point where revenue equals expenses.

Freeze

The process of keeping rows/or columns you select visible in the workbook window as you scroll the worksheet.

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.

3-D reference

The same cell or range in multiple worksheets in the same workbook.

Project Explorer

The window in the Visual Basic Editor that displays a hierarchial list of all currently open projects and their content

Code Window

The window that displays the VBA macro code associated with any item in the Project Explorer

Properties window

The window that shows a list of properties for an object.

Formatting

To change the appearance, not the data, of your workbook.

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

add-in

a customized program that adds commands and features to Microsoft Office Programs

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.

Location

also called a path. Example:

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.