Tuesday, April 26, 2011

Worksheet

Which problems are worked out or solved and answers recorded.

Workbook

Composed of one or more worksheets and additional Visual Basic for Applications code. The RealCost software is a workbook.

Value

A numerical quantity measured or assigned or computed.

Theme

A preset package containing graphical appearance details, used to customize the look and feel of (typically) an operating system, widget set or window manager.

Table Styles

A set of formatting options, such as font, border style, and row banding, that are applied to a table. The regions of a table, such as the header row, header column, and data area, can be variously formatted.

Statistical Functions

Can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you.

Spreadsheet

A computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing either alphanumeric text or numeric values.

Split

Divide: separate into parts or portions.

Smartart

Microsoft Office 2007 (officially called 2007 Microsoft Office System) is the most recent Windows version of the Microsoft Office System, Microsoft's productivity suite. Art you can create.

Sheet Tab

A tab at the bottom of a work sheet that acts as a means to identify or access different sheets within a workbook.

Row Heading

A number on the left side of the grid that identifies each row.

Row

An arrangement of objects or people side by side in a line.

Relative Cell References

A relative cell reference identifies the location of a cell or group of cells.

Range

The set of values of the dependent variable for which a function is defined.

Order Of Evaluation

Most operators do not guarantee a particular order of evaluation for their operands.

Operator

A symbol or function representing a mathematical operation.

Operand

An operand is an expression used as an argument to an operator.

Mixed Cell Reference

In Excel cell references are used in formulas, functions, charts, and other Excel commands.

Microsoft Excel

A spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications).

Mathematical Functions

In mathematics, a function is a relation between a given set of elements called the domain and a set of elements called the codomain.

Macro

A single computer instruction that results in a series of instructions in machine language.

Header Row

A header supplies a meaningful name for referencing a row or column, and hence a cell.

Grid

A pattern of regularly spaced horizontal and vertical lines.

Graph

A graph is an abstract data structure that is meant to implement the graph concept from mathematics.

Function Formula

Excel SUM Function/Formula. Add Numbers, or a Range of Cells With SUM Formula.

Freeze

A point in time in the development process after which the rules for making changes to the source code or related resources become more strict, or the period during which those rules are applied.

Formula

A group of symbols that make a mathematical statement.

Filter

A program that gets most of its data from its standard input (the main input stream) and writes its main results to its standard output (the main output stream). UNIX filters are often used as elements of pipelines.

Embedded Chart

When a chart is drawn on the same worksheet as the data.

Complex Formulas

In excel: Fill a formula to another cell; Copy and paste a formula to another cell; Revise a formula; Create an absolute reference.

Column Heading

A standard Windows control that can be used to provide interactive column titles for a list.

Column

A line of units following one after another.

Chart

A visual representation of data. A chart can represent tabular numeric data, functions or some kinds of qualitative structures.

Cell Style

Gets or sets the style applied to all cells in the DataGrid.

Cell Reference

The column number and the row letter of a cell.

Cell

Reference as used in spreadsheets such as Excel.

Autofill

A function in some computer applications or programs, typically those containing forms, which fills in a field automatically.

Argument

A reference or value that is passed to a function, procedure, subroutine, command, or program.

Active Cell

The cell you are currently working on.

Absolute Cell Reference

A formula that does not change when the formula is copied elsewhere.

Sunday, April 10, 2011

XML Paper Specification

It is a specification for a page description language and a fixed document format originally developed by Microsoft as XML Paper specification.

Word Processor

An application that provides the user with tools needed to write and edit and format text and to send it to a printer.

Thumbnails

Reduced-size versions of pictures, used to help in recognizing and organizing them, serving the same role for images as a normal text index does for words.

Text Box

It is a common element of graphical user interface of computer programs, as well as the corresponding type of widget used when programming GUIs.

Style

An additional format performed on characters.

Soft Copy

Matter that is in a form that a computer can store or display it on a computer screen.

Splitting Cells

It is the function in database software that allows multiple adjacent cells to be combined into a single larger cell.

Sizing Handles

It is a graphical indicator in a Graphical User Interface that allows users to click and drag on the indicator to resize the object.

Section Break

A special character that terminates a section and acts as a repository for the properties of the specified section.

Read-Only Document

It is a file which you can open and look at, but which you cannot change and save under the same file name.