Datasheet

 Help button: On the far right of the Ribbon is the help button (the question
mark). Click this button for general Excel help.
 Menu, rich: Rich menus are new in Excel 2007. Each menu choice has an
illustrative graphic, the command name, and in some cases a short
description of what the command does.
Don’t confuse rich menus with drop-down galleries, although they look
similar. Menus contain related commands. Galleries allow you to choose
from among a set of formats or layouts.
 Menu, standard: Most users are already familiar with this form of menu —
a drop-down list of choices with command names (such as Paste or Insert
Cells). Some command names have small associated icons. If you click a
command name that ends with an ellipsis (...), Excel displays a dialog box
that presents further choices.
 Spinner: A control with two arrows (one pointing up, the other pointing
down) used with an input box to specify a number (height or width, for
example.) Clicking an arrow increases or decreases the number in the
input box. You can also enter a number in the box directly. The spinner
control allows you to use only valid numbers.
 Tab, contextual: Contextual tabs give the Ribbon the power to expose all
features in Excel. One or more contextual tabs appear after you insert or
select an object, such as a chart, shape, table, or picture. For example,
after you insert a chart, three contextual tabs related to chart functionality
appear on the Ribbon and a header labeled Chart Tools appears on the
Excel title bar above the contextual tabs. Contextual tabs contain all the
commands you need for working with the particular object. After you
deselect an object, the contextual tabs (and the header) disappear.
The general rules that govern the display of contextual tabs follow:
• After you select an object (such as a chart, shape, or table), one or
more contextual tabs for the object appear on the Ribbon. You must
select a tab to display the associated commands.
• After you insert an object, Excel displays the commands for the first
tab of the contextual tab set for that object.
• After you double-click an object, Excel displays the commands for the
first tab of the contextual tab set for that object. Note that not all
objects have this double-click capability.
• After you select, deselect, and then reselect the object without using
any other commands in-between, Excel displays the commands for the
first tab of the contextual tab set for that object.
10 Part 1: Getting to Know Excel 2007
03_046716 ch01.qxp 11/16/06 6:40 PM Page 10