Saturday, April 16, 2011

Statistical Functions

Statistical functions including AVERAGE, MAX, MIN, and MEDIAN are found on a continuation menu accessed from the More Functions command button’s drop-down menu on the Formulas tab. Excel includes one of the most complete sets of statistical functions available outside a dedicated statistics software program.

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

the Split Cells command allows you to divide an existing table cell into rows or columns. This may cause the Rows Spanned and Column Spanned table cell properties to change for surrounding cells.

SmartArt

Microsoft Office 2007 is the most recent Windows version of the Microsoft Office System, Microsoft's productivity suite.

Sheet Tab

In spreadsheet applications, this would refer to 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

In the context of a relational database, a row also called a record or tuple represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields.