Microsoft Office Excel 2003, Volume 1For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
|
From inside the book
Results 1-3 of 18
Page 162
... functions in various categories . Financial functions , such as the PMT function we are about to study , are especially important in business . The PMT function requires three arguments ( the interest rate per period , the number of ...
... functions in various categories . Financial functions , such as the PMT function we are about to study , are especially important in business . The PMT function requires three arguments ( the interest rate per period , the number of ...
Page 172
... formula in cell B6 ) is inter- preted to mean " divide the contents of the cell one column to the left by 12. " Thus , when the PMT function in cell B6 is copied to cell B7 , it ( the copied formula ) is adjusted to maintain this ...
... formula in cell B6 ) is inter- preted to mean " divide the contents of the cell one column to the left by 12. " Thus , when the PMT function in cell B6 is copied to cell B7 , it ( the copied formula ) is adjusted to maintain this ...
Page 176
... Formula bar displays function entered in cell B6 □ Click in cell B6 and enter the formula = PMT ( A6 / 12,30 * 12 , - $ C $ 1 ) as shown in Figure 4.8c . Note the ScreenTip that appears as you enter the function to indi- cate the order ...
... Formula bar displays function entered in cell B6 □ Click in cell B6 and enter the formula = PMT ( A6 / 12,30 * 12 , - $ C $ 1 ) as shown in Figure 4.8c . Note the ScreenTip that appears as you enter the function to indi- cate the order ...
Contents
What Is a Spreadsheet? | 1 |
The File Menu | 9 |
HANDSON EXERCISE | 38 |
Copyright | |
15 other sections not shown
Other editions - View all
Microsoft Office Excel 2003: Comprehensive Robert T. Grauer,Maryann Barber No preview available - 2006 |
Common terms and phrases
3½ Floppy Arial arrow CD-RW CD-RW Drive cell formulas Click and drag Click in cell Click OK Control Panel Copy create Data Window Help Date Modified Delete desktop dialog box Documents folder Double click drag to select Edit View Favorites Edit View Insert Exercise 3 continued Favorites Tools Help File Edit View floppy disk Format Iools Data Goal Seek Hands-on Exercise Homework icon Insert Format Iools Internet Explorer KB Microsoft Office KB Microsoft Word menu and click Microsoft Excel Microsoft Office Excel Microsoft PowerPoint Microsoft Word Document Network Places Office Excel Worksheet option Print question for help Recycle Bin Right click right pane Save the workbook screen Search Folders semester average Sheet1 shortcut shown in Figure spreadsheet Start menu step task pane taskbar text box Tools Data Window Type a question View Favorites Tools View Insert Format Windows Explorer Windows Messenger Windows XP