EXCEL lesson 1

formula bar

A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.

cell

A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.

column

A column is a vertical series of cells in a chart, table, or spreadsheet.

formula

A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).

workbook

A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.

portrait orientation

Applies To: Excel 2007, Less...By default excel prints worksheets in portrait orientation.

name box

Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. To name a cell or range, type the name in the Name box and press ENTER. To move to and select a named cell, click its name in the Name box.

landscape orientation

By default, Excel prints worksheets in portrait orientation.

sheet tab

In Microsoft this is the current worksheet that is being displayed.

adjacent range

Just press and hold down the Ctrl Key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet.

microsoft excel 2010

Microsoft Excel is a spreadsheet program included in the microsoft office suite of applications.

range reference

Name a range of cells. IN excel you can create names that refer to a single cell a group of cells on the worksheet, a specific value or a formula. after you define excel names you can use the names in a formula instead of using a constant value or cell reference

nonadjacent range

Range overview. A range is a group or block of cells in a worksheet that have been selected or highlighted

worksheet

The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.

active cell

The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.

cell reference

The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.

active worksheet

The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.

range

Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.

row

a row is a series of data banks laid out in a horizontal fashion.

spreadsheet

an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in caluculations