Wiley Microsoft Office Excel 2007 Formulas & Functions For Dummies 978-0-470-04655-5 Manuale Utente
Codici prodotto
978-0-470-04655-5
You can insert many new worksheets. The limit of how many is based on
your computer’s memory, but you should have no problem inserting 200 or
more. Of course we hope you have a good reason for having so many. Which
brings us to the next point.
your computer’s memory, but you should have no problem inserting 200 or
more. Of course we hope you have a good reason for having so many. Which
brings us to the next point.
Worksheets organize your data. Use them wisely and you will find it easy to
manage your data. For example, let’s say you are the boss (we thought you’d
like that!), and you have 30 employees that you are tracking information on
over the course of a year. You might have 30 worksheets — one for each
employee. Or you might have 12 worksheets — one for each month. Or you
may just keep it all on one worksheet. How you use Excel is up to you, but
Excel is ready to handle whatever you throw at it.
manage your data. For example, let’s say you are the boss (we thought you’d
like that!), and you have 30 employees that you are tracking information on
over the course of a year. You might have 30 worksheets — one for each
employee. Or you might have 12 worksheets — one for each month. Or you
may just keep it all on one worksheet. How you use Excel is up to you, but
Excel is ready to handle whatever you throw at it.
New Excel files default to having three worksheets. You can change this
default number on the Personalize tab in the Excel Options dialog box. To dis-
play the dialog box, click the Microsoft Office button and then click the Excel
Options button.
default number on the Personalize tab in the Excel Options dialog box. To dis-
play the dialog box, click the Microsoft Office button and then click the Excel
Options button.
Introducing the Formulas Ribbon
It’s a fact of life — or rather, a fact of Microsoft marketing — that each new
release of Office has a slightly different look. The folks at Microsoft went
whole hog with Office 2007. Imagine this — no menus or toolbars. These have
been such staples of Windows applications that only something amazing
could upstage them.
release of Office has a slightly different look. The folks at Microsoft went
whole hog with Office 2007. Imagine this — no menus or toolbars. These have
been such staples of Windows applications that only something amazing
could upstage them.
Without further ado, we present the Ribbon. The Ribbon sits at the top of the
application where menus used to unfold and toolbars made their home. A few
items do appear as menu headers along the top of the Excel screen, but they
actually work more like tabs. Click them and no menus appear. Instead, the
Ribbon presents the items that are related to the clicked header.
application where menus used to unfold and toolbars made their home. A few
items do appear as menu headers along the top of the Excel screen, but they
actually work more like tabs. Click them and no menus appear. Instead, the
Ribbon presents the items that are related to the clicked header.
Figure 1-5 shows the top part of the screen, in which the Ribbon displays
the items that appear when you click the Formulas header. In the figure, the
Ribbon is set to show formula-based methods. Along the left, functions are
categorized. One of the categories is opened to show how you can access a
particular function.
the items that appear when you click the Formulas header. In the figure, the
Ribbon is set to show formula-based methods. Along the left, functions are
categorized. One of the categories is opened to show how you can access a
particular function.
Figure 1-4:
Inserting
a new
worksheet.
11
Chapter 1: Tapping into Formula and Function Fundamentals
05_046555 ch01.qxp 12/26/06 7:54 PM Page 11