Saturday, April 23, 2011

Worksheet



One spreadsheet in a workbook

Workbook



A spreadsheet document that contains one or more worksheets.

Value



a numerical quantity measured or assigned or computed

Theme



In computing, a theme is 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 Style



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



functions based on statistics

Spreadsheet



A spreadsheet is 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



separate into parts or portions

SmartArt



SmartArt, found under the Insert tab in the ribbon in PowerPoint, Word, Excel, and Outlook, is a new group of editable and formatted diagrams.

Sheet Tab



the indicator for a worksheet, located in the lower left corner of the workbook window

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



the relative cell refverences in the formula identify the location of the data

Range



the limits within which something can be effective

Order of Evaluation



the order that stuff need to be put upon to be solved

Operator



an operator is a type of function.

Operand



a quantity upon which a mathematical operation is performed

Mixed Cell Reference



It is a cell reference that has either the row or column is made absolute, but not both, using the dollar sign.

Microsoft Excel



Microsoft Excel (full name Microsoft Office Excel) is 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. The function associates each element in the domain with exactly one element in the codomain.

Macro



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

Header Row



a header row formats the top row of the table specially

Grid



a pattern of regularly spaced horizontal and vertical lines

Graph



A graph is an image or chart representation used to show a numerical relationship.

Funtion Formula



a formula for a specific function

Freeze



 when your computer stops responding or becomes immobilized

Formula



an entity constructed using the symbols and formation rules of a given logical language.

Filter



A filter is a computer program to process a data stream

Embedded Chart



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

Complex Formulas



Formulas that are not easy to solve

Column Heading



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

Column



a page or text that is vertically divided

Chart



A chart is a visual representation of data, in which "the data are represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of qualitative structures

Cell Style



A cell's style refers to a GridStyleInfo class object that encapsulates all the state information concerning a cell.

Cell Reference



The column number and the row letter of a cell

Cell



a section in a row and column in excel

AutoFill



Autofill is 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



An active is the cell you are currently working on

Absolute Cell Reference



A cell reference in a formula that does not change when the formula is copied elsewhere. It absolutely always stays the same. Usually has $ sign in front of the row and column references. For example: $A$1

Thursday, April 7, 2011

Do Now 4/7/11

Headers and footers are important because they are useful for keeping documents intact, for example, when a document is dropped or a part of it is misfied.

Saturday, April 2, 2011

XML Paper Specification



The Open XML Paper Specification (also referred to as OpenXPS), is a specification for a page description language and a fixed-document format originally developed by Microsoft as XML Paper Specification (XPS) that was later standardized by Ecma International as international standard ECMA-388.

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



Thumbnails are 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



A text box, text field or text entry box is a common element of graphical user interface (GUI) of computer programs, as well as the corresponding type of widget used when programming GUIs. A text box's purpose is to allow the user to input text information to be used by the program.

Style



a mixture of font, size, bold, italic, underline create a certain style

Splitting Cells



to divide cells by 2 or more

Soft Copy



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

Sizing Handles



handles used to minimize or maximize windows explorer

Section Break


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

Read-Only Document



a document that could only be read and cannot be editied