Cell – Intersection of a column and a row, contains data ...



= (equal sign) – Symbol used at start of every Excel formula

Autofit – Double-clicking the end border of a column (or row) to change the width (or height) to match the widest (or tallest) entry of that column (or row).

Autosum – Icon used to derive a formula for a row- or column-total.

Average - Math operation for calculating the mean of number values in cells.

Borders – Lines created along the edge(s) of cells.

Cell – Intersection of a column and a row, contains data (text, number value, or formula)

Every cell has a unique address which is its column letter + its row number

Column – One of 16,384 vertical blocks, each containing over 1 million rows of cells.

Count - Math operation for counting the number of cells containing number values.

Ctrl-Home – Special key sequence which makes the active cell be the upper-left corner of the worksheet.

Footer – Same as for Header, except at the bottom of every page.

Function – One of many pre-determined math/logic operations Excel knows how to perform.

Header – Data appearing at the top of every spreadsheet page. A common way to create one is from the menu Insert | Header&Footer

If – Logical function that allows Excel to decide between two methods from which to derive a cell’s contents. Format is: =IF(condition, value if true, value if false)

Named Range – A cell or group of cells to which an English-like nametag has been given

(to make it easier for the user to which to refer).

Range – Group of continuous rectangular block of cells with a common relationship.

Row – One of over 1 million horizontal blocks, each containing 16,384 columns of cells.

Sum – Math operation for totaling number values in cells, the most often-used type of calculation done by spreadsheets.

Vlookup – Math function that has Excel match a cell’s value with a vertically aligned category of a table, and return a corresponding value from another table column as this cell’s value. Example, in cell A13: =VLOOKUP(C13, Grades, 2)

What If? – Refers to the main type of problems solved by spreadsheets,

Workbook (Book) – A spreadsheet containing 255 identical worksheets. Excel can have up to 16 open workbooks at the same time.

Worksheet (Sheet) – An electronic grid of rows and columns with 16,384 columns and over 1 million rows. The columns are letter-id’s from A through XFD, and the rows are number-id’s from 1 through 1,048,576. Data can be stored in a cell, the intersection of a row and column. Each cell has a unique address which is a combination of the column & row of intersection.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download