Wiley Microsoft Office Excel 2007 Formulas & Functions For Dummies 978-0-470-04655-5 User Manual
Product codes
978-0-470-04655-5
Excel 2007 files have the .xlsx extension. Older version Excel files have the
.xls extension.
.xls extension.
When Excel starts up, it displays a blank workbook ready for use. If at any
time you need another new workbook, click the Microsoft Office button and
click on New. You will be presented with a plateful of templates, including a
blank workbook. That’s the baby you want, so give it a click to select it and
then click the Create button. A new workbook will open. When you have
more than one workbook open, you pick the one you want to work on by
selecting it in the Windows Taskbar.
time you need another new workbook, click the Microsoft Office button and
click on New. You will be presented with a plateful of templates, including a
blank workbook. That’s the baby you want, so give it a click to select it and
then click the Create button. A new workbook will open. When you have
more than one workbook open, you pick the one you want to work on by
selecting it in the Windows Taskbar.
A worksheet is where your data actually goes. A workbook contains at least
one worksheet. If you didn’t have at least one, where would you put the data?
Figure 1-2 shows an open workbook that has three sheets — Sheet1, Sheet2,
and Sheet3. You can see these on the worksheet tabs near the bottom left of
the screen.
one worksheet. If you didn’t have at least one, where would you put the data?
Figure 1-2 shows an open workbook that has three sheets — Sheet1, Sheet2,
and Sheet3. You can see these on the worksheet tabs near the bottom left of
the screen.
At any given moment, one worksheet is always on top. In Figure 1-2, Sheet1
is on top. Another way of saying this is that Sheet1 is the active worksheet.
There is always one and only one active worksheet. To make another work-
sheet active, just click its tab.
is on top. Another way of saying this is that Sheet1 is the active worksheet.
There is always one and only one active worksheet. To make another work-
sheet active, just click its tab.
Figure 1-2:
Looking at a
workbook
and
worksheets.
9
Chapter 1: Tapping into Formula and Function Fundamentals
05_046555 ch01.qxp 12/26/06 7:54 PM Page 9