Excel 2007 User interface – Formulas Tab

Formulas Tab

The formulas tab in Excel 2007 ribbon consists of 5 groups that deal with formulas and functions:

Function Library

Chose from a set of Excel 2007 built-in functions. Functions are divided into groups for easy access.

Defined Names

Manage names of ranges. Create, edit, delete or use in formulas.

Formula Auditing

Show or hide formulas, trace dependents, check errors … etc.

Calculation

Specify calculations options for formulas : manual, automatic … etc.

Solutions

From here you can use the conditional sum wizard and lookup wizard to help you in creating new formulas.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007

Related posts:

1. Excel 2007 user interface – introduction
2. Excel 2007 User interface – the Insert Tab
3. Excel 2007 User interface – Page Layout Tab
4. Excel 2007 user interface – the Home Tab
5. How to create a user-defined function