Datasheet
These categories are along the bottom of the Formulas Ribbon:
Function Library: This includes the Function Wizard, the AutoSum fea-
ture, and the categorized functions.
Named Cells: These features manage named areas. In fact, the new
Name Manager is here, a brand-new Excel 2007 feature.
Formula Auditing: These features have been through many Excel incar-
nations, but never before have the features been so prominent. Also
here is the Watch Window, which lets you keep an eye on the values in
designated cells, but within one window. In Figure 1-6 you can see that a
few cells have been assigned to the Watch Window. If any values change,
you can see in the Watch Window. Note how the watched cells are on
sheets that are not the current active sheet. Neat!
Calculation: This is where you manage calculation settings, such as
whether calculation is automatic or manual.
Solutions: Any loaded add-ins that provide further functions appear
here. In Figure 1-5, the Data Analysis Add-in is just another name for the
ever-popular Analysis ToolPak.
Another new feature that goes hand in hand with the Ribbon is the Quick
Access Toolbar. (So there is a toolbar after all!) In Figure 1-5 the Quick Access
Toolbar sits just under the left side of the Ribbon. On it are icons that per-
form actions with a single click. The icons are ones you select by using the
Customization tab in the Excel Options dialog box. You can put the toolbar
above or below the Ribbon by right-clicking the Quick Access Toolbar and
choosing the option.
Formula Ribbon
Clicking a category to access
particular function
Also known as
Analysis ToolPak
Figure 1-5:
Getting to
know the
Ribbon.
12
Part I: Putting the Fun in Functions
05_046555 ch01.qxp 12/26/06 7:54 PM Page 12