Laptops All-in-One Desk Reference For Dummies- P34: Okay, I’ll admit it: I’ve got a strange biography. I’ve been a writer all my life. My first semi-pro job was sports editor of my high school newspaper. (Go Commodores!) After college I was a political reporter for daily newspapers in Ohio and New York (I covered four national nominating conventions and two Presidential campaigns) and a correspondent for The Associated Press. And then, in 1983, I gave in to my inner geek and became the first Executive Editor of PC Magazine, back in the days when most people asked, “What is a PC?”. | 304 Spreading out an Excel 2007 Sheet You can directly enter a financial function like one of those just listed. If you re a pro you could rattle this one off in your sleep YIELD-MAT 1012008 1012009 12152007 95 2 . However for the rest of us help is available just a few clicks away. In previous versions of Excel you could go to the Help system to see available functions with instructions on using them. With the arrival of Excel 2007 a Function Library has been installed in the ribbon bar at the top of the screen. 1. To use the library click the Formulas tab. 2. Locate the Function Library. See Figure 2-2. 3. Click the pull-down button to display installed functions. 4. Choose from the following options Financial. Banking loans investments amortization and similar functions. Math and Trig. Mathematical and trigonometric calculations. Statistical. Average median percentile and correlation calculations. Engineering. Binary decimal and octal conversions as well as specialized features. Figure 2-2 The statistical functions pull-down menu of the Functions Library is one of the key improvements in Microsoft Excel 2007. Printing Excel Spreadsheets 305 On the logical side you can also choose from functions for AND OR IF TRUE FALSE and others. Date and time functions calculate the number of days between dates to insert the current or a future date and even to calculate hours minutes and seconds between specified moments in time. Entering data in a cell To directly enter numbers text or a formula into a cell use the pointer to click on a location. Type the numbers of text and then press Enter to enter the text and move down a cell in the same column or Tab to enter the text and move one column over to the right . To enter more text data on a new line within the same cell enter a line break by pressing the key combination Alt-Enter. To enter dates in a cell use the pointer to click a location. To enter a date use a slash or a hyphen to separate the parts of a date. For .
