What functions are new to excel 2007?

Microsoft Excel 2007

-

It is a program used to create, format, analyse and compute numbers. It displays data in row-and-column format. MS Excel makes it easy to compute numbers and allows different ways to format data including charts and reports.

-

It is a very powerful electronic spreadsheet that lets the user enter and use numerical data with formulas and built-in functions.

A Workbook

is a file in MS Excel that holds worksheets.A

Worksheet

is composed of columns and rows that are similar to an accounting ledger. It displays characters like letters, and numbers, and can do computations. Excel 2007 has 1,048,576 rows, and 16,384 columns.

Parts and Uses of the MS Excel Environment

1.

Toolbars

- display commands that are commonly used for easy access

2.

Name Box

- displays the address of the active cell

3.

Formula bar

- displays the contents and formula entered on the active cell

4.

Status bar

- displays the information about a selected command

5.

Select all Button

- selects every cell in a worksheet

6.

Sheet Tabs

- let you display worksheets in the open workbook

7.

Row headers

- a number used to identify a row

8.

Column headers

- a letter used to identify a column

9.

Active cell

- the cell that has a thick border that will hold any data that you type or entered

10.

Scroll bars

- includes vertical and horizontal scroll bar and four arrow used to move the screen display horizontally or vertically

11.

Title bar

- displays the program and the name of the workbook that you are currently using

12.

Menu bar (7 Tabs)

- lists the names of the menus or tabs in Excel

13.

Minimize button

- minimizes the window to a button on the task bar

14.

Maximize/Restore button

- switch between maximizing a window and restoring a window to its previous size

15.

Close button

- closes the window