User Manual

PowerPoint 2007 now use the Microsoft Excel 2007 charting engine, making cre-
ating charts much easier and more powerful within those applications too. So you
can take the charts you create in Excel 2007 into PowerPoint 2007 and Word 2007
for great presentations and reports. You heard it here first!
Figure 1-7
A common forma
t
choice
9
Chapter 1 — The Four-One-One of Excel
Geek Facts 1.1
How about the geeky cool things? Now you can show off your geek-skills: Excel 2007
can hold more than 1 million rows of data.Want more?
Total number of columns in Excel 2007 is now 16,384; it was 256.
Total number of rows is now 1,048,576; it was 65,536.
The number of unique colors allowed in a single workbook is now 4.3 billion;
it was 56. But please follow your good sense and use color coordination.
The number of levels of sorting you can perform on a range of tables is now 64;
it was 3.
The number of items allowed in the Filter drop-down is now 10,000;it was 1,000.
The maximum number of characters allowed in formulas is 8,000; it was 1,000.
The maximum number of arguments allowed to a function is now 255; it was 30.
05 149164-ch01.qxp 7/16/08 2:17 PM Page 9